Print Page | Close Window

QTP Script to Update Database Data Printed From: One Stop Testing Category: Testing Tools @ OneStopTesting Forum Name: QuickTest Pro @ OneStopTesting Forum Discription: QuickTest Pro is a fresh approach to automated software and application testing that addresses testing needs of both business analysts and Quality Assurance professionals. URL: http://forum.onestoptesting.com/forum_posts.asp?TID=7377 Printed Date: 10May2024 at 12:38am Topic: QTP Script to Update Database Data Posted By: Mithi25 Subject: QTP Script to Update Database Data Date Posted: 25Nov2009 at 10:43pm VBScript to update data in database table. We have table "EMP" in database "db"(Microsoft Access). EMP Table has following data in it. EMPNO EMPNAME EMPSAL 1 Lakshmi 30000 2 Laxmi 25000 3 Latha 15000 http://sqlqueriescollection.blogspot.com/ - Dim con,rs set con= CreateObject( "ADODB.Connection") set rs =CreateObject("ADODB.Recordset") con.provider="microsoft.jet.oledb.4.0" con.open"d:\db.mdb" rs.open "update EMP set EMPSAL=50000 ",con msgbox("Updated") Above script(code)will update database table(EMPSAL=50000). Output: EMPNO EMPNAME EMPSAL 1 Lakshmi 50000 2 Laxmi 50000 3 Latha 50000 ------------- http://www.quick2sms.com - Send Unlimited FREE SMS to Any Mobile Anywhere in INDIA, Click Here

Print Page | Close Window