Page 1 of 1

Invalid Field Size with dbexpsda 2.0.4.

Posted: Wed 08 Dec 2004 15:29
by Moacir Schmidt
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

Posted: Wed 08 Dec 2004 16:12
by Moacir
Ops, I post it on the wrong place! It should be dbExpress driver for MSSQL

Posted: Wed 08 Dec 2004 16:15
by Guest
and ops again...the driver version i (tried) upgrade to was 2.0.3....

Re: Invalid Field Size with dbexpsda 2.0.4.

Posted: Thu 09 Dec 2004 10:24
by Ikar
We couldn't reproduce the problem.
Please send us complete small sample to demonstrate it and include script to create server objects.