Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA - AutoRefresh
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
00955384
Message ID:
00955910
Views:
36
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform