#144 Create Table

[Anonymous]

Hi,

I'm within a Firebird 2.5 Database, in the content-grid of a table,
using the menue "Export + Create Table Command..." and trying to create
the content-grid as a table into another open Firebird 2.5 Database.

All Fields with Datatype DOUBLE are shown in the SQL-Tab as following:

"Fieldname" DOUBLE 17,

Executing the query leads in the error "... Token unknown ...", which means
that the "17" is not known.

Another problem with the same menue:

Source-Database is Oracle 10, Destination-Database Firebird 2.5
Within the content-grid of a oracle-table I select the menue above to create
the grid as a table into the Firebird 2.5 Database.

There are some problems with numeric fields, I think.
Get the error message: "... Precision must be from 1 to 18"

The fields are shown in the SQL-Tab as following:

"Fieldname" NUMERIC(22,0),

Maybe a problem with converting the field-types to SQL for the destination-database?

Don

[Andrzej Kałuża]

Hi Don,

I'm sure this is a problem with the conversion of types.
I use the types provided by the JDBC driver. Unfortunately, some drivers return types in the wrong way - like Jaybird for Firebird database

unfortunate again the "universality" :(
I'll try to do something about it

thanks Don,
Andrzej

[Anonymous]

Hi Andrzej,

thanks again..

Don