Hi,
=20
While using firebird.net data provider 1.6 Beta on Delphi8 with =
Firebird1.5, I couldn't fetch the field with large Int field correctly.
My table :-=20
CREATE TABLE "DOWNLOAD"=20
(
"CSD_ID" "CS_AUTO_GEN_NO",
"CSD_DOWNLOAD_VERSION" DECIMAL(8, 4));
And My code are as follow:-
FbConnBiz.Open;
FbBizTxn :=3D FbConnBiz.BeginTransaction;
FbCommDownload :=3D FbCommand.Create('select * from DOWNLOAD where =
CSD_ID =3D @CSD_ID' , FbConnBiz, FbBizTxn);
FbCommDownload.CommandType :=3D CommandType.Text;
parameterDownloadID :=3D FbParameter.Create('@CSD_ID', =
FirebirdSql.Data.Firebird.FbDbType.Text);
parameterDownloadID.Value :=3D DownloadID;
FbCommDownload.Parameters.Add(parameterDownloadID);
parameterDownloadVersion :=3D =
FbParameter.Create('@CSD_DOWNLOAD_VERSION', =
FirebirdSql.Data.Firebird.FbDbType.BigInt);
FbCommDownload.Parameters.Add(parameterDownloadVersion);
Reader :=3D FbCommDownload.ExecuteReader;
Reader.Read;
*** textbox.Text :=3D FloatToStr(Reader.GetInt64(6));
FbConnBiz.Close;
I have record e.g.=20
CSD_ID CSD_DOWNLOAD_VERSION
1 1.1=20
in line *** for textbox.Text I should have value 1.1 but what I get is =
11000 !? why ? did I done anything wrong?
The similiar result occur too while loading the data to datagrid ...=20
my code loading data to the datagrid:-=20
......
FbdadptrMyOrder.SelectCommand :=3D FbCommMyOrder;
FbdadptrMyOrder.Fill(dsMyOrder, 'TempInfo');
dgrdMyOrder.DataSource :=3D dsMyOrder.Tables['TempInfo'];
dgrdMyOrder.DataBind;
on field CSD_DOWNLOAD_VERSION I have data 11000 but actually I have =
value 1.1 on database...
TIA
=20
regards,
benny ;)=20
|
