Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to update sql with timestamp?
Message
De
12/05/2003 13:21:34
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00787368
Message ID:
00787418
Vues:
40
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform