Tim,

The following sequence (batch) produces error in the second statement:

ALTER TABLE "Projects"
  ADD CONSTRAINT "CurrectProject_CurrentVersion" FOREIGN KEY ("CurrentVersion")
  REFERENCES "Versions"("VersionID")

ALTER TABLE "Versions"
  ADD CONSTRAINT "Versions_Project" FOREIGN KEY ("ProjectID")
  REFERENCES "Projects"("ProjectID")

Error: ElevateDB Error #300 Cannot lock table Projects for exclusive access

It seems like after altering table it wants me to disconnect from the database
before I can add foreign key. Each statement is executed separately by
(supposedly) atomic ExecSQL calls without explicit use of transactions.


Regards,
Michael

Michael,

<< The following sequence (batch) produces error in the second statement: >>

I will check this out and let you know what I find.  It looks like a table
lock isn't being released properly.

--
Tim Young
Elevate Software
www.elevatesoft.com