Subject | Re: [IBO] Date issue ( again ) |
---|---|
Author | Geoff Worboys |
Post date | 2001-03-12T12:00:16Z |
> The question was arise since I only change the SQL fromCheck that IBOQuery.CallbackInc = -1 (which I believe is the default
> 'SELECT * FROM SalesCall' to 'SELECT * FROM SalesCall
> WHERE ......' and putting some variable initialization,
> and the report doesn't work anymore.
to TIBOQuery anway). Also check that you do not have other controls
attached to the dataset/datasource while reporting - and least during
experimentation.
Remember that NULL is a state and not a value, so NULL date values
will not be included in a range selection. You would explicitly have
to include an "OR MYDATE IS NULL" clause.
Run the SQLMonitor dialog, it may help show if there are any apparent
differences in what is happening in the report versus what is
happening on a grid.
Geoff Worboys
Telesis Computing