New build UniDAC incorrect Fields.Count on 64 bit Xe2

[Tomasz Andrzejewski]

Hello,

I Created simple application in XE2 Delphi and Windows 7 64 Bits.
I created two platform builds
a) 32 bit app
b) 64 bit app.

For 64 bit application I get bad Field.Count property

Code: Select all

unit UniDac;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Data.DB, MemDS, DBAccess,
  Uni, UniProvider, SQLServerUniProvider;

type
  TForm1 = class(TForm)
    SQLServerUniProvider1: TSQLServerUniProvider;
    UniConnection: TUniConnection;
    UniQuery1: TUniQuery;
    Button1: TButton;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;
  FQuery: string =
    ' SELECT ''Data1'', ''Data2'', ''Data3'', ''Data4'', ''Data5'', ''Data6'', ''Data7'', ''Data8'' ';

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  UniQuery1.SQL.Clear;
  UniQuery1.Params.Clear;
  UniQuery1.SQL.Add(FQuery);
  UniQuery1.Open;

  while not UniQuery1.Eof do
  begin
    ShowMessage(IntToStr(UniQuery1.Fields.Count));
    UniQuery1.Next;
  end;
end;

end.

It seams that this property for 64 platform returns 6 fields only (for 32 I get 8 fields).

[Tomasz Andrzejewski]

Am I alone with this problem?

[bork]

Hello

The UniDAC trial edition for 32-bit Windows hasn't any limitations, but the trial edition for 64-bit Windows has one limitation: queries return 6 fields maximum. So it looks like you use the UniDAC trial edition. Doesn't it?

[Tomasz Andrzejewski]

Hi,

Correct - thanks for yours replay.

[bork]

Hello

This limitation is in the trial edition only. So, if you purchase full version, there will not be any limitation and you will be able to get all 8 (or more) fields. If any other questions come up, please contact me.

[unique_login]

I downloaded demo of "dbExpress driver for SQL Server". Regarding the trial limitations readme states: "DbxSda trial version can be used within 30 days starting from the moment of installation.". Which is nto true unfortunately, I spent 2 days trying to understand why only first 6 fields are retrieved. Could you, devart, please make it more obvious for others, who will download this trial. You will save both your and our time. thanks.

[AndreyZ]

We will add the information about all restrictions of dbExpress driver for SQL Server Trial Edition to the "Trial limitations" section of the dbExpress driver for SQL Server documentation. Also, we will add this information on download pages of all the dbExpress drivers and the DAC products.