Subject | SQL2GDB errors? |
---|---|
Author | Joaquim Macedo <joaquimmacedo@yahoo.com> |
Post date | 2003-01-26T18:36:07Z |
Hi all.
I'm using SQL2GDB to convert an Access database to a Firebird one.
I've got this error problems:
------
Executing query PUMP: (ENT_GER_relac) with text
INSERT INTO ENT_GER_relac (
codig,
desig
) VALUES (
:codig,
:desig
)
With Recordset:
Values: codig [ASSOC]; desig [Associado];
Produced error
Invalid variant type conversion (EVariantError)
------
Executing query PUMP: (ENT_GER_relac) with text
INSERT INTO ENT_GER_relac (
codig,
desig
) VALUES (
:codig,
:desig
)
With Recordset:
Values: codig [COBR]; desig [Cobrador de Associados];
Produced error
Invalid variant type conversion (EVariantError)
------
Executing query INDEX (ASS_artig): PrimaryKey with text
ALTER TABLE ASS_artig
ADD PRIMARY KEY (
ENT_GER_relac_codig,
ENT_entid_relac_codig_espec,
ASS_GER_artig_codig
)
Produced error unsuccessful metadata update
Column: ASS_GER_ARTIG_CODIG not defined as NOT NULL - cannot be used
in PRIMARY KEY/UNIQUE constraint definition
------
As I am a newbie on Firebird, I would appreciated some help on how to
resolve this problems.
Thanks a lot in advance.
Best regards,
Joaquim.
I'm using SQL2GDB to convert an Access database to a Firebird one.
I've got this error problems:
------
Executing query PUMP: (ENT_GER_relac) with text
INSERT INTO ENT_GER_relac (
codig,
desig
) VALUES (
:codig,
:desig
)
With Recordset:
Values: codig [ASSOC]; desig [Associado];
Produced error
Invalid variant type conversion (EVariantError)
------
Executing query PUMP: (ENT_GER_relac) with text
INSERT INTO ENT_GER_relac (
codig,
desig
) VALUES (
:codig,
:desig
)
With Recordset:
Values: codig [COBR]; desig [Cobrador de Associados];
Produced error
Invalid variant type conversion (EVariantError)
------
Executing query INDEX (ASS_artig): PrimaryKey with text
ALTER TABLE ASS_artig
ADD PRIMARY KEY (
ENT_GER_relac_codig,
ENT_entid_relac_codig_espec,
ASS_GER_artig_codig
)
Produced error unsuccessful metadata update
Column: ASS_GER_ARTIG_CODIG not defined as NOT NULL - cannot be used
in PRIMARY KEY/UNIQUE constraint definition
------
As I am a newbie on Firebird, I would appreciated some help on how to
resolve this problems.
Thanks a lot in advance.
Best regards,
Joaquim.