Subject | Re: [ib-support] Odd trigger's behaviour. USER and SELECT INTO. |
---|---|
Author | Nick Upson |
Post date | 2002-05-08T16:00:15Z |
what happens if you replace
(declare additional variable usrstr)
usrstr = USER;
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
> 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 fromor
>rdb$database) into AUTH;
(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