Subject Re: [firebird-support] Re: IN clause limitation
Author Alexandre Benson Smith
Adam wrote:
> --- In, 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:
>> 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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil