Hi Vishal,
You can try the following code in order to get the value from MS DB access,
Set oDb=CreateObject("ADODB.CONNECTION")
oDb.open"Provide=.....;Data Source=........"
oData=oDb.Execute(Query)
Fields=oData.fields.count
For i=0 to Fields-1
Do until oData.EOF
FieldValue=oData.field(i).value
msgbox FieldValue
oData.Movenext
Loop
oData.MoveFirst
Next
Please let me know if you need any further information regarding this.
On Thursday, July 10, 2014 11:27:54 AM UTC+5:30, Vishal wrote:
>
> Hi,
>
> Can anyone suggest me that how we can handle multiple rows in recordset?
>
> Currently I am getting multiple rows as a query result and get value from
> each row one by one. how to do that?
>
> I am using MS Access db as a data source.
>
> Awaiting for help.
>
> Thanks,
> Vishal
>
--
--
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 Groups "QTP
- HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
