Devart Forums

Does ODAC have substitution params???


example


select
name,
address
:P_PHONE
from
users


result if :P_PHONE is null

name | address
---------|---------------------
John | Address 1
Susan | Address 2


result if :P_PHONE = 555

name | address | 555
---------|---------------------
John | Address 1 | 555
Susan | Address 2 | 555

or

select * from users
where name :P_NAME 'John'

then :P_NAME can be =, , like ...

Yes.

Have a look for the Macros Property.

Kind regards
Jens