dbedit 小数精度控制

我的数据库是access,字段类型是单精度,小数位数4位.
现在我用dbedit感知该字段,小数位数显示太多了,十几位.
请问我怎么控制显示的小数位数.用属性,函数,还是什么?

解决方案 »

  1.   

    object Form1: TForm1
      Left = 192
      Top = 107
      Width = 544
      Height = 375
      Caption = 'Form1'
      Color = clBtnFace
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      Icon.Data = {
        000001000200101010000000000028010000260000002020100000000000E802
        00004E0100002800000010000000200000000100040000000000C00000000000
        0000000000000000000000000000000000000000800000800000008080008000
        00008000800080800000C0C0C000808080000000FF0000FF000000FFFF00FF00
        0000FF00FF00FFFF0000FFFFFF00000000000000000000000000000000000000
        000000000000000000000006666008888888806EEF0000E6666606EEF000000E
        66606EEF06000000E606EEF000000000006EEF000000000006EEF00000000000
        6EEF068000000006EEF0E6680000006EEF000E6680000FFFF00000EEEE000000
        0000000000000000000000000000FFFF0000FFFF0000FFE00000000000000001
        000080030000C0010000E0010000F01F0000F01F0000E00F0000C00700008103
        00000381000007C10000FFFF0000280000002000000040000000010004000000
        0000800200000000000000000000000000000000000000000000000080000080
        000000808000800000008000800080800000C0C0C000808080000000FF0000FF
        000000FFFF00FF000000FF00FF00FFFF0000FFFFFF0000000000000000000000
        0800000000000000000000000000008000000000000000000000000000008000
        F08000000000000000000000008000F77000000000000000000000008000F77F
        FF080000000000000000008000F77F44770000000000000000008000F77F4499
        FFF0800000000000008000F77F44CC9987700000000000008000F77FF4DDCC89
        9FFF08000000008000F77FFF77DD7CC99877000000000000877FFF77FFF77CCF
        99FFF0800000807778FF77FFF77FFF7799F770000000F0077877FFF700000077
        F77FFF080000000000000000888888F77FFF770000000E8888888806EEEF077F
        FF77FFF0800000E66666606EEEF07FFF77FFF7700000000E666606EEEF00FF77
        FFF77FFF00000000E6606EEEF06607FFF77FFF77000000000E06EEEF00000FF7
        7FFF77FFF0800000806EEEF077FFF77FFF77FFF88000000006EEEF080FF77FFF
        77FFF887770800006EEEF066807FFF77FFF8877700000006EEEF0E66680F77FF
        F88777000800006EEEF070E66680FFF88777000800000FFFFF00070EEEEE0887
        7700080000000000000807700000077700080000000000000000007788877700
        0800000000000000000080777777000800000000000000000000000777000800
        0000000000000000000008070008000000000000000000000000000008000000
        00000000000000000000000800000000000000000000FFFFF3FFFFFFC3FFFFFF
        01FFFFFC01FFFFF000FFFFC000FFFF00007FFC00007FF000003FC000003F0000
        001F0000001F0000000F0000000F0000000780000007C0000003E0000003F000
        0001F0000001F0000000E0000000C00000038000000F0000003F020000FFFF00
        03FFFF000FFFFF803FFFFF80FFFFFFC3FFFFFFCFFFFF}
      OldCreateOrder = False
      PixelsPerInch = 96
      TextHeight = 13
    end
    //把上述Icon.Data = {...}中的内容加到你的From 中就有Excel图标了,哈哈。
      

  2.   

    Access 的精度問題.單精或雙精浮點數問題.51.7099999 是access保存的值.
    解决办法：
        1.提取出來後要手工截斷它(运算时).
    或：2.要不字段改為"數字/小數點格式":精確度=數字總長度,肅放比例=小數位數.
    或: 3.设定DataSet的该字段的Mask属性为：0.## (仅为了显示).
      

  3.   

    或用FormatFloat('#,##0.00',字段名)来控制
      

  4.   

    你可以这样，dbedit一定连着一个table，或是一个query吧，设一下固定字段，然后在那些数值型的固定字段的属性里有一个displayformat,把它设成0.00，就会显示两位小数的。try
      

  5.   

    设置数字型字段的DisplayFormat为'#,###.#0'
    最好了。
      

  6.   

    双击你用的DataSet
    把字段添加上去
    把这个字段的DisplayFormat属性为   0.0000
    DBEdit的字段名为这个字段名