Executing a query using VB Script, no need to get the data RRS feed

  • Question

  • Hi,

    I have a couple of lines of quey which does update and delete of couple of entries in table. So here i dont want to fetch any data from DB , i only want to execute the queires. Can you please help on this.

    For fetching Data I am using as below:

    //Create a connection Object

    Set dbConnIn = CreateObject("ADODB.Connection")

    dbEAConnIn.Open strConString

    //Create a record set

    Set objRS= CreateObject("ADODB.RecordSet")

    //Execute the select Query

    objRS.Open strQueryGetData,strConString,3

    The above is working fine for me whhile fetching data from DB.

    Can you please let me know, if i want to execute a query(update/delete statement), What changes I need to do to above code.


    • Moved by Bill_Stewart Monday, September 11, 2017 3:20 PM Unanswerable drive-by question
    Thursday, July 6, 2017 6:46 PM

All replies