| Subject | Re: [ib-support] Strange query results, based on where clause |
|---|---|
| Author | Bob Murdoch |
| Post date | 2002-02-26T17:46:11Z |
Daniel,
At 2/26/2002 11:20 AM, you wrote:
(The reason for the unusual syntax is that the query is built automatically
based on user input. The above syntax allows for multiple accounts to be
handled without additional processing by the query builder).
Bob M..
At 2/26/2002 11:20 AM, you wrote:
>What happens if you put "s.account_id=1", instead of "s.account_id in (1)"?Same thing - no rows returned.
(The reason for the unusual syntax is that the query is built automatically
based on user input. The above syntax allows for multiple accounts to be
handled without additional processing by the query builder).
Bob M..