Hi everybody,
Recently I have moved from BDE and TBDEClientDataSet to dbExpress and TClientDataSet with a Provider (but in the same DataModule).
My application is server-client and needs to keep track of 'Events' and 'Activities' so I have two Log tables, which use a Key Field named 'Index' of type Autoincrement.
When I try to insert a record in any of these tables, the program raises an EDatabase Exception : Field 'Index' must have a value, in the 'Append' instruction.
If I remove the field 'Index' from the Fields Editor of the TClientDataSet (tbEventsLog), the exception is now EDBClient, with message 'Field value required'. If I keep the 'Index' field in the Fields Editor but changes the Read Only property to True, I also receive a 'Field value required' exception.
As I didn't have this problem in the previous version (with BDE and TBDEClientDataSet), I guess the problem has to do with dbExpress or TClientDataSet management of Autoincrement fields.
Can anybody give me an explanation and a solution to this problem?
Thanks!
Nurya
PS: Sorry for my English! ;-)
Recently I have moved from BDE and TBDEClientDataSet to dbExpress and TClientDataSet with a Provider (but in the same DataModule).
My application is server-client and needs to keep track of 'Events' and 'Activities' so I have two Log tables, which use a Key Field named 'Index' of type Autoincrement.
When I try to insert a record in any of these tables, the program raises an EDatabase Exception : Field 'Index' must have a value, in the 'Append' instruction.
If I remove the field 'Index' from the Fields Editor of the TClientDataSet (tbEventsLog), the exception is now EDBClient, with message 'Field value required'. If I keep the 'Index' field in the Fields Editor but changes the Read Only property to True, I also receive a 'Field value required' exception.
As I didn't have this problem in the previous version (with BDE and TBDEClientDataSet), I guess the problem has to do with dbExpress or TClientDataSet management of Autoincrement fields.
Can anybody give me an explanation and a solution to this problem?
Thanks!
Nurya
PS: Sorry for my English! ;-)