As per email before (other than that nowhere that I know of):

>BEGIN
> SELECT
> LP_PROCESSNAME,
> LP_LOGMASK,
> LP_LOGPATH,
> LP_DAYLIMIT
> FROM
> LOGPARAMS
> WHERE
> UPPER(LP_PROCESSNAME) = UPPER(:LP_PROCESSNAME_IN)
> INTO
> :LP_PROCESSNAME,
> :LP_LOGMASK,
> :LP_LOGPATH,
> :LP_DAYLIMIT;
> SUSPEND;
>END

I get no exception if I use "SELECT *" so I can't imagine there is anything
in my code.


Malcolm Smith
Analyst Programmer
Comvision Pty Ltd
http://www.comvision.net.au



-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Friday, 26 November 2004 17:51
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] A problem with a procedure



So where is FROM being used?

Helen