TableUpdate Problem and How to ROLLBACK

[Creeder]

Hi all,

I have a database which consist of a remote view. And i've done a CURSORSETPROP using
BUFFERING, 5
SENDUPDATE, .T.
WHERETYPE, 4
UPDATEFIELDLIST <list of the fields on local table>
UPDATENAMELIST <list of fields local table with remove view>

And basically everything is fine.

Now let's say if I have five records in the local table and the 3rd record has some problem with the value and when i do sometheing like

llSuccess = TABLEUPDATE(1,.F.,<aliasName>)

It will insert the first 2 records into the remote table, and will just stop at the 3rd record.

What would the best way to handle this? I really need some advice as i am new to updating remote views.

Thanks.

Yue Jeen



[sig][/sig]

 

[jpugh]

Yue,

I have tried doing updates the same way you are, had the same problems and could find no way around it.

I have found it much easier to update tables on a record by record basis (BUFFERING=3), especially on a remote view where, as you suggest, there can be data problems.

This way I can use an error checking routine to report any errors returned by the ODBC or other interface, but at the same time continue processing the subsequent &quot;good&quot; records.

Regards,
Jon Pugh [sig][/sig]