>Hello All,
>
> I want to Lock some record. In Oracle we can use Select For Update SQL, and the job becomes very simple. How can i use select clause for FOX Database using SQL. Otherwise i have to make a loop and lock individual record which increases the code.
>
>TIA
>Amit
You are not going to get this with the minimal code as you requested unless you work directly with the table and not a view of the table[s]. You would have to use pessimistic buffering as well which locks records before/when editing begins.
If you are going to use views or remote data which require views, you will be limited to optimistic buffering. Then you would have to use TRANSACTIONS if one of your requirements is that all records have to be able to return TRUE from
Tableupdate so you can ROLLBACK all changed records during the transaction.
Mark McCasland
Midlothian, TX USA