Subject Re: [ib-support] Odd trigger's behaviour. USER and SELECT INTO.
Author Nick Upson
what happens if you replace

> SELECT E.ID from Employees E where E.Login LIKE USER into AUTH;

with

> SELECT E.ID from Employees E where E.Login IN (SELECT USER from
>rdb$database) into AUTH;

or

(declare additional variable usrstr)
usrstr = USER;
> SELECT E.ID from Employees E where E.Login = :uststr into AUTH;




_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com