See
Re: ODBCs SQLRowCount() - How to use? Thread #
810276 Message #
811151If you were to have a Last_Update column in your tables, you can use that in your UPDATE SQL where if no rows are updated [using method from Thread above], you know someone else has submitted a change ahead of you.
UPDATE ... SET ... WHERE PKField = ?crsMyCursor.PKField and LastUpdate = ?crsMyCursor.LastUpdate
>Hello,
>
>I'm a new member in this forum. The title of this and my last answer is wrong. It is the titel of the second last answer.
>
>My Problem is the VARCHAR in Oracle and fixed length in CHAR-Type in VFP. I must trim the CHAR-Value before I tableupdate to Oracle. I would like use SQLEXEC(lnConn,"Update...."). But how do I check if an other user has changed the the updatedable field?
>I use the Mere Mortals Framework 7. I don't know if the framework works with CursorAdapter.
Mark McCasland
Midlothian, TX USA