Hello,
I want create table, using HXTT DBF 3.0.
Execute SQL-query:
CREATE TABLE info (A NUMERIC(2,0), B NUMERIC(2), C NUMERIC(4,2)))
In result DBF-file have following fields:
A width 4 decimal 0
B width 2 decimal 0
C width 4 decimal 2
Help me, please... I using licence HXTT DBF 3.0.
|
For small scale in DBF, it will used extra 2 length to avoid no space for radix point and sign.
|
so, but i need field with width = 2
Which SQL-script i should write?
|
Also on, in previous version of driver file was created succesfully
|
Because some users need to convert it to other database, so we do those modification. You can download the latest package, then try:
CREATE TABLE info (A NUMERIC(2,0), B NUMERIC(2), C NUMERIC(4,2))
|
Thank's, but i have one question yet:
running script
CREATE TABLE info (A NUMERIC(2,0), B NUMERIC(2), C NUMERIC(19,2))
in result
A width 2 decimal 0
B width 2 decimal 0
C width 20 decimal 2 (!!!!) Why??
correct this, please
|
>correct this, please
It's still using special process for Xbase. If you need wide 19, you should use
CREATE TABLE info (A NUMERIC(2,0), B NUMERIC(2), C NUMERIC(18,2))
No more correct for data convert compatibility.
|