Thread View: borland.public.cppbuilder.database.dbexpress
1 messages
1 total messages
Started by Gi
Tue, 22 Feb 2005 13:50
TIBQuery
Author: Gi
Date: Tue, 22 Feb 2005 13:50
Date: Tue, 22 Feb 2005 13:50
55 lines
2589 bytes
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