ibec_CreateDatabase

ibec_CreateDatabase replaces the CREATE DATABASE command within IBEBlocks. CREATE DATABASE is still available for compatibility.

Description

No additional description…

Syntax

 function ibec_CreateDatabase(DatabaseType : integer; DatabaseProps : string) : variant; 

ibec_Database attempts to create a new database using the specified properties and, if successful, returns a handle of the connection to the database just created. Otherwise it returns NULL and raises an exception.

Example

 execute ibeblock
 as
 begin 
   try
     MyDB = ibec_CreateDatabase(__ctFirebird, 'DBName="localhost:d:\my databases\mydb.fdb";
                                ClientLib="C:\Program Files\Firebird\bin\fbclient.dll"; 
                                User=SYSDBA; Password=masterkey; PageSize=16384;
                                DefaultCharset=WIN1252; SQLDialect=3');
   except
     exit;
   end;
 
   ibec_UseConnection(MyDB);
  ...
 end;

Parameters

DatabaseType Type of the database to be created. Currently only _ctFirebird/__ctDatabase is supported.
DatabaseProps List of the new database properties, delimited with semicolon. Following properties are available:
DBName=<path_to_a_database> A new database file specification; file naming conventions are platform-specific.
ClientLib=<path to client library> Client library file name; default: gds32.dll.
User=<user_name> User name.
Password=<password> Password.
PageSize=<page_size_value> Size, in bytes, for database pages.
page_size=<page_size_value> The same as PageSize.
DefaultCharset=<charset_name> The default character set for the new database.
lc_ctype=<charset_name> Same as DefaultCharset.
SQLDialect=<dialect_number> The SQL dialect for the new database, either 1, 2, or 3.
sql_dialect=<dialect_number> The same as SQLDialect.