Only 1 row is getting returned for TUniTable

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
blazarz
Posts: 8
Joined: Tue 09 Dec 2014 16:11

Only 1 row is getting returned for TUniTable

Post by blazarz » Wed 06 May 2015 16:35

I am using UniDAC to connect to an IBM iSeries using ODBC. The previous version of the iSeries Access ODBC driver (5.4) worked fine. However, since upgrading to iSeries Access 7.1, the TUniTable is only returning the first record in the table. Any ideas what can be causing this?
Top
blazarz
Posts: 8
Joined: Tue 09 Dec 2014 16:11

Re: Only 1 row is getting returned for TUniTable

Post by blazarz » Wed 06 May 2015 17:31

I'll post my own answer in case someone else has a similar issue. To resolve this, I went into the Macro properties, went into the "options" table and set the "DetectFieldsOnPrepare" value to false. Seems to be ok now, all records are being read
Top
azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Only 1 row is getting returned for TUniTable

Post by azyk » Fri 08 May 2015 11:58

It is good to see that the problem has been solved. Feel free to contact us if you have any further questions about UniDAC.
Top
Post Reply

Return to “Universal Data Access Components”