Problem: ORACLE <-> DataEnvironment

[Ralf]

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]

[James Grant]

Try using the following syntax:


SELECT ...

FROM ...

WHERE (XYZ = ?)


Look into the Parameter/Parameters properties to set it dynamically at run-time.


-Jim