>Hi to all,
>how can I lock a record on a VFP table using the ODBC ?
>
>On a Oracle table I can do a SELECT .... WHERE .... FOR UPDATE
>but this syntax doesn't exist on standard SQL.
>I've tried to pass a string with RLOCK('12', myTable) to ODBC but it generates an error
>
>Any idea ??
>TIA

You can not get record locking with ODBC like you can with a local VFP table. The best you can do is add a field to the table and set it to a value indicating its locked status, then check the value before editing it. The problem with this is if the user abnormally exists, the flag does not get reset if the user locked it.