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
