TOracleDataset.Filter using % and _

[Jens Fudickar]

Hi Marco,

is it possible to use the dataset filter with the default oracle wildcards. My customer think that it's more logic to use the default filters.

Greetings
Jens

 

[Marco Kalter]

The Filter property does not support SQL Wildcard characters. This is only supported in QBE, which is of course considerably more powerful and scalable.

 

[Jens Fudickar]

Hi Marco,

i know this. But is there any way to change this. Maybe in a before filter event? If not is it possible to add such a feature.

Greetings
Jens

 

[Marco Kalter]

I have added this to the list of enhancement requests. There is no BeforeFilter event, but if your application sets the Filter property at run-time, you can of course do some pre-processing.

 

[Jens Fudickar]

You are right, but if you use some third party applications then you have the same problem. No beforefilter event

Greetings
Jens