Forum Discussion

Donald_Baugh's avatar
Donald_Baugh
Occasional Contributor
12 years ago

Using SQL to stage test data fails after update to TC 9.31

I was using SQL to update data for staging tests.  After upgrading TestComplete to 9.31 my SQL updates no longer work.  No error is returned.  But my data remains unchanged my by update statements.


var mySQLStatement = "update RESIDENT_FACILITY set EXIT_DT = '02/01/2014' where PRU_CODE = 'QA_1020_1020_0003'";

var myConnection = new ActiveXObject( "ADODB.Connection" );

myConnection.Open( "DSN=OSC2OR;Uid=AAA;Pwd=" );

myConnection.execute( mySQLStatement );

myConnection.CommitTrans();

myConnection.Close();



If someone has encountered and/or solved this issue, your help would be greatly appreciate

 


1 Reply

  • Donald_Baugh's avatar
    Donald_Baugh
    Occasional Contributor
    12 years ago
    My apologoies for jumping too quickly to post my question when I should have investgated my problem more deeply.  I just verified with a quick short javascript test that I can connect and query, and update my database.  Now I just have to find the my error and fix my original test.