Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by normanlaw
-
Sqlcommit locking table
Rob, I have no experience in transaction as MySQL (what I am using) does not support. But as a generic concept of SQL, the SQL server will LOCK a table automatically when a query is executing. This is needed to prevent the intervention between clients. A transaction virtually packs all the...- normanlaw
- Post #2
- Forum: Microsoft: FoxPro
-
sql passthrough
Hi, I am using MySQL which does not support transaction and VFP3 which does not allow more than one query in a SQLEXEC. Therefore I have to use a simple but effective trick to achieve your requriement. First of all insert everything into a temp table in the server. Once the job is done and...- normanlaw
- Post #4
- Forum: Microsoft: FoxPro
