Nested ClientDataSets

Nested ClientDataSets

Post by John Speigh » Sun, 31 Dec 1899 09:00:00

I'm trying to create a nested table inside a client dataset by using the
Fields Editor as outlined in the help file. When I create a persistent
field of type Dataset and then try to create the master dataset, I get an
'invalid field type' error. Without this field, it works without a problem.

Any guidance would be appreciated.



1. MS SQL Server 7, ClientDatasets and miliseconds in Dates

I just converted my application from Interbase to SQL Server 7 and ran into
the following problem:
I am retrieving and updating records using a query and client-datasets. The
key of the record has a datetime field. I can retrieve the records fine but
the client dataset does not find the original record anymore when I try to
apply the updates. SQL Server uses milliseconds to store datetimes and
Interbase doesn't. I looked at the SQL-Data being exchanged and saw that the
milliseconds used to update the record are off by a few milliseconds
compared to the value stored in the database. I asked Borland and they said
that their internal datetime does not have enough room to store the
milliseconds properly...
Does anyone know how to get around this? It is very annoying.... Thanks,

2. REQ: What are the best Data Warehouse Websites?

3. Clientdatasets don't seem to help (speed) when updating MS SQL

4. Execute DTS packages through sp_OA....

5. ClientDataSets con Delphi5 Enterprise

6. CDaoDatabase, Access, & OLE Automation Error

7. !---Nested Fetch in Nested While

8. How to call Jobs in SQL Server Agent from stored procedure???

9. Oracle8 - nested tables within nested tables?

10. execute and nested SQL

11. Problems with nested cursors in SQL Server 2000.

12. Need to Nest Case deeper?

13. SQL Server Nested INNER JOIN Update