Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB-Aware

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2003, 08:59 AM
Martin_Dimitrov Martin_Dimitrov is offline
Senior Member
 
Join Date: Oct 2001
Posts: 150
Default How can I create a new DB file using SQL?

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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:55 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.