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.

Change History (0)

Note: See TracTickets for help on using tickets.