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!

Register Log in
  • 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!

Search results for query: *

  1. 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...
  2. normanlaw

    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...

Part and Inventory Search

Back
Top