I forgot to add that gfix -validate shows no errors. I'm running FB
1.5.1 and DBW 1.4.2. With JayBird RC4 I get (typo is from JB, not me):
org.firebirdsql.jdbc.FBSQLException: You cannot getAutomcommit on an
unassociated closed connection

-----Original Message-----
From: Rick DeBay
Sent: Tuesday, August 10, 2004 10:46 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] internal gds software consistency check
(partner index description not found (175))

I get this error:
internal gds software consistency check (partner index description not
found (175))

when I run a stored procedure that updates two tables that have a
foreign key relationship:

CREATE PROCEDURE INVOICE_ALL_CLAIMS (
INVOICE_NO VarChar(10),
INVOICE_DT Date)
returns (
INV_COUNT Integer)
AS
DECLARE VARIABLE ACCOUNT VARCHAR(15);
DECLARE VARIABLE PHARM DECIMAL(7,0);
BEGIN

FOR SELECT DISTINCT
ACCOUNTID,
SRVPROVID
FROM CLAIMSPAIDREVERSED
WHERE INVOICE IS NULL AND DATESBM <= :INVOICE_DT
INTO
:ACCOUNT,
:PHARM
DO BEGIN
INSERT INTO INVOICE (INVOICE_NO, ACCOUNT, PHARMACY)
VALUES (:INVOICE_NO, :ACCOUNT, :PHARM);

UPDATE CLAIMSPAIDREVERSED
SET INVOICE = :INVOICE_NO
WHERE
ACCOUNTID = :ACCOUNT AND SRVPROVID = :PHARM AND
INVOICE IS NULL AND DATESBM <= :INVOICE_DT;
END
SELECT COUNT(INVOICE) FROM CLAIMSPAIDREVERSED
WHERE INVOICE = :INVOICE_NO
INTO :INV_COUNT;
END

ALTER TABLE CLAIMSPAIDREVERSED ADD CONSTRAINT FK_CPR_INVOICE
FOREIGN KEY (INVOICE,ACCOUNTID,SRVPROVID) REFERENCES INVOICE
(INVOICE_NO,ACCOUNT,PHARMACY)
ON DELETE NO ACTION
ON UPDATE NO ACTION;

Rick DeBay
Senior Software Developer
RxStrategies.net




Yahoo! Groups Links