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
Regards,
Robert Carr
4 Database Consulting