Subject | RE: [IBO] SQDLA error |
---|---|
Author | John Tomaselli |
Post date | 2000-12-13T15:36:36Z |
-----Original Message-----
From: John Tomaselli [mailto:jrt@...]
Sent: Wednesday, December 13, 2000 10:24 AM
To: John Tomaselli
Subject: RE: [IBO] SQDLA error
Jason,
Since I last reported my "SQDLA missing or incorrect version, or incorrect
number/type of variables" problem, I did a litte research and found I was
calling the following Event on AfterInsert. Since I was well aware of the IB
Bug, having paid the price with my client's inventory, I was suprised to see
that I had not changed the StoredProcForSelect to true. Changing this
cleared up the problem.
John
procedure TfrmPO.IB_QPOAfterInsert(IB_Dataset: TIB_Dataset);
begin
// inherited;
with SP_GET_NEXT_PO_SEQ do
begin
Prepared := True;
parambyname('VJOB_ID').asinteger :=
IB_QPO.fieldbyname('JOB_ID').asinteger;
ExecProc;
end;
-----Original Message-----
From: John Tomaselli [mailto:jrt@...]
Sent: Wednesday, December 06, 2000 4:04 PM
To: IBObjects@egroups.com
Subject: RE: [IBO] SQDLA error
I rolled back to 3_6B to get rid of the same error. Note: 3_6C did not fix
it.
John
-----Original Message-----
From: Andreas Pohl [mailto:apohl@...]
Sent: Wednesday, December 06, 2000 9:34 AM
To: IBObjects@egroups.com
Subject: [IBO] SQDLA error
Since I updated to 3.6Bd I've got an error 335544569 "SQDLA missing or
incorrect version, or incorrect number/type of variables"
It is happen in loops for copying records:
while not q1.eof do begin
...
q2.insert; // raises an error!
...
q1.next;
end;
This pseudo code was working before updating. I think it is a transaction
problem; I'm using IB_Transaction.AutoCommit:=True;
BTW, I recognise this error using TIB_Query or TIB_DSQL. Is there any clue?
Mit freundlichem Gruss & Best Regards
Andreas Pohl
From: John Tomaselli [mailto:jrt@...]
Sent: Wednesday, December 13, 2000 10:24 AM
To: John Tomaselli
Subject: RE: [IBO] SQDLA error
Jason,
Since I last reported my "SQDLA missing or incorrect version, or incorrect
number/type of variables" problem, I did a litte research and found I was
calling the following Event on AfterInsert. Since I was well aware of the IB
Bug, having paid the price with my client's inventory, I was suprised to see
that I had not changed the StoredProcForSelect to true. Changing this
cleared up the problem.
John
procedure TfrmPO.IB_QPOAfterInsert(IB_Dataset: TIB_Dataset);
begin
// inherited;
with SP_GET_NEXT_PO_SEQ do
begin
Prepared := True;
parambyname('VJOB_ID').asinteger :=
IB_QPO.fieldbyname('JOB_ID').asinteger;
ExecProc;
end;
-----Original Message-----
From: John Tomaselli [mailto:jrt@...]
Sent: Wednesday, December 06, 2000 4:04 PM
To: IBObjects@egroups.com
Subject: RE: [IBO] SQDLA error
I rolled back to 3_6B to get rid of the same error. Note: 3_6C did not fix
it.
John
-----Original Message-----
From: Andreas Pohl [mailto:apohl@...]
Sent: Wednesday, December 06, 2000 9:34 AM
To: IBObjects@egroups.com
Subject: [IBO] SQDLA error
Since I updated to 3.6Bd I've got an error 335544569 "SQDLA missing or
incorrect version, or incorrect number/type of variables"
It is happen in loops for copying records:
while not q1.eof do begin
...
q2.insert; // raises an error!
...
q1.next;
end;
This pseudo code was working before updating. I think it is a transaction
problem; I'm using IB_Transaction.AutoCommit:=True;
BTW, I recognise this error using TIB_Query or TIB_DSQL. Is there any clue?
Mit freundlichem Gruss & Best Regards
Andreas Pohl