On 2007.10.24, shedis <[EMAIL PROTECTED]> wrote: > set sqlstmt "call MYPROC('SCANRES','2007-10-24 00:00:01','2007-10-24 > 23:59:59','%','%','%','%','%','%','%')"; ... > Output: > Database operation "select" failed (exception Error, "PROCEDURE > MYDB.MYPROC can't return a result set in the given context")
Remove the "call" from the SQL statement. Do you still get the error? -- Dossy -- Dossy Shiobara | [EMAIL PROTECTED] | http://dossy.org/ Panoptic Computer Network | http://panoptic.com/ "He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on." (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.