Page 1 of 1

New build UniDAC incorrect Fields.Count on 64 bit Xe2

Posted: Fri 30 Dec 2011 15:27
by 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).

Posted: Mon 02 Jan 2012 12:23
by Tomasz Andrzejewski
Am I alone with this problem?

Posted: Tue 03 Jan 2012 08:36
by 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?

Posted: Tue 03 Jan 2012 09:40
by Tomasz Andrzejewski
Hi,

Correct - thanks for yours replay.

Posted: Tue 03 Jan 2012 10:15
by 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.

Re: New build UniDAC incorrect Fields.Count on 64 bit Xe2

Posted: Thu 06 Sep 2012 08:31
by 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.

Re: New build UniDAC incorrect Fields.Count on 64 bit Xe2

Posted: Thu 06 Sep 2012 09:22
by 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.