2.07.06 bug - Delphi 7 TnxQuery code with "USING" clause broken

I have Delphi 7 code which has been broken by 2.07.06 - it was fine with
2.07.02:

Using a tnxQuery component on a TDataModule, the code snippets are:

cSQL_GetAnimalID_RFID =
'SELECT "AnimalID" FROM Animal INNER JOIN Devices USING (DeviceID) WHERE
Devices."RFID" = :RF_ID';

with My_tnxQuery do
begin
Database := MyDatabase;
SQL.Clear;
SQL.Add(cSQL_GetAnimalID_RFID);
Prepare;
end;

function TdmPxFarmsData.GetAnimalID(const aRFID : string) : integer;
begin
Result := -1;
with My_txQuery do
begin
if Active then
Close;
ParamByName('RF_ID').AsString := aRFID;
Open;
if RecordCount > 0 then
begin
First;
Result := FieldByName('AnimalID').AsInteger;
end;
end;
end;

With 2.07.06, the first call to GetAnimalID is successful. All subsequent
calls then fail - it doesn't find any further records.
Same code with 2.07.02 works as expected, finding a record each time.

Replacing cSQL_GetAnimalID_RFID with any of the following causes the code to
work with 2.07.06:

SELECT "AnimalID"
FROM Animal INNER JOIN Devices USING (DeviceID)

WHERE D."RFID"=''%s''



SELECT A."AnimalID"

FROM Animal A INNER JOIN Devices D ON (A."DeviceID"=D."DeviceID")

where D."RFID" = :RF_ID



Unfortunately, our code uses many "USING" clauses with parameterized SQL
statements, so these workarounds are not an option.

Can a fix be made available for this problem, as it is now holding up a
major release of our product?

Thanks,
Greg

> Can a fix be made available for this problem, as it is now holding up
> a major release of our product?

First theory; try removing the Prepare; call. 2nd, we'd like to borrow
the table and the actual param values to have a go at fixing.

--

Eivind Bakkestuen
Nexus Database Systems Pty Ltd

Thanks Eivind,
Removing the Prepare call does then let the code run as expected.
I have separately emailed directly to you the two nexusdb tables and a csv
file with the param values.

"Eivind Bakkestuen [NDD]" <Ieivind.bakkestuenHATE@nexusdb.comSPAM> wrote in
message news:xn0fqrm1sd5h92000@news.nexusdb.com...
>> Can a fix be made available for this problem, as it is now holding up
>> a major release of our product?
>
> First theory; try removing the Prepare; call. 2nd, we'd like to borrow
> the table and the actual param values to have a go at fixing.
>
> --
>
> Eivind Bakkestuen
> Nexus Database Systems Pty Ltd