Article View: comp.lang.pascal.delphi.databases
Article #71D3 & SLQA 5+ StoredProc not returning result set
From: Gaz
Date: Tue, 19 Jan 1999 00:00
Date: Tue, 19 Jan 1999 00:00
27 lines
1666 bytes
1666 bytes
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.
Technical Details
Message-ID:
<36a4a6bb.12020484@news.demon.co.uk>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ffff5,49835c688048482e,start X-Google-Attributes: gidffff5,public X-Google-Thread: ff75c,49835c688048482e,start X-Google-Attributes: gidff75c,public X-Google-Thread: 10de66,49835c688048482e,start X-Google-Attributes: gid10de66,public From: gpym@NOSPAM.sims.co.uk (Gaz) Subject: D3 & SLQA 5+ StoredProc not returning result set Date: 1999/01/19 Message-ID: <36a4a6bb.12020484@news.demon.co.uk> X-Deja-AN: 434435425 X-NNTP-Posting-Host: www.sims.co.uk:195.11.197.224 X-Trace: news.demon.co.uk 916760196 nnrp-02:10499 NO-IDENT www.sims.co.uk:195.11.197.224 Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop,borland.public.delphi.database.sqlservers X-Complaints-To: abuse@demon.net