Hello:
> That´s right, CreateDatabse was the function I meant. The default PageSize
> for
> Interbase 6.0 is 2048. Due to performance issues it is recommended that you
> increase
> the pagesize to 4096. Normally I used in C++ with the IB6 API these commands
> to create a database:
>
> isc_db_handle db = 0L; // DB Handle
> isc_tr_handle tr = 0L; // Transaction Handle
> ISC_STATUS status[20];
>
> t_string sql = (t_string)"CREATE DATABASE " + "'" + dbname + "' PAGE_SIZE
> 4096 USER '" + ownerid + "' PASSWORD '" + ownerpwd + "' DEFAULT CHARACTER SET
> ISO8859_1";
> isc_dsql_execute_immediate(status, &db, &tr, 0, sql.Value(), 3, NULL);
>
> Afterwards I connect to this database and create all the external functions
> which are defined in the ib_udf.dll. If not, you don´t have alle the
> functions liek upper, lower, abs, substr, strlen etc.
Done, now you can spcefy the page size and the character set ( i need to
verify if this works i will try to see it later today ).
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.
|
