Board index » delphi » Nested Table Problem
John
 Delphi Developer |
Nested Table Problem2003-12-04 09:21:45 PM delphi85 Hi, I'm having exactly the same problem as the user below....(a very old post...) Is there a solution? Thanks for any help John Quote>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> pfinKey values for each key field in ADOdataset's and CDS's are set to true. 2 Clientdatasets, 1 is a nested (detail) table with the datasetfield field set, the other is the master. With all options cleared and ResolveToDataset set to false. When calling CDS1.applyupdates (0); I get the follwing error "Syntax error in INSERT INTO". I have looked into the QRY it generates and it appears to be sending something like "insert into tblA (ID,Date) values (?,?)". If I then set the ResolveToDataset on the provider to true then it'll quite happily insert into the master but when it goes to insert a detail record throws a "cannot preform this operation on a closed dataset" error. I'm really confused. Anyone got any ideas. John. |