For a start, it appears like you need to know about Generators?.
The essential elements are:
Create Generator GenSomeGenerator
Set SomeGenerator to 999
Update SomeTable set SOmeIntegerOutoIncColumn to gen_ID(genSomeGenerator, 1)
Insert into SomeTable (Columns Roster)
Values(Gen_ID(GenSomeGenerator, 1), OtherColumns)
Select Gen_ID(GenSomeGenerator, 1) from Dual
Cant drop a generator instead Delete it from RDB$Generators
If I have misunderstood your problem and inadvertently insulted you, then
SORRY!
Thetas about it.
Tony.
-----Original Message-----
From: Donovan J. Edye <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Wednesday, 2 February 2000 1:59 PM
Subject: [DUG]: Interbase Error : What am I missing here??? (Interbase
Newbie)
G'Day All,
Please put me out of my misery. Give the following stored procedure.....
SHOW PROCEDURE WRITETRANLOG
Procedure text:
============================================================================
=
DECLARE VARIABLE NextTranID Integer;
BEGIN
SELECT MAX(TranID) FROM CAS INTO :NextTranID;
NextTranID = NextTranID + 1;
INSERT INTO CAS VALUES (:NextTranID, "Some Magical SQL");
END
============================================================================
=
Parameters:
THE_SQL INPUT VARCHAR(50)
And the following trigger that calls the above stored proc....
CREATE TRIGGER SOMETABLEAFTERINSERT FOR SOMETABLE AFTER INSERT POSITION 0 AS
BEGIN
EXECUTE PROCEDURE WRITETRANLOG("adsa");
END
Why do I keep getting the error: (I must be missing something obvious here)
invalid request BLR at offset 19
parameter mismatch for procedure WRITETRANLOG
BDE Error: 13059 Server Error: -104 when I attempt to save my trigger in SQL
Explorer.
------------------------------------------------------------------------
--Donovan
Donovan J. Edye [www.edye.wattle.id.au]
Namadgi Systems, Delphi Developer
Web: www.namsys.com.au E-Mail: [EMAIL PROTECTED]
Voice: +61 2 6285-3460 Fax: +61 2 6285-3459
TVisualBasic = Class(None);
------------------------------------------------------------------------
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
