Can you use domains instead of directly specifying datatype ?
(unfortunately it does not work for SP parameters/variables.)

e.g. if you run these two command in script
CREATE DOMAIN D_TIMESTAMP TIMESTAMP;
CREATE DOMAIN D_TIMESTAMP DATE;
then in IB5 the first command will fail and the second succeed,
while in the FB1.5/D-3 the first command will succend (and thus the secon fail)

Ivan

----- Original Message -----
From: "Nico Callewaert"
Sent: Wednesday, June 02, 2004 3:18 PM
Subject: [firebird-support] Re: Dialect 3 to dialect 1 ?


> That's correct, but the problem is, we maintain 1 updatescript for
> all customers. So, if we use TIMESTAMP in the script, it won't work
> for IB customers, and if we use DATE then the TIME part of the data
> is gone in FB. That's our main problem for now :-)