Question.

Had tables set up in DBISAM4.

I created a EDB database and used the import tables and all seems ok so far.

I used the reverse engineering in the manager to make both a proc and SQL.
I saved each as seperate text files.

I tried to do a query.sql.loadfromfile(sqlfile) to load the SQL file in and
do a prepare, then exec.

I get an EDB Error 700 at line 34, column 1 "Expected end of expression but
instead found CREATE)

Line 34 is the start of the next SQL statement.

I'm sure I'm missing something obvious, but I figured the reverse would be
able to go right in.

Lance




Here's the SQL except:

=====================
/************************************************************
*
* ElevateDB Reverse-Engineered SQL for the CDEMBD database
*
* Generated on 4/17/2007 10:38:08 AM
* By the user Administrator
*
************************************************************/


/************************************************************
* Tables
************************************************************/

CREATE TABLE "companyattributetypes"
(
"CompanyAttributeID" GUID DEFAULT CURRENT_GUID  NOT NULL,
"Description" VARCHAR(40) COLLATE "ANSI",
"CanModify" BOOLEAN,
"CanDelete" BOOLEAN,
"Created" TIMESTAMP,
"LastModified" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
"isActive" BOOLEAN DEFAULT TRUE,
CONSTRAINT "PrimaryKey" PRIMARY KEY ("CompanyAttributeID")
)
VERSION 7
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768

CREATE TABLE "taddress"
(
"AddressID" GUID DEFAULT CURRENT_GUID  NOT NULL,
"Street1" VARCHAR(40) COLLATE "ANSI",
"Street2" VARCHAR(40) COLLATE "ANSI",
"City" VARCHAR(40) COLLATE "ANSI",
"State" VARCHAR(40) COLLATE "ANSI",
"Postal" VARCHAR(15) COLLATE "ANSI",
"Country" VARCHAR(40) COLLATE "ANSI",
"URL" VARCHAR(50) COLLATE "ANSI",
"Created" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
"LastModified" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
"isActive" BOOLEAN DEFAULT TRUE,
"CompanyID" GUID NOT NULL,
"PersonID" GUID NOT NULL,
"AddressTypeID" GUID,
CONSTRAINT "PrimaryKey" PRIMARY KEY ("AddressID", "CompanyID", "PersonID")
)
VERSION 7
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768

CREATE INDEX "IDX_TAddress" ON "taddress"
("City" COLLATE "ANSI_CI", "State" COLLATE "ANSI_CI", "Postal" COLLATE
"ANSI_CI", "Country" COLLATE "ANSI_CI")

Lance,

<< I get an EDB Error 700 at line 34, column 1 "Expected end of expression
but instead found CREATE) >>

EDB does not support dynamic SQL scripts currently.   You need to either use
the stored procedure version, or issue each SQL statement individually.  The
non-stored procedure version of the reverse-engineering is mainly a
documentation format for now.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I just tried the stored procedure version and it works great.

Thanks!

Lance




"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:C477C6A7-5EA2-4C09-B21C-A3494F709C2F@news.elevatesoft.com...
> Lance,
>
> << I get an EDB Error 700 at line 34, column 1 "Expected end of expression
> but instead found CREATE) >>
>
> EDB does not support dynamic SQL scripts currently.   You need to either
> use the stored procedure version, or issue each SQL statement
> individually.  The non-stored procedure version of the reverse-engineering
> is mainly a documentation format for now.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Lance,

<< I just tried the stored procedure version and it works great. >>

The dynamic SQL scripts will be similar.

--
Tim Young
Elevate Software
www.elevatesoft.com