I installed Firebird 1.0 on a Win nt 4.0 sp6 workstation.
I then used IB_WISQL.exe to create the database called Instsql.gdb.
(Aside comment; I also have a eval copy of IBAdmin3 installed on my
machine.) I then created (see SQL statement below)a table called
INVENTOR using paradox 10.0 and the builtin INTRBASE version 4.0
driver. I saw one problem after I created the table; the fields that
I declared as DATE are created as TIMESTAMP.

The next issue is even stranger; when I attempted to fill the table
from a paradox table it seems that all the fields except for the DATE
fields are loaded (see INSERT query #1). If I only load the primary
key plus the date fields the load is successful (see INSERT query #2).

Does anyone have any suggestions.

best regards,

Jay Quesenberry

CREATE TABLE INVENTOR
( UNIQ_KEY CHAR(10) NOT NULL PRIMARY KEY,
PART_CLASS CHAR(8),
PART_TYPE CHAR(8),
CUSTNO CHAR(10),
PART_NO CHAR(20),
REVISION CHAR(4),
PROD_ID CHAR(10),
CUSTPARTNO CHAR(20),
CUSTREV CHAR(4),
DESCRIPT CHAR(30),
U_OF_MEAS CHAR(4),
PUR_UOFM CHAR(4),
ORD_POLICY CHAR(12),
PACKAGE CHAR(15),
NO_PKG DOUBLE PRECISION,
inv_note BLOB (80, 1),
buyer_type CHAR(3),
stdcost DOUBLE PRECISION,
minord DOUBLE PRECISION,
ordmult DOUBLE PRECISION,
usercost DOUBLE PRECISION,
pull_in DOUBLE PRECISION,
push_out DOUBLE PRECISION,
ptlength DOUBLE PRECISION,
ptwidth DOUBLE PRECISION,
ptdepth DOUBLE PRECISION,
fginote BLOB (80, 1),
status CHAR(8),
perpanel DOUBLE PRECISION,
abc CHAR(1),
layer CHAR(4),
ptwt DOUBLE PRECISION,
grosswt DOUBLE PRECISION,
reorderqty DOUBLE PRECISION,
reordpoint DOUBLE PRECISION,
part_spec CHAR(100),
pur_ltime DOUBLE PRECISION,
pur_lunit CHAR(2),
kit_ltime DOUBLE PRECISION,
kit_lunit CHAR(2),
prod_ltime DOUBLE PRECISION,
prod_lunit CHAR(2),
udffield1 CHAR(10),
wt_avg DOUBLE PRECISION,
part_sourc CHAR(10),
insp_req CHAR(1),
cert_req CHAR(1),
cert_type CHAR(10),
scrap DOUBLE PRECISION,
setupscrap DOUBLE PRECISION,
outsnote BLOB (80, 1),
bom_status CHAR(10),
bom_note BLOB (80, 1),
bom_lastdt DATE,
serialyes CHAR(1),
loc_type CHAR(10),
aday DOUBLE PRECISION,
dayofmo DOUBLE PRECISION,
dayofmo2 DOUBLE PRECISION,
saletypeid CHAR(10),
feedback BLOB (80, 1),
gldivno CHAR(2),
eng_note BLOB (80, 1),
bomcustno CHAR(10),
laborcost DOUBLE PRECISION,
int_uniq CHAR(10),
eau DOUBLE PRECISION,
require_sn CHAR(1),
ohcost DOUBLE PRECISION,
phant_make CHAR(1),
cnfgcustno CHAR(10),
confgdate DATE,
confgnote BLOB (80, 1),
xferdate DATE,
xferby CHAR(3),
prodtpuniq CHAR(10),
mrp_code DOUBLE PRECISION,
make_buy CHAR(1),
labor_oh DOUBLE PRECISION,
matl_oh DOUBLE PRECISION,
matl_cost DOUBLE PRECISION,
overhead DOUBLE PRECISION,
other_cost DOUBLE PRECISION,
stdbldqty DOUBLE PRECISION,
usesetscrp CHAR(1),
configcost DOUBLE PRECISION,
othercost2 DOUBLE PRECISION,
matdt DATE,
labdt DATE,
ohdt DATE,
othdt DATE,
oth2dt DATE,
stddt DATE,
arcstat CHAR(8) )

(INSERT Query #1)

INSERT INTO :fb2:INVENTOR (ABC, ADAY, ARCSTAT, BOMCUSTNO, BOM_NOTE,
BOM_STATUS, BUYER_TYPE,
CERT_REQ, CERT_TYPE, CNFGCUSTNO, CONFGNOTE, CONFIGCOST, CUSTNO,
CUSTPARTNO, CUSTREV,
DAYOFMO, DAYOFMO2, DESCRIPT, EAU, ENG_NOTE, FEEDBACK, FGINOTE,
GLDIVNO, GROSSWT,
INSP_REQ, INT_UNIQ, INV_NOTE, KIT_LTIME, KIT_LUNIT, LABORCOST,
LABOR_OH, LAYER,
LOC_TYPE, MAKE_BUY, MATL_COST, MATL_OH, MINORD, MRP_CODE, NO_PKG,
OHCOST, ORDMULT,
ORD_POLICY, OTHERCOST2, OTHER_COST, OUTSNOTE, OVERHEAD, PACKAGE,
PART_CLASS, PART_NO,
PART_SOURC, PART_SPEC, PART_TYPE, PERPANEL, PHANT_MAKE, PRODTPUNIQ,
PROD_ID,
PROD_LTIME, PROD_LUNIT, PTDEPTH, PTLENGTH, PTWIDTH, PTWT, PULL_IN,
PUR_LTIME,
PUR_LUNIT, PUR_UOFM, PUSH_OUT, REORDERQTY, REORDPOINT, REQUIRE_SN,
REVISION,
SALETYPEID, SCRAP, SERIALYES, SETUPSCRAP, STATUS, STDBLDQTY, STDCOST,
UDFFIELD1,
UNIQ_KEY, USERCOST, USESETSCRP, U_OF_MEAS, WT_AVG, XFERBY)

SELECT ABC, ADAY, ARCSTAT, BOMCUSTNO, BOM_NOTE,
BOM_STATUS, BUYER_TYPE,
CERT_REQ, CERT_TYPE, CNFGCUSTNO, CONFGNOTE, CONFIGCOST, CUSTNO,
CUSTPARTNO, CUSTREV,
DAYOFMO, DAYOFMO2, DESCRIPT, EAU, ENG_NOTE, FEEDBACK, FGINOTE,
GLDIVNO, GROSSWT,
INSP_REQ, INT_UNIQ, INV_NOTE, KIT_LTIME, KIT_LUNIT, LABORCOST,
LABOR_OH, LAYER,
LOC_TYPE, MAKE_BUY, MATL_COST, MATL_OH, MINORD, MRP_CODE, NO_PKG,
OHCOST, ORDMULT,
ORD_POLICY, OTHERCOST2, OTHER_COST, OUTSNOTE, OVERHEAD, PACKAGE,
PART_CLASS, PART_NO,
PART_SOURC, PART_SPEC, PART_TYPE, PERPANEL, PHANT_MAKE, PRODTPUNIQ,
PROD_ID,
PROD_LTIME, PROD_LUNIT, PTDEPTH, PTLENGTH, PTWIDTH, PTWT, PULL_IN,
PUR_LTIME,
PUR_LUNIT, PUR_UOFM, PUSH_OUT, REORDERQTY, REORDPOINT, REQUIRE_SN,
REVISION,
SALETYPEID, SCRAP, SERIALYES, SETUPSCRAP, STATUS, STDBLDQTY, STDCOST,
UDFFIELD1,
UNIQ_KEY, USERCOST, USESETSCRP, U_OF_MEAS, WT_AVG, XFERBY
FROM INVENTOR2.db

(INSERT Query #2)

INSERT INTO :fb2:INVENTOR (uniq_key, bom_lastdt,
matdt, labdt, ohdt, othdt, oth2dt, stddt)

SELECT uniq_key, bom_lastdt, matdt, labdt, ohdt, othdt, oth2dt, stddt
FROM INVENTOR2.db