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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only