Modify ↓

Opened on Apr 22, 2009 at 10:35:22 AM

Closed on May 16, 2009 at 5:26:51 PM

#921 closed Bug (Wont Fix)

AutoIt is retrieving wrong values from Data Base (AS400 Data Base)

Reported by: mmahima Owned by: Jpm
Milestone: Component: AutoIt
Version: 3.3.0.0 Severity: None
Keywords: DB2 Cc:

Description (last modified by Valik)

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.

Attachments (0)

Change History (5)

comment:1 by TicketCleanup, on Apr 22, 2009 at 11:00:02 AM

Milestone: 3.3.1.0

Automatic ticket cleanup.

comment:2 by Jpm, on Apr 24, 2009 at 6:53:23 AM

Not sure some dev can help you as db2 is not a database use by default in our environment.
Can you reproduce with MSAccess database for instance?

comment:3 by Valik, on Apr 25, 2009 at 5:33:44 PM

Description: modified (diff)

Please read WikiStart on how to create a good ticket. You're making this overly difficult.

comment:4 by Jpm, on May 12, 2009 at 2:08:52 PM

Owner: set to Jpm
Status: new → assigned

comment:5 by Jpm, on May 16, 2009 at 5:26:51 PM

Resolution: → Wont Fix
Status: assigned → closed

I close it as I can't reproduce.
Please reopen with something we can reproduce in our tests.

Modify Ticket

Action
as closed The owner will remain Jpm.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.