Arg81
Well-known member
Hi all,
In an attempt to help stop concurrency conflicts, in my dataSet I have set the keyfield (RequestNumber) to have AutoIncrement Seed and Step to both be -1.
As my backend (SQL 2000) has this field set to AutoIncrement as well, then the true RequestNumber is set when the data is send to the database.
However, within my program, when I call UpdateDataSet, the data is sent back, the true RequestNumber appears in the database, but the label displaying the value on the form still keeps -1.
As this is my key, I can't call LoadDataSet on @RequestNumber, so I'm asking if there is any other way I can refresh that record so that the correct RequestNumber appears in the label?
cheers,
Luke
In an attempt to help stop concurrency conflicts, in my dataSet I have set the keyfield (RequestNumber) to have AutoIncrement Seed and Step to both be -1.
As my backend (SQL 2000) has this field set to AutoIncrement as well, then the true RequestNumber is set when the data is send to the database.
However, within my program, when I call UpdateDataSet, the data is sent back, the true RequestNumber appears in the database, but the label displaying the value on the form still keeps -1.
As this is my key, I can't call LoadDataSet on @RequestNumber, so I'm asking if there is any other way I can refresh that record so that the correct RequestNumber appears in the label?
cheers,
Luke