Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

Answers were Sorted based on User's Feedback



In QTP how to insert a data base check point for web based application and simultaneous link to co..

Answer / 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

In QTP how to insert a data base check point for web based application and simultaneous link to co..

Answer / shiva shankar

Even i have stuck with this database check point have you
got the solution for this how to insert a data base check
point pleace could you mail to my id
shiva_uma2003@rediffmail.com thaks in advance

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More VB Script Interview Questions

Explain what is loose binding? Why is it not a good practice to use it?

0 Answers  


* ** *** Please write a code to get output like above diagram? ple explain as it how the code works?

2 Answers  


How to find a latest file from any folder

3 Answers   Ness Technologies,


Consider there are objects in a webapp which are identified by QTP. Suppose you know only the logical name of a object(absolutely nothing else about it). Which approach will you take to find the "micClass" of the object(You can't use Object Spy, or can't add the object in repository)?

2 Answers   HCL,


How will you get the largest subscript of an array in vbscript?

0 Answers  


What is dictionary object in vbscript? Explain?

0 Answers  


Could Anybody Please tell me What is the script for Find 3rd Largest element in the Array without using a SORT function int Find(int arr[], int size); Thanks in Advance..

0 Answers   Amazon,


about vb scripting programs this type of all question& answers

0 Answers  


pls tell me which is good book or site for vbscript?

1 Answers   Mind Tree,


Which object is used to work with the excel sheets in the vbscript language and what statement is used to create this object?

0 Answers  


How will you get the natural logarithm of the given number in vbscript?

0 Answers  


What are the differences between Visual Basic, VBA and VBScript? When would it be appropriate to use one as opposed to another?

1 Answers   Infosys,


Categories