🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.cppbuilder.database.dbexpress
1 messages
1 total messages Started by Gi Tue, 22 Feb 2005 13:50
TIBQuery
#137
Author: Gi
Date: Tue, 22 Feb 2005 13:50
55 lines
2589 bytes
Hi, TIBQuery component can insert in database a stored procedure???
I try to insert stored procedure but I have an exception 
:"EibInterbaseError: invalid reguest BLR at offset 384: bad parameter 
number".
With IBConsole tha same come works!
Procedure is:

CREATE PROCEDURE INSERT_ACCONTO (
         ID_PERSONA                 INTEGER,
         ID_SOCIETA                   INTEGER,
         ID_TIPO_CONTO           SMALLINT,
         ID_TIPO_PAGAMENTO SMALLINT,
         DATA_PAGAMENTO    TIMESTAMP,
         EURO                              NUMERIC(8,2),
         COMM_ACCONTO      VARCHAR(255),
         NUM_DOCUMENTO     SMALLINT,
         ID_PRENOTAZIONE      INTEGER)
returns (ID INTEGER)
AS

begin
        IF (ID_SOCIETA = 0) THEN ID_SOCIETA=NULL;
        IF (ID_PERSONA = 0) THEN ID_PERSONA=NULL;
        IF (ID_PRENOTAZIONE = 0) THEN ID_PRENOTAZIONE=NULL;

        ID = GEN_ID(COUNTER_ID_ACCONTO,1);
        INSERT INTO
          ACCONTI (ID_ACCONTO,
                   ID_PERSONA,
                   ID_SOCIETA,
                   ID_TIPO_CONTO,
                   ID_TIPO_PAGAMENTO,
                   DATA_PAGAMENTO,
                   EURO ,
                   COMM_ACCONTO,
                   NUM_DOCUMENTO,
                   ID_PRENOTAZIONE
                  )

        VALUES(:ID,
               :ID_PERSONA,
               :ID_SOCIETA,
               :ID_TIPO_CONTO,
               :ID_TIPO_PAGAMENTO,
               :DATA_PAGAMENTO,
               :EURO,
               :COMM_ACCONTO,
               :NUM_DOCUMENTO,
               :ID_PRENOTAZIONE
               );
        EXIT;
end

if in values I insert values instead od parameters TIBQuery  doesn't return 
any error. 
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads