Am I missing something here? But this script when executed gives me an error. I have simplified it to the two line script shown below.

"ElevateDB Error #700 An error was found in the statement at line 5 and column 22 (Expected table name but instead found ?)"

SCRIPT
BEGIN

 Declare _Stmt Statement;
 Prepare _Stmt From 'Empty Table ? Ignore Constraints';

END

It would appear a Prepare statement can't accept a parameter that holds a table name. Is that true?
Then all SQL statements whose table name changes, will have to be built dynamically and be unprepared (using Execute Immediate ...). Is that correct?

Barry

Hi Barry,

> Then all SQL statements whose table name changes, will have to be built
> dynamically and be unprepared (using Execute Immediate ...). Is that
> correct?

That is correct.

---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com
---------------------------------------