At 12:49 PM 16/09/2003 +0530, you wrote:

>Thanks Helen,
>
>But I find some problems creating the database
>When I execute in IB_WISQL

ib_wisql is REALLY OLD. It won't give you a Dialect 3 database unless you
begin your script with this statement:
SET SQL DIALECT 3;

When I execute in IB Expert
...and I don't know whether IB Expert will default to Dialect 3 either.

Alternatively, if you want to create the database interactively, use
isql. I guess I don't have to tell you that you need to use the correct
*versions* of isql and the IB client library...do I?

heLen