General information
Category:
Visual FoxPro Beta
>>>>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.
>>
>>It still has the problem with the Tableupdate() returning false with out the timestamp in the select.
>
>Can you try all this with ADO? Does DB2 even have a provider? Based on how this works using ADO, I am just not sure this will work with ODBC.
There are a few. I could look into them.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only