Devart Forums

Hello,
My situation is like this:
1. My setup is Delphi XE7, UniDAC 6.1.6, driver MYOCA1503 (comes as an add-on with AccountEdge CA 2015)
2. I have a database with a functional DSN named "accountedgeCa1"
3. I start my uniConnection and activate a TUniTable in this configuration:
Provider Name=ODBC;Login Prompt=False;Server=accountedgeCa1,
Options.DSNType=ntAuto
everything works ok yet my table shows only one record, instead of 4 (in the database).
4. I tried connecting with a TADOConnection and a TADOTable, all the records are showing. The ConnectionString I used is:
Provider=MSDASQL.1;Persist Security Info=False;Data Source=accountedgeCa1;
5. If I link the table in Microsoft Access all the records are also visible.

What am I doing wrong?
Thank you,
Bogdan

I have found a similar case here: http://forums.devart.com/viewtopic.php? ... dbc#p99450.
The workaround works also in my case.
Yet, setting FetchRows:=1 it's quite confusing.
Is there any chance to get a fix for this situation in one of the future releases?
Thank you,
Bogdan

Hello,

To solve the problem, set the ColumnWiseBinding SpecificOptions to True.

Hello,
Unfortunately, the ColumnWiseBinding trick doesn't seem to work.
Up to this moment the only thing that works is setting FetchRows to 1.
Bogdan

We have reproduced the described problem and will investigate the reason for such behavior.