Compound Selects 1

[MikeCopeland]

I'm using C/R v8.5 and need to do more complex "select" WHEREs than the expert permits. First, I need to do a compound select (e.g. WHERE date > start_date AND date <= end-date), as well as include the <NULL> cases in the selection. The expert doesn't seem to allow any sort of compound WHERE, nor does there seem to be a provision for <NULL>. Yes, I can manually modify the SELECT statement code, but that is tedious and error-prone.
Any thoughts? TIA

 

[synapsevampire]

Using experts is tedious and error prone, not the reverse.

Using experts is also lazy, and relinquishes control.

The null statement youseek is ISNULL, which must be performed first in any clause, and use Report->Selection Formula->Record to do the editing.

(
isnull({table.field})
and
{table.date} > {?start_date?
and
{table.date} < {?end_date?
)

If you don't want to do the coding, hire someone, but experts are generally for quick and dirty things in any application, and you'll hit the wall quickly.

Read this:

faq767-3825

-k