Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Error altering table |
Fri, Feb 16 2007 8:51 AM | Permanent Link |
Michael Baytalsky | 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 |
Fri, Feb 16 2007 2:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |