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

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;

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