Hi,
I have a Delphi7 app which uses dbexpress and an MS SQL2000 database. I want to handle a table's data, so I have an SQLQuery-provider-Clientdataset. I do a 'Select * from table1', and ok there is the data in the clientdataset. But if I want to insert to the table the id field (which is the primary key and auto increment in the database) is required. If I don't select the id field it's ok, but I need the id field value plenty of times.
So what is the solution? How to insert a clientdataset having auto increment fields? I always need the value of the id...so it must be selected...
I have a Delphi7 app which uses dbexpress and an MS SQL2000 database. I want to handle a table's data, so I have an SQLQuery-provider-Clientdataset. I do a 'Select * from table1', and ok there is the data in the clientdataset. But if I want to insert to the table the id field (which is the primary key and auto increment in the database) is required. If I don't select the id field it's ok, but I need the id field value plenty of times.
So what is the solution? How to insert a clientdataset having auto increment fields? I always need the value of the id...so it must be selected...