>Using the "SELECT IDENTITY_VAL_LOCAL() as KeyID, Last_Update FROM BASI.Presidents" I was able to get the KeyID field to return the new ID#. The Last_update returns the time from the first record in the table. Also the Tableupdate still returns false. The error is "The refresh key defined for table is not unique." No Table mentioned now. On additional Tableupdate()s it continues to insert into the database, update the same record in cursor over and over again.
>
>Maybe I have to wait for the final release to get this working.
Remove the Last_Update from the SELECT and see what you get. The call to RecordRefresh() should take care of refreshing the data stamp field.
Mark McCasland
Midlothian, TX USA