In DBISAM Version 3, I could pass table or column names as parameter, for example
SELECT * FROM :TableName
Parameters: ('People')

But I get an error in DBISAM 4: DBISAM Engine Error # 11949 SQL parsing error - Expected
table name but instead found 'People'

Is there anyway to work around this problem?

Qing wrote:
> In DBISAM Version 3, I could pass table or column names as parameter,
> for example SELECT * FROM :TableName
> Parameters: ('People')
>
> But I get an error in DBISAM 4: DBISAM Engine Error # 11949 SQL
> parsing error - Expected table name but instead found 'People'
>
> Is there anyway to work around this problem?

Generate the statement in code, eg. in OnBeforeOpen. I do that all the time
via Format() and use parameters only if there is no nother way, eg. for BLOB
values.

Ralf

Qing,

<< In DBISAM Version 3, I could pass table or column names as parameter, for
example SELECT * FROM :TableName
Parameters: ('People') >>

You have never been able to use parameters for table names in DBISAM.  You
can only use parameters in the WHERE or JOIN clauses in places where you
would normally use a constant value.

--
Tim Young
Elevate Software
www.elevatesoft.com