Re: Embedded SQL

In article <463nnk$mto@natasha.rmii.com>, dray@icsware.com wrote: > Is there a way to use variables in embedded sql commands in C/UNIX > environment? This is what I want to do > select :var_column_name from :var_table_name; > I know how to host variables but wanted to know if host variables > canbe used for the table and column names. > Thanks in advance Nope. You need to sprintf your query into a host variable, then use PREPARE to prepare the sprintf'd query. *THAT* works wonderfully. -- Jonathan Crawford Ark Technologies, Inc.