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