When I use the TOraDataSet with the method SetVariable and DeclareVariable, I have the followinfg message:
ORA-1036: illegal variable/name number
My requete is:
select * from waccueil where idaccueil = :id
My variable property contain id.
I use DeclareVariable and SetVariable in my c++ program for parse in runtime the value for id.
Can you help me
Thank for your reply.

If your variable property is already properly assigned, you do not need to (re) declare the same variable in your code. Maybe this is where the problem originates from.

Hope this will help.

Jean-Paul

ORA-01036 indicates that you have declared a variable (at design time or through DeclareVariable) that is not used in the SQL Text. Besides ID you must have declared another variable. Use DeleteVariables to delete all variables before declaring new ones.

------------------
Marco Kalter
Allround Automations