From: benny <be...@ch...> - 2004-04-15 07:21:14
|
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 |