Is it acceptable to use parameters in a CREATE TABLE statement? I would like to do
something like the following:

create table if not exists ram1||ram2||ram3||'\'||ram4||'<FILENAMESUFFIX>'?
I'm getting the following error when I try this:
---------------------------
Error
---------------------------
An error has occurred in the current SQL statement and the error message is:

DBISAM Engine Error # 11949 SQL parsing error - Expected table name but instead found ? in
CREATE TABLE SQL statement at line 6, column 28
---------------------------
OK   
---------------------------

I have to create several tables over and over and over and... well, you get the idea. For
me it's easier to do this in a SQL script, substituting the params with path info etc in
the OnGetParams event.

I realize that I could do this in Delphi code but would prefer to do this in SQL.

Thanks.

David,

<< Is it acceptable to use parameters in a CREATE TABLE statement? I would
like to do something like the following: >>

You can only use parameters in DML statements: SELECT, INSERT, UPDATE, and
DELETE.  They are equivalent to constants, as opposed to identifiers or
simple text.

--
Tim Young
Elevate Software
www.elevatesoft.com