Private Sub disp_Click()
adodc1.RecordSource = "select t_item, t_dsca, t_stoc from baan.ttiitm001800 where t_item >= '" & Trim$(rm1.Text) & "' and t_item <= '" & Trim$(rm2.Text) & "'"
adodc1.Refresh
Set DataGrid1.DataSource = adodc1
DataGrid1.Columns(2).NumberFormat = "Standard"
End Sub
Comments:
Actual data in Informix database for t_stoc is 13310, but when it is
displayed in VB6 datagrid column 2, we get 8.39591932516603E-316,
another info is that the Informix field is in "float" format.
We have tried using Scientific, Fixed, General and the results are 0.00.
Any help will be greatly appreciated.
Pls help.