Opened 16 years ago
Last modified 16 years ago
#921 closed Bug
AutoIt is retrieving wrong values from Data Base (AS400 Data Base) — at Initial Version
Reported by: | mmahima | Owned by: | |
---|---|---|---|
Milestone: | Component: | AutoIt | |
Version: | 3.3.0.0 | Severity: | None |
Keywords: | DB2 | Cc: |
Description
When i try to execute the following statements in autoit, it is retrieving wrong values from database, could any one help.
$sqlCon = objCreate("ADODB.Connection")
$objRecordSet = ObjCreate("ADODB.RecordSet")
$sqlCon.Open("Provider='IBMDA400';Data Source = '10.0.1.25';User Id='USERNAME'; password='Password';")
$oRs = $sqlCon.Execute("select * FROM ccdata.rcmast where MSACT# = '8217'")
MSGBOX(0,"",$oRs.Fields("MSACT#").value)
Expected values is 8217, whereas it is retrieving 6213.
I tried using VBseditor for executing the above statement, vbseditor is retrieving correct from database whereas autoit is displaying wrong values.