Subject SQL2GDB errors?
Author Joaquim Macedo <joaquimmacedo@yahoo.com>
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.