Mark
You don't need to issue an update statement with remote views. Just moving the record pointer will send the update if buffering is 3. If buffering is 5 then you need to issue a tableupdate(). You can also issue a tableupdate() with 3. Make sure the PK is checked in the view designer.
>Hello guys, I have a question
>
>I have created a remote view of a table that resides on a MySQL database
>once I finish the process I issue the following last line
>-- code ....--
>
>UPDATE upsdbc!mysql_fileinfo set processed=1 WHERE ALLTRIM(UPPER(upfilename)) = ALLTRIM(UPPER(inthefile))
>
>
>-- code...--
>
>where inthefile is the name of the file I have processed, I am just
>changing the status of the processed flag from 0 to 1, If I used the
>command line I am able to update the table on the MySQL table, if I use
>the debugger I am able to update the table on the MySQL too, but when
>I use the stand alone application the update does not change, I have tried
>setting up row buffering on the row ( do not know if this works on the
>remote view), by issuing the following line:
>
>lTest=CURSORSETPROP("Buffering", 5, "mysql_fileinfo")
>
>by no update happens, any insights would be appreciated.
>
>thanks
>
>mark oliva
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement