I use a database MS SQL.
I try to insert records between two others and get the result in a dbgrid.
First I select a row in the dbgrid.
By pressing a button, the program execute : tadodataset(wwDBGrid1.DataSource.DataSet).Insert;
My form contains tdbedit controls bound to the dataset via a datasource. I enter values in each dbedit controls.
then by pressing another button, it execute : tadodataset(wwDBGrid1.DataSource.DataSet).Post;
When I execute this code, the record is added at the end of the dataset as an append statement.
How can I do without have to add another database field ?