🚀 go-pugleaf

TStoredProc does not work well with odbc databases. Use TQuery instead:
Q.SQL.Add('call grouptest()');
Q.Open;

One thing that is puzzling me is "FUNCTION" in the error message.
Check if you have a function with the same name:
select * from sysprocedure where proc_name='grouptest';

A good practice is allways prefix a proc (a table too) with creator name:
call public.grouptest()

--
----------------------
Regards
Robert Cerny
Remove both qwe when replying
email: robert.qwe.cerny@neosys.xrs.qwe.si

No questions via email, unless explicitly invited.
Gaz wrote in message <36a4a6bb.12020484@news.demon.co.uk>...
>I'm using Delphi 3 c/s with SQL Anywhere 5.5 and
>I'm trying to run a simple Watcom SQL StoredProc that returns a 2
>column multiple row result set, but keep getting
>"Syntax Error - Wrong number of parameters to FUNCTION 'GroupTest'.
>
>The StoredProc component has picked up the two parameters defined and
>I assume will use these for passing multiple results back?
>
>This is the Procedure I am trying to call:
>
>alter procedure grouptest()
>result(base_group_id integer,description varchar(32))
>on exception resume
>begin
>  select base_group_id,description
>    from sims.base_group
>    where base_group_type_id=12
>end
>
>if The same proc is converted to Transact SQL - the error is 'Trying
>to return a multiple row result set' (or something similiar).
>
>Any help on this would be appreciated,
>
>Gareth.
>
>Please remove the NOSPAM if you wish to reply by e-mail.