Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create Table in interbase (runtime)
- Thread starter KrisUK
- Start date
- Thread starter
- #3
Try this (I am usin Delphi 6/7 and working)
Use IBSQL
Set IBSQL.SQL to some command for example
CREATE TABLE "ARTIKLI"
(
"SIFRA" VARCHAR(50) NOT NULL,
"NAZIV" VARCHAR(100) NOT NULL,
"NAZIV_DRUGI" VARCHAR(100),
"MJERA" VARCHAR(50) NOT NULL,
"C1" FLOAT,
"C2" FLOAT,
"C3" FLOAT,
PRIMARY KEY ("SIFRA"
);
and then call IBSQL1.ExecQuery ;
Use IBSQL
Set IBSQL.SQL to some command for example
CREATE TABLE "ARTIKLI"
(
"SIFRA" VARCHAR(50) NOT NULL,
"NAZIV" VARCHAR(100) NOT NULL,
"NAZIV_DRUGI" VARCHAR(100),
"MJERA" VARCHAR(50) NOT NULL,
"C1" FLOAT,
"C2" FLOAT,
"C3" FLOAT,
PRIMARY KEY ("SIFRA"
);
and then call IBSQL1.ExecQuery ;
MartijnTonies
Programmer
Hi,
You cannot do this from within a Stored Procedure - DDL (Data Definition Language) is not allwed in stored procedures.
Use SQL DDL statements (like CREATE TABLE) either one by one in a TIBQuery/TQuery/TIB_DSQL/Twhatever component or use script-components that can process the whole lot at once. Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
You cannot do this from within a Stored Procedure - DDL (Data Definition Language) is not allwed in stored procedures.
Use SQL DDL statements (like CREATE TABLE) either one by one in a TIBQuery/TQuery/TIB_DSQL/Twhatever component or use script-components that can process the whole lot at once. Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
- Status