>>>How to do it? What I want to do is select a record, try to get a rlock on it, if successful insert that value into another table, then modify the record's "available" field so it won't be used again... I just need to figure out (with your help <grin>) how to send a rlock to vfpodbc.
>>>
>>>I have a table of "available index numbers" with 3 fields - indexnum (c), available (l), datetimeused(d). I also have a table for guestbook entries - indexnum (c), name (c), address (c), etc.
>>>
>>>I just want to "remove" a record from the available index number table and use it (only once) in the guestbook table.
>>>
>>
>>I haven't tried this, but I'd guess you'd need to write a stored procedure and trigger it as a row or field validation rule. I'm not sure what locking and buffering options are avaialble under the VFPODBC driver; you'll need to consult the docs that accompany the VFPODBC driver (VFPODBC.TXT and DRVVFP.HLP; the latter contains the list of supported and unsupported VFP commands under the ODBC driver.) FLOCK(), RLOCK(), the TRANSACTION syntax, TABLEUPDATE() and TABLEREVERT() are supposedly supported.
>
>
>Stored procedures aren't supported by VFPODBC, going by the drvvfp.hlp file, but rlock() is.... I wonder if I could do some kind of sql update with an rlock or something....

You can't call a stored procedure through ODBC, but you can run one through a trigger, default value, or validation rule.