Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TimeStamp
Message
From
09/09/1998 14:23:30
 
 
To
09/09/1998 14:00:40
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00134662
Message ID:
00134690
Views:
10
Why did I even include the TIMESTAMP column in my remote views. I don't need it!! When I removed it --- problem solved.

>Hi Dan ---
>
>Why not leave the timestamp column blank in the new record and let SQL Server deal with a value when the server table is updated? (you have to ensure that the column is *not* updateable)
>
>
>>I have a toolbar button that users can click to append a new record and copy all values from the current record to the new one. This works fine with local tables.
>>
>>However, with SQL Server tables (remote updateable views) with a TIMESTAMP column it does not work. The TIMESTAMP value is being copied and, since it is the same as the previous record, I get error messages when I try to save the new record.
>>
>>Is there a way I can assign the TIMESTAMP value manually?
Thanks,
Dan Jurden
djurden@outlook.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform