Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: Delphi-BCB/Midas/TDataSetProvider    [ Add a report in this area ]  
Report #:  7163   Status: Closed
PacketRecords <> -1 and duplicate records causes Key Violation error
Project:  Delphi Build #:  7.0.4.453
Version:    7.0 Submitted By:   Craig Stuntz
Report Type:  Basic functionality failure Date Reported:  2/3/2004 1:16:02 PM
Severity:    Infrequently encountered problem Last Updated: 3/20/2012 2:24:39 AM
Platform:    All platforms Internal Tracking #:   167220
Resolution: Won't Do (Resolution Comments) Resolved in Build: : 9.0.1761.24408
Duplicate of:  4498
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
When PacketRecords <> -1 and the number of records is > PacketRecords and there are duplicate records, attempting to fetch the second data packet will cause a key violation error.  This happens with or without parameters on the query.
Steps to Reproduce:
Open the attached application in Delphi.  You don't even have to compile it.  The app uses InterBase's employee.gdb sample database.  Set the CDS active and scroll down in the grid until you have passed the 200th record.  You'll get a Key violation error.
Workarounds
None
Attachment
DataSnapBug.zip
Comments

Dave Rowntree at 2/4/2004 4:48:43 AM -
There doesn't appear to be an attached test case app Craig.

Craig Stuntz at 2/4/2004 6:22:50 AM -
Sorry, I'll fix that.  QC client bug, I think -- I attached the test case but it seems to have gone elsewhere.

Dave Rowntree at 2/4/2004 7:00:49 AM -
I've had that happen too. Never been able to pin it down though.

Craig Stuntz at 2/4/2004 6:27:54 AM -
Should be there now.  I enhanced the description, too.

Dave Rowntree at 2/4/2004 7:26:39 AM -
Ah, now I understand. The old incremental fetching, duplicate record bug <g>. I was getting concerned till you added that to the description.

I have marked this report as a duplicate. Please would you update your RAID report 195195 accordingly. Thanks Craig.

Craig Stuntz at 2/6/2004 9:12:24 AM -
I don't have the ability to create duplicate resolutions in the internal system, but I added a comment to the report.  Thanks.  I wonder why the duplicate didn't come up when I searched for Key violation.  Weird.

Dave Rowntree at 2/11/2004 8:40:20 AM -
The search deosn't work for me either. Maybe it's because in QC#4498 the words 'Key Violation' are in single quotes. I have entered a report on this, QC#7257.

Dave Rowntree at 2/4/2004 7:45:11 AM -
P.S. I put a workaround against QC#4498.

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.