My stored procedure (below) wont work. When I call execproc I get either a
parameter or type mismatch or I am told there is no Params[0] - the return
value. The generator it uses has not incremented.
I have an IB Insert TRigger that correctly uses the generator to fill in a
Null field value when
On 30 May 2001, at 9:21, James Low wrote:
My stored procedure (below) wont work. When I call execproc I get either a
parameter or type mismatch or I am told there is no Params[0] - the return
value. The generator it uses has not incremented.
I have an IB Insert TRigger that correctly uses
HTH
Cheng
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of James Low
Sent: Wednesday, 30 May 2001 09:21
To: Multiple recipients of list delphi
Subject: [DUG]: Interbase/Delphi Stored Procedure
My stored procedure (below) wont work. When I call
CREATE PROCEDURE PRO_GETSLPRTY
RETURNS (ID_SLPRTY INTEGER)
AS
BEGIN
ID_SLPRTY = gen_id(GEN_SLPRTY, 1);
um, dont you need a
SUSPEND;
right about here? Or is that just for ones you execute with
select * from PRO_GETSLPRTY
??
Thats because u r trying to pass a input parameter
Nic Wise [EMAIL PROTECTED] wrote on 30/05/2001 09:46:33:
CREATE PROCEDURE PRO_GETSLPRTY
RETURNS (ID_SLPRTY INTEGER)
AS
BEGIN
ID_SLPRTY = gen_id(GEN_SLPRTY, 1);
um, dont you need a
SUSPEND;
right about here? Or is that just for ones you execute with
select * from PRO_GETSLPRTY
recipients of list delphi
Subject: Re: [DUG]: Interbase/Delphi Stored Procedure
On 30 May 2001, at 9:21, James Low wrote:
My stored procedure (below) wont work. When I call execproc I get either a
parameter or type mismatch or I am told there is no Params[0] - the return
value. The generator it uses