Nick Upson wrote:

> 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;

Yeah! It works! But I want more clear syntax.

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

Yes. It works also. It's enough.
Thank you very much.

BTW I use Firebird 1.0 SS build 796 32bit IO for Linux.
File: FirebirdSS-1.0.0.796-0.i386.rpm 2704315 bytes

>
>
> _________________________________________________________________
> Join the world▓s largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/