T,
> If I have misunderstood your problem and inadvertently insulted you, then
> SORRY!
Nope, not insulted.... Have got a heap of info on generators tho....
Generators is the better way to do things, but that was not really my
problem..... I'm more worried about the fact that I have been playiong with
Interbase for all of 30 mins and Nic has suggested recreating my
database!!!! :-0.....
------------------------------------------------------------------------
--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);
------------------------------------------------------------------------
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Tony Blomfield
> Sent: Wednesday, 2 February 2000 14:17
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Interbase Error : What am I missing here???
> (Interbase Newbie)
>
>
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
