Interested to Buy Any Domain ? << Click Here >> for more details...
In QTP how to insert a data base check point for web based
application and simultaneous link to code in expert veiw.
hw to retrieve a data(single coulumn from server) that
matches with inserted value manually or exported from excel
sheet.
- 2 Answers
- 7645 Views
- I also Faced
- E-Mail Answers
Answer Posted / gayatri
I have coded this, can anyone plz rectify and send
Dim con, rs, username1
Set con=Createobject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
con.connectionString="Drivers={SQLServer};
DSN=<dsn_name>; OPTION=0; PWD=konnects; PORT=<port name>;
SERVER=<server name>; UID=konnects"
con.open
rs.open SQL ,conn
SQL= "select user_name from t_member"
Set rs=con.Execute(SQL)
DbTable("DbTable").Check CheckPoint("DbTable")
on error resume next
while rs.EOF
Do Until username1=user_name
username1=rtrim(rs.fields("user_name"))
msgbox username1
If username1=username Then
Msgbox " User name already exist try another"
Username=inputbox("Username")
msgbox User_name
else
rs.MoveNext
end if
loop
wend
rs.close
con.close
Set rs = Nothing
Set con = Nothing
Browser("").Page("page name").WebEdit("UserName").Set
UserName
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If we take 2 strings as “good” and “bad” then what will ‘+’ and ‘&’ operators return?
What are string functions in vbscript?
How to capture a runtime error in vbscript?
What is the purpose of folders object of scripting.filesystemobject class in vbscript?
can anyone send me a vb scripts code for clicking on a link and coming back on home page again does the same for many links on a web page.
How are arrays declared in the vbscript language?
How to replace junk code recorded by QTP with a mall function.
Which respective symbols are used to separate a line and to break the lengthy statement into multiple statements in the vbscript language?
Explain about the extension .hta?
How to identify column in VSFlexgrid? My VSFlexgrid window is identified as 'Active X Control'
How will you release the memory acquired by an array variable in vbscript?
Mention what is the main difference between function and sub-procedure?
Which command is used for writing text on a page?
what is the standards used for writing the script in QTP
Hai this is sheik, i want to learn VB scripts for web application pls guide me what are all basic things need to know to learn VB scripts in web application.
