Subject | Re: [ib-support] Strange query results, based on where clause |
---|---|
Author | Bob Murdoch |
Post date | 2002-02-26T16:02:34Z |
At 2/26/2002 09:46 AM, you wrote:
clause as is and only changing the number of account id's returns the
correct info, so it seems that the date part was able to be matched.
Bob M..
>If you are using DateTime fields, it may not find an exact match because ofThat was my thinking as well. However, leaving the date part of the where
>the time factor involved. That's why using a range of the date works but the
>exact match doesn't. I always make sure I use only the date portion when
>setting fields so I don't have this problem.
clause as is and only changing the number of account id's returns the
correct info, so it seems that the date part was able to be matched.
Bob M..