Quality is delighting customers
Tags:
how to create script for
Run backup script to reset history to contain necessary data to trigger desired notification.
Backup Script Path : P:\ABCD\OJIS\ED\AllShared\CJRDM_reset_NYSIDs\CCH_Notiification_TSTIJ\1404.sql
|
Set objCon=CreateObject("ADODB.Connection")
Set objRs=CreateObject("ADODB.RecordSet")
conStr="Provider=SQLOLEDB.1;Password=pa55w0rd!;Persist Security Info=False;User ID=pboas;Initial Catalog=DBTraining;Data Source=<source> "
objCon.ConnectionString =conStr
objCon.Open
Set objCom=CreateObject("ADODB.Command")
objCom.ActiveConnection=objCon
Set fso=createobject("scripting.filesystemobject")
Set app=createobject("quicktest.application")
root=fso.GetParentFolderName(environment("TestDir"))
projectfolder=fso.GetParentFolderName(root)
print projectfolder
executefile "Filepath"
g=inputbox("enter user id ")
query=("select * from flightlog where userid="+g)
Set objRs=objCon.Execute(query)
Do Until objRs.EOF=True
f=objRs.Fields("userName").Value
e=objRs.Fields("pasword").Value
Print "The User Name and Password are : " & f & e
From the values in f and e we can assign it to data table.
© 2021 Created by Quality Testing.
Powered by