Hi all,

I've been developing workgroup applications (up to 50 users) with FoxPro (all versions) for about 8 years now, so I understand record and file locking very well. Now, however, I must move some of my applications to the web (imagine that). The principal method of access to this data is going to be ODBC, using SQL commands. I have developed a few apps in MS SQL Server, so I'm not too worried about SQL, but I have done zero work with VFP and ODBC/SQL.

Here is where I'm unclear. How do I lock a record using ODBC/SQL? Should I even try? Also, has anyone tried using VFP with something like ColdFusion?

Just trying to grasp the big picture here.

Thanks a bunch in advance.

Robert