SPL with WebBlade gives reserved words error -675

All, little wee problem with WebBlade... If I have a simple table create table t(key integer); and a very simple function foo: create function foo(int i) returning integer; insert into t(key) values(i); return i; end function; I can successfully call this from dbaccess or isql with 'execute function', directly from another SPL, even manually begin a transaction and commit (as does WebBlade), but...if it is called from WebBlade it dies with a "-675: Illeagal SQL statement in stored procedure." According to trace and other debugging, it is dying when it tries to insert - something like a mutable statement I guess. Does anyone know what the WebBlade is doing that makes it die? If I can't get this to work its going to kill some nice packaging... TIA, Andrew.

The dreaded 675 :-)))) You need to be setting MIqry2pass=on when the page is called. Don't set MIqry2pass unless you need it though, 'cos the SQL becomes less efficient Andrew McPherson wrote: > > All, > little wee problem with WebBlade... > > If I have a simple table > create table t(key integer);> > and a very simple function foo: > > create function foo(int i) > returning integer;> > insert into t(key) > values(i);> > return i; > end function; > > I can successfully call this from dbaccess or isql with 'execute function', > directly from another SPL, even manually begin a transaction and commit (as > does WebBlade), but...if it is called from WebBlade it dies with a "-675: > Illeagal SQL statement in stored procedure." > > According to trace and other debugging, it is dying when it tries to > insert - something like a mutable statement I guess. Does anyone know what > the WebBlade is doing that makes it die? If I can't get this to work its > going to kill some nice packaging... > > TIA, > Andrew. -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #