To provide update statement in rs.open "update emp set sal=3000 where empno=2; and open ur table and chek whether your database is updated or not. Let me know any changes Thanks&Regards prasad
On Thu, Jul 26, 2012 at 9:39 PM, Tamil selvan <[email protected]>wrote: > Hai all, > > I updated data from application to database and i want to check, whether > that particular record is updated or not. > > I used Database checkpoint, but it is verified only the existing database > during the creation time.How I refresh the database for each updation and > check it using script. > > Anyone help. > > > > Regards, > > Tamil > > > On Thu, Jul 26, 2012 at 12:57 PM, siva prasad > <[email protected]>wrote: > >> >> Hi uday, >> >> >> wecan retrive the data from data base by using adodb >> method. >> set con=createobject("adodb.connection") >> set rs=createobject("adodb.recordset") >> con.provider="microsoft.jet.4.0.oledb"(for ms -access) >> con.open"dsn=dsnname" >> rs.open " provide the query",con >> while not rs.eof >> msgbox rs(0) >> rs.movenext >> wend >> Thanks&Regards >> >> prasad k >> >> >> On Wed, Jul 25, 2012 at 9:17 PM, Tamil selvan >> <[email protected]>wrote: >> >>> Hai uday, >>> >>> Using Adodb connection and Adodb Recordset, we can retrieve the data >>> from the database >>> >>> >>> On Sat, Jul 21, 2012 at 9:36 PM, Ganesh muralidharan < >>> [email protected]> wrote: >>> >>>> Have you tried using Database Query Wizard in QTP? >>>> >>>> Insert -> Output Value -> Database Output Value >>>> >>>> >>>> On Sat, Jul 21, 2012 at 11:49 AM, uday bhaskar <[email protected] >>>> > wrote: >>>> >>>>> good evening i wrote a script in VB which i want to get the data from >>>>> the msaccess but when i am running the code it is not running and getting >>>>> error dsn name is not taking but i created dsn name again still error is >>>>> coming and this is DSN Name MYDSN please clarify the query >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> "QTP - HP Quick Test Professional - Automated Software Testing" >>>>> group. >>>>> To post to this group, send email to [email protected] >>>>> To unsubscribe from this group, send email to >>>>> [email protected] >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/MercuryQTP?hl=en >>>>> >>>> >>>> >>>> >>>> -- >>>> Regards, >>>> >>>> >>>> Ganesh Muralidharan >>>> 'God Never Forgets' >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> "QTP - HP Quick Test Professional - Automated Software Testing" >>>> group. >>>> To post to this group, send email to [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected] >>>> For more options, visit this group at >>>> http://groups.google.com/group/MercuryQTP?hl=en >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> "QTP - HP Quick Test Professional - Automated Software Testing" >>> group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected] >>> For more options, visit this group at >>> http://groups.google.com/group/MercuryQTP?hl=en >>> >> >> >> >> -- >> prasad kopparapu >> +91-9032114331 >> >> -- >> You received this message because you are subscribed to the Google >> "QTP - HP Quick Test Professional - Automated Software Testing" >> group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/MercuryQTP?hl=en >> > > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > -- prasad kopparapu +91-9032114331 -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
