Invalid Field Size with dbexpsda 2.0.4.

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
Moacir Schmidt

Invalid Field Size with dbexpsda 2.0.4.

Post by Moacir Schmidt » Wed 08 Dec 2004 15:29

When I upgrade my dbexpress driver from version 1.8.4 to version 2.0.4 I start receiving the message above in a query that previously worked well....The code follows...

procedure TMyTable.GetRecords(const Cmd:AnsiString);
var
Options : TGetRecordOptions;
RecsOut : integer;
DataSet : TCustomSQLDataSet;
begin
Options := [grMetaData,grReset];
DataSet := nil;
SQLConnection.Execute(Cmd,nil,@DataSet);
try
if DataSet nil then begin
FProvider.DataSet := DataSet;
FProvider.Options := FProvider.Options + [poRetainServerOrder];
Data := FProvider.GetRecords(-1, RecsOut, Byte(Options));
end;
finally
if DataSet nil then
DataSet.Close;
DataSet.Free;
end;
end;

Cmd is a query that contains a field of type int...i receive invalid field size in this field

Moacir

Post by Moacir » Wed 08 Dec 2004 16:12

Ops, I post it on the wrong place! It should be dbExpress driver for MSSQL

Guest

Post by Guest » Wed 08 Dec 2004 16:15

and ops again...the driver version i (tried) upgrade to was 2.0.3....

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Invalid Field Size with dbexpsda 2.0.4.

Post by Ikar » Thu 09 Dec 2004 10:24

We couldn't reproduce the problem.
Please send us complete small sample to demonstrate it and include script to create server objects.

Post Reply