help in dynamic query in Pro*C

[hrishy]

Hello Hrishy

and one more thing...can i store the name of a table in a variable and make
a query like this in pro*c:-
char * variable=tablename;
exec sql select * from variable where name='xyz';
i.e. 'variable' contains the name of the table to select from....

Yes you should store it in a variable name and then use strcat as i have shown above to construct the query and execute dynamically.Look for my code above

regards
Hrishy