Subject | ERROR. "attempt to reclose a closed cursor" |
---|---|
Author | renatobraungil |
Post date | 2004-07-13T01:48:24Z |
The StoreProcedure makes a regitry in the table OperatorChat.
I created a Delphi Thread to excute this prcedure because I can use
it in a dial up conection.
If the StoreProcedure is executed without a Thread there's no bug,
but the user has same little breaks until the StoreProcedure ends.
CREATE PROCEDURE SP_SENDMSGOPERATOR (
pMsg VARCHAR(5000) )
AS
DECLARE VARIABLE VOP INTEGER;
begin
INSERT INTO OPERATORCHAT( OC_ID, OC_MSG )
VALUES( GEN_ID( GEN_OPERATORCHAT,1 ), :pMSG );
END
suspend;
END
Thank you all.
I created a Delphi Thread to excute this prcedure because I can use
it in a dial up conection.
If the StoreProcedure is executed without a Thread there's no bug,
but the user has same little breaks until the StoreProcedure ends.
CREATE PROCEDURE SP_SENDMSGOPERATOR (
pMsg VARCHAR(5000) )
AS
DECLARE VARIABLE VOP INTEGER;
begin
INSERT INTO OPERATORCHAT( OC_ID, OC_MSG )
VALUES( GEN_ID( GEN_OPERATORCHAT,1 ), :pMSG );
END
suspend;
END
Thank you all.