Page 1 of 1

StoredProcedure Bug in 5.7.26

Posted: Wed 09 Nov 2016 16:15
by erich_k4
Hi,
after i upgraded to v 5.7.26 the following does not work as expected:

Code: Select all

DM.SP_GET_ARTIKELBYID.PrepareSQL( true );
DM.SP_GET_ARTIKELBYID.ParamByName( 'P_ID_ARTIKEL' ).asInteger := Artikel_ID;
DM.SP_GET_ARTIKELBYID.ExecSQL;
if DM.SP_GET_ARTIKELBYID.RecordCount > 0 then // <--- Recordcount always 1
After executing the SP the recordcount is always 1 even if there are more records returned!

Reverting back to v 5.7.25 everything works again!

Greetings
Erich

Re: StoredProcedure Bug in 5.7.26

Posted: Thu 10 Nov 2016 10:02
by ViktorV
Unfortunately, we could not reproduce the issue.
In order to get a detailed answer, please compose a small sample demonstrating the described behavior and send it using the contact form https://www.devart.com/company/contactform.html including scripts for creating database objects. Also please specify the Firebird version you are using.

Re: StoredProcedure Bug in 5.7.26

Posted: Tue 22 Nov 2016 11:10
by erich_k4
With the latest version 5.7.27 it works again!

Re: StoredProcedure Bug in 5.7.26

Posted: Tue 22 Nov 2016 12:14
by ViktorV
It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.