Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to update sql with timestamp?
Message
From
12/05/2003 13:21:34
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00787368
Message ID:
00787418
Views:
37
>Hi,
>
>Here is what I did,
>
>1. Using sqlexec to get a table with a timestamp column on sql2000 in a com server
>2. convert the cursor to xml and pass it to my client
>3. convert the xml back to cursor
>4. did my update and pass it back to com in xml format using xmladapter.ChangesToCursor
>5. Convert the xml back to cursor in com
>6. Attach the cursor using cursoradapter and set primary key, updateable, updatefield...
>7. Set my wheretype = 4 && TimeStamp
>
>The update didn't work properly. I open the sql profiler, it did only update my table using primary key field only.

Hi Tony,

The cursor created by SQLEXEC has information about timestamp column.
Are you using the same cursor for TABLEUPDATE? If you are using a brand new cursor created by XMLAdapter then it obviously doesn't know anything about timestamp and there is nothing wrong with CursorAdapter.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform