Hi Prasad,
You can get record directly from any column using column id
means we have to use 0 for first column, 1 for second column etc.
set myRecord=CreateObject("ADODB.recordset")
sql = "select * from itms_client where name='akhi'"
'msgbox sql
myRecord.Open sql, myConnection
Val=myRecord(2) ' for 3rd column
Thanks...
Akhalesh
On Thu, Apr 10, 2014 at 4:55 AM, Prasad.L.V <[email protected]> wrote:
> Hi All,
>
> Could you please guide me how we can read any text form DB result
>
> we are executing DB query (Insert) and searching for it by creating the
> object for DB.
> but I dnt know how to read the value from it.
>
> eg:
> I executed select * from employee (from VBscript)
> how we can read the value from 2nd column, 1st row data?
>
> Thank you,
> L V Prasad. K
>
> --
> --
> 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.
>
--
Akhalesh yadav
+919555717928
+919310680659
--
--
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.
