Subject Re: [firebird-support] Re: IN clause limitation
Author Alexandre Benson Smith
Adam wrote:
> --- In firebird-support@yahoogroups.com, Alan.Davies@... wrote:
>
>> Wouldn't it be a whole lot easier if you had a Select_Yes/No field in
>> your main table. How does your user decide which CUSTOMERS he/she
>> wants? By a tick-box in a grid or similar.
>> This way you could use:
>> SELECT * FROM CUSTOMERS WHERE Select_Yes/No='Y'
>>
>> No limits; faster as well. No compromise on your security model either.
>>
>
> Yes. Much easier ...... until you want to have more than one user.
>
> Joining to temporary tables are the easiest way to implement this in a
> multi-user safe way. (You can use real tables providing you remember
> to empty them yourself if you aren't on 2.1).
>
> Adam
>
>

Not so different...

He can just have a field for the CONNECTION_ID or CURRENT_USER and
filter it.

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br