07-29-2011, 07:15 PM
HI,
The file name property didn't worked as 2 similar Icons present in the page. I am also not found Index property in the Spy.
Please help me on this.
I found another solution for the problem but i don't have idea on doing this. Need Help on this.
I can get the value (8770,1) from database query ==> ("javascript:OpenEstimate(8770,1")
My Situation is as below
first i have to get a value from Text Box 'x/xxx/xxxx' and i have to store some where, I am storing that in data table or i can store in a variable (Ex) ==> This i achieved and i am able to store the value in variable p or in datatable.
Later on I have to fire a query in the database and should pass the value in to Query => Select ID, NumID from Costestimate where ReqID= 'P'
Then i can get the value => (8770,1)
Then i have to do descriptive programming to click on the Yellow Icon.
Please help me on my Situation. By providing the code. My database is SQLServer
I Don't know how to do but i tried this after that please help me
But how can i pass P(value) in to that Query
and i have to get the Database query result in to the QTP application
and i have to concatenate the rest of the string(javascript:OpenEstimate) to that value,
Then i have to click on the Yellow Icon
The file name property didn't worked as 2 similar Icons present in the page. I am also not found Index property in the Spy.
Please help me on this.
I found another solution for the problem but i don't have idea on doing this. Need Help on this.
I can get the value (8770,1) from database query ==> ("javascript:OpenEstimate(8770,1")
My Situation is as below
first i have to get a value from Text Box 'x/xxx/xxxx' and i have to store some where, I am storing that in data table or i can store in a variable (Ex) ==> This i achieved and i am able to store the value in variable p or in datatable.
Later on I have to fire a query in the database and should pass the value in to Query => Select ID, NumID from Costestimate where ReqID= 'P'
Then i can get the value => (8770,1)
Then i have to do descriptive programming to click on the Yellow Icon.
Please help me on my Situation. By providing the code. My database is SQLServer
I Don't know how to do but i tried this after that please help me
Code:
Dim MyConnection, ConnectionString
Set MyConnection = CreateObject("ADODB.Connection")
ConnectionString = Provider=sqloledb; Data Source=Ramesh; Initial Catalog=ProdDB;User Id=sa;Password=sa@123
Set MyRecordSet = CreateObject("ADODB.Recordset")
MyRecordSet.Open "Select ID, NumID from Costestimate where ReqID= 'P' "
But how can i pass P(value) in to that Query
and i have to get the Database query result in to the QTP application
and i have to concatenate the rest of the string(javascript:OpenEstimate) to that value,
Then i have to click on the Yellow Icon