Wildcard characters in non-string fields in QBE ?

[dtumbov]

Hi all,

Is there any way that one could 'fake' limitation of the QBE that "Wildcard characters are only allowed in string fields" ?
Must I have TDBEdit (or any other data-aware component) in order to perform QBE ?

Dimce

 

[Marco Kalter]

The only way to 'fake' this is by setting TOracleDataSet.StringFieldsOnly to True. Now all fields are fetched as strings, and wilcard characters can be used. This may have other side-effects, as numbers and dates are now formatted on the Oracle Server, using the session's NLS settings.

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