Re: USER function

Posted in 1991

Donald Martin — Fri, 13 Dec 91 23:25:25 EST — source: Informix-list mailing list archive (1991-1998)

> > I am using the USER function in Informix/4gl program but get an error > when I compile it. Is this a bug? or is it not functional in 4GL ? > > DECLARE init CURSOR FOR SELECT * from Table_a where id = USER > > Thanks. > Ruchi. > I have seen the following function being used for that, but I am not sure how it handles (or doesn't) more than one user. Here it is with no promises made. FUNCTION get_id() p_char CHAR(16) SELECT UNIQUE user INTO p_user FROM systables RETURN p_user END FUNCTION Anyway, there it is for all too see. -- Donald Martin - dmartin@ukelele.UUCP {uunet, rutgers}!prometheus!ukelele!dmartin "No matter where you go, there you are"