Say u have table "tt_Employ" with the following column
"ID","Name", "DateOfJoin"
then use following code to read Name of the employ ID=453
' Open the database
Set dbexample = CreateObject("ADODB.Connection")
' Set the connection string and open the connection
dbexample.ConnectionString =<connection string"
'Open db
dbexample.Open
Set recordset = dbexample.Execute("select top 1 * tt_Employ where ID=453")
To read Name of the ID=453, then use the following code
Msgbox recordset.Fields("Name")
' Close the database connection.
dbexample.Close
Set dbexample = Nothing
-Hokrani
On Fri, Sep 26, 2008 at 4:43 PM, kamani venkat <[EMAIL PROTECTED]>wrote:
> Hi,
>
> Plz answer my Query,
>
> After connecting the database using ADODB.CONNECTION,
> how can retrive data in percular column
>
> Thanks & Regards,
> Venkat
> Hyderabad
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
