Dear Sir,
We bought OraDirect few months ago, and very impressed by its performance. We are trying to re-program our old program in OraDirect.
I tried to set some parameters in OraTable like what below,
SELECT * FROM TABLE1 WHERE COMPANYNAME IS NOT NULL AND (CUSTOMERID = : ID OR :ID1 IS NULL)
If users type customerid in program, then :ID/:ID1 will have value, we will have data that companyname is not null and some specific customerid.
if users do not enter customerid, I would like to select data that only companyname is not null.
I tried to feed "NULL" or "DBnull.value" into :ID and :ID1, but it does not work.
May I ask what value should I feed into paramaters, if just need NULL in SQL statement ?
Thanks a lot.
Parameters in OraTable
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24