VB writes wrong numbers to oracle
Hi
I am using VB to write data into Oracle 9i. At the same time as I write to Oracle I also write to a text. I have noticed that the text file is correct but Oracle sometimes seems to add lots of decimal places and I think that this is due to rounding in VB - eg 1.4 becomes 1.400001 in oracle. This normally does not matter. Recently however I have found that the text file reads 130.6077 and Oracle reads 132.608001708984 - how weird is that!:confused:
Any help or advice would be most welcome and thanks in advance.
Here is the VB code:
DECLARE THE LOGDATA PARAMETER-----
Public pLogData As New ADODB.Parameter
SETUP THE PARAMETER-----
pLogData.Direction = adParamInput
pLogData.Type = adSingle
cmWriteLog.Parameters.Append pLogData
WIRTE TO ORACLE, THE SCREEN AND ENG LOG
Sub WriteLog(ByVal EntryCode As String, ByVal RobotEvent As String, Optional ByVal LogData As Single = 0)
'add this log message to the screen - at the top of the list
frmMimic.lstUserLogLog.AddItem CurrentTestRun.novi_test_number & " " & Time & " " & EntryCode & ": " & RobotEvent & ": " & LogData, 0
'add to the Oracle log file
pTestNumber.Value = CurrentTestRun.novi_test_number
pRobotEvent.Value = RobotEvent
pLogData.Value = LogData
pEntryCode.Value = EntryCode
cmWriteLog.Execute 'get oracle to write it
'also add it the engineering log
WriteEngLog RobotEvent, EntryCode, LogData
End Sub