RE: OVRDBF and SQL

[rob@xxxxxxxxx]

Bummer about that variable restriction.

SqlStmt='Create Alias MKPHSW For ' + P#File;

exec sql prepare stmt1 from :SqlStmt;
exec sql execute stmt1;

or maybe
exec sql execute immediate :SqlStmt;

I wonder if you can use parameter markers?
SqlStmt='Create Alias MKPHSW For ?';
exec sql prepare stmt1 from :SqlStmt;
exec sql execute stmt1 using :P#File;

Then again, if you wanted to chuck the alias, you could probably do the 
whole sql statement this way.

Rob Berendt