thanks

mark oliva

>>tableupdate() will save the records to the database. Issueing skip or anything else will be up to you. Personally I don't rely on anthing but tableupdate() make sure my data is saved. You can look at getfldstate() and getnextmodified() to see if your data is saved.
>>
>>
>>
>>>Thanks James,
>>>
>>>right now there is only one record on the table, so should I issue the "update table..." and then skip and yes my PK is checked on the
>>>view designer
>>>
>>>mark oliva
>>>
>>>>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