It's impossible to set a "WHERE-Statement" with dynamic parameters in a DataEnvironment-Object. It doesn't matter if I set up the Connection with 'Microsoft OLE DB Provider for Oracle' or with 'Microsoft OLE DB Provider for ODBC Drivers'. I set the parameter with the SQL Builder like that:

SELECT ....

FROM ....

WHERE (XYZ = %PARAM%)

But when I try to RUN the statement a error occurs.


Is there a trick to add parameters to a simply query (not a stored procedure) ?


Please help me!!!!!!


Ralf

[email protected]