HeidiSQL shows only 50 rows for SELECT queries on InterBase

2 posts
zeus's profile image zeus posted 3 weeks ago in General Permalink

Hello,

When I run any SELECT on an InterBase database, I only see a maximum of 50 rows. Why is that? How can I retrieve the full result set?

Thanks in advance.

10711 posts
ansgar's profile image ansgar posted 3 weeks ago Permalink

That's probably some default property value in the underlying driver code. I need to check that in Delphi.

2 posts
zeus's profile image zeus posted 3 weeks ago Permalink

thanks ansgar, I love Delphi and it's would be crazy that a database tool made in delphi can not connect to Interbase ;)

Code modification/commit 271d062 from Ansgar Becker <anse@heidisql.com>, 3 weeks ago, revision 12.14.0.7170
fix: disable paging with 50 rows on Interbase/Firebird

See https://www.heidisql.com/forum.php?t=44710
10711 posts
ansgar's profile image ansgar posted 3 weeks ago Permalink

Just fixed that. Nightly build is online so you may try it per Help > Check for updates.

Please login to leave a reply, or register at first.