Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Error message with ElevateDB Manager |
Fri, Jun 18 2010 4:22 AM | Permanent Link |
Josselin | Hi
I use Elevate DB Manager (unicode) version 2.03 Build 14 and the components in Delphi are in the same version. Can someone tell me why I have this error message : ElevateDB Error #100 There is an error in the metadata for the table Multi (The internal version does not match the version in the configuration or catalog) Thanks for your help Bruno Riviere |
Fri, Jun 18 2010 4:41 AM | Permanent Link |
Josselin | It's very strange because I have this error message since I use this SQL
PROC_SQL.SQL.Clear; PROC_SQL.SQL.Add('ALTER TABLE Multi'); PROC_SQL.SQL.Add('DROP CONSTRAINT PrimaryKey'); PROC_SQL.ExecSQL; PROC_SQL.SQL.Clear; PROC_SQL.SQL.Add('ALTER TABLE Multi'); PROC_SQL.SQL.Add('ADD CONSTRAINT "PrimaryKey" PRIMARY KEY (NumOrdr)'); PROC_SQL.ExecSQL; |
Fri, Jun 18 2010 2:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bruno,
<< It's very strange because I have this error message since I use this SQL >> Are you sure you're running 2.03 Build 14 in your code ? I tried the following: SCRIPT () BEGIN EXECUTE IMMEDIATE 'ALTER TABLE customer DROP CONSTRAINT PrimaryKey'; EXECUTE IMMEDIATE 'ALTER TABLE customer ADD CONSTRAINT PrimaryKey PRIMARY KEY (CustNo)'; END and it works fine. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |