Problem: I can't figure out how to create a database on the fly with the API. Solution: For more details see the documentation in the "API Guide", page 66. Steps for Creating a Database via API ------------------------------------------------------ 1) Detach from any currently attached databases via isc_detach_database() * this sets its database handle to NULL. 2) Build the create statement to process. 3) Execute the statement via: isc_dsql_execute_immediate() or isc_dsql_execute_immed2() Code: Example ------------------------------ char *str = "CREATE DATABASE "new_emp.gdb""; . . . isc_detach_database(status_vector, &db1); isc_dsql_execute_immediate(status_vector, &db1, &trans, 0, str, 1, NULL);
Last Modified: 27-OCT-00