Hi all,

When trying to commit the following stored procedure I keep getting the
following error message.

My lack of knowledge is preventing me from fixing the problem as I can
not work out what the problem is.

Could someone please help.

--------- Error Message --------------------------

ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
expression evaluation not supported

------- Stored Procedure -------------------------

declare variable Send SmallInt;
declare variable FTime TimeStamp;
declare variable Stat BigInt=0;
declare variable L_ON TimeStamp;
declare variable L_OFF TimeStamp;
declare variable TempID BigInt=0;
declare variable F_Name VarChar(80);
declare variable L_Name VarChar(80);
declare variable F_Word VarChar(80);
begin
FTime= 'Now' - (3/1440); /*create the check time stamp*/

for select DETECTID,FIRSTNAME,LASTNAME,PSWORD,ON_LINE,LOG_ON_TS,LOG_OFF_TS
from CONTACTS where DATATYPE=14365 and ALLOW_ACCESS=1
into :TempID,:F_Name,:L_Name,:F_Word,:Stat,:L_ON,:L_OFF
do
begin
Send=0;
if (Stat=0) then Send=1;
else
if (:FTime > :L_OFF) then Send=1;

if (Send=1) then
begin
ID=:TempID;
FNAME=:F_Name ||' '||:L_Name;
PWORD=:F_Word;
suspend;
end
end
end

Thanks in advance.

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results