Problem with TOracleDataSet et substitution

[jpchausseau]

I have the following select statement attached to a TOracleDataSet:

select INVENTORY.stock from INVENTORY where INVENTORY.no_product in :varProducts.

At design time, if varProducts is declared as a substitution variable and I try to get the query active, I get error messages according to which the syntax of the query is wrong (either field names, or inappropriate termination of the sql declaration). At run time, however, it works OK.

Since I need to get the query active at design time (to design a report), I solved the problem by declaring varProducts as a string, which allows the query to become active. At run time I delete this variable and recreate it with the proper type (otSubst).

Although it works, it is a bit awkward and I wonder if I missed something here.

(Delphi 5, Oracle 8.0.5)

Jean-Paul

 

[jpchausseau]

Problem solved!

I just had to give the default value ('') to the variable to get the dataSet 'activable' at design time. Leaving a blank as its default value was the source of the problem.

Jean-Paul