| Subject | RE: [ib-support] Strange query results, based on where clause |
|---|---|
| Author | Bob Murdoch |
| Post date | 2002-02-26T22:18Z |
At 2/26/2002 04:45 PM, you wrote:
However, it still doesn't change the fact that adding another account to
the where clause suddenly makes the query start returning rows for the
original account.
Bob M..
>Session -> Basic Settings -> Show Time DataTypeYep. Forgot about that setting in Wisql, I thought it was on by default.
>
>My guess is that it's storing 00:00:00, for the time. That, more than
>likely, explains some of what you're seeing.
However, it still doesn't change the fact that adding another account to
the where clause suddenly makes the query start returning rows for the
original account.
Bob M..