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: 20Nov2024 at 7: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