Watch, Follow, &
Connect with Us
Public Report
Report From: Delphi-BCB/Midas/TClientDataSet    [ Add a report in this area ]  
Report #:  3974   Status: Closed
TClientDataset PersistantField.Size problem
Project:  Delphi Build #:  7.04
Version:    7.0 Submitted By:   henk holterman
Report Type:  Minor failure / Design problem Date Reported:  4/2/2003 6:01:22 AM
Severity:    Infrequently encountered problem Last Updated: 6/27/2006 12:27:44 PM
Platform:    95, 98, 2000, NT, XP Internal Tracking #:   159049
Resolution: Fixed (Resolution Comments) Resolved in Build: : 7.0.8.1
Duplicate of:  None
Voting and Rating
Overall Rating: (2 Total Ratings)
4.50 out of 5
Total Votes: None
Description

When the size of a Persistent field is set too large it will overwrite neighbouring fields on Post.

Steps to Reproduce:

See attachments for a sample project agianst EMPLOYEE.GDB

All components are setup the standard way but  ClientDataSet1CONTACT_FIRST.size = 20  (in the database it is a VARCHAR(15) field)

When typing more than 15 characters in the CONTACT_FIRST column both itself and neighbouring columns can get strange values on Post.


-hh-
Workarounds
In DB.pas, add ftString to the CheckTypeSizes constant defined in TDataSet.CheckFieldCompatibility.  This will cause an exception to be raised when the size of the persistent field is not in sync with the size of the field in the underlying table.
Attachment
cdsfieldsize.zip
Comments

henk holterman at 4/2/2003 6:03:23 AM -
sorry,
couldn't work the attacments thingy. But steps should be sufficient.

Dave Rowntree at 4/2/2003 8:32:24 AM -
To add an attachment ...
Put the project files you want in the attachment into a zip file. Click 'File | Add Attachment' in the menu. Point to  your zip file and click Open.

Dave Rowntree at 4/3/2003 12:36:05 PM -
Dave Rowntree said - "To add an attachment ...
Put the project files you want in the attachment into a zip file. Click 'File | Add Attachment' in the menu. Point to  your zip file and click Open.
"

Ah ... that of course presumes you are using the GUI client, not the web client.

If you dont have the GUI client, if you would like to email me the zip file containing your test case app, I will attach it to this report.

henk holterman at 4/4/2003 4:00:21 AM -
Dave,

thanks but I found it (again (:-)


Server Response from: CODE1