>I'm having trouble retrieving data from an Oracle Rdb database where a date calculation is involved (eg dDischargeDate - dDob <= 18 years).
>
>I have very little documentation about Rdb. Please note that Rdb is a step-child of Oracle so make no Oracle assumptions!
>
>Is it possible to subtract 2 dates in ANSI SQL92 and get a number of days, months, or years? What is the syntax?

When I have a date parameter for an ORacle retrieval, I have to convert the date to with dtoc() function first:

local cDate
cDate = dtoc(somedate)

My remote view SQL looks like:

...where Ora_DateField = ?cDate and ...

My SQL Passthru construction would be:

"... where Ora_DateField = '" + cDate + "' and ..."