![]() |
|
|
|
#1
|
|||
|
|||
|
Hi, I want to create a new DB file using SQL, Interbase, and IBObject:
So I'm using TIB_Query from IBObjects with the following SQL code, but it gives me an error in line 2 char '-1' "CREATE". Can someone help me?! CREATE DATABASE 'C:\NEW_DB_FILE.GDB' USER 'SYSDBA' PASSWORD 'masterkey'; <cr>CREATE</cr> GENERATOR COLORS_GENERATOR; CREATE GENERATOR FILE_GENERATOR; CREATE TABLE USERS (ID INTEGER NOT NULL PRIMARY KEY, USER_NAME VARCHAR(30), USER_PASSWORD VARCHAR (30)); CREATE TABLE FILES (ID INTEGER NOT NULL PRIMARY KEY, FILEDESTINATION VARCHAR(500), FRAMES INTEGER, QUANTINIZATION INTEGER, DIFTHERING INTEGER); CREATE TABLE COLORS (ID INTEGER NOT NULL, COLORNAME VARCHAR(12), PERCENT FLOAT, FILEINDEX INTEGER, IMAGEINDEX INTEGER); Mark |
![]() |
| Thread Tools | |
| Display Modes | |
|
|