Many SQL statement get error on Execute
Posted: Sun 22 Apr 2012 15:05
Below my code:
I get a error message, below this image:
Code: Select all
{ Memo1 Text }
CREATE TABLE animals(
NAME VARCHAR(10) DEFAULT '' ,
SIZE INTEGER DEFAULT 0 ,
WEIGHT INTEGER DEFAULT 0 ,
AREA VARCHAR(20) DEFAULT '' ,
BMP BYTEA
);
CREATE TABLE biolife(
"Species No" REAL DEFAULT 0.0 ,
Category VARCHAR(15) DEFAULT '' ,
Common_Name VARCHAR(30) DEFAULT '' ,
"Species Name" VARCHAR(40) DEFAULT '' ,
"Length (cm)" REAL DEFAULT 0.0 ,
Length_In REAL DEFAULT 0.0 ,
Notes TEXT ,
Graphic BYTEA ,
PRIMARY KEY("Species No")
);
.
.
. // Many SQL statement
{ Run Code }
SQLConnection1.Execute(Memo1.Lines.Text, nil);