It may help you...
Dim con,rs
Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")
con.provider="microsoft.jet.oledb.4.0"
con.open"d:\db.mdb"
rs.open"select*from EMP",con
For i = 0 To rs.Fields.Count - 1
column_name=rs.Fields(i).Name
Msgbox column_name
Next
On Wed, Jul 3, 2013 at 6:35 PM, Rahul Bengali <[email protected]> wrote:
> Did you find any solution to this problem. If yes please let me know.
>
> On Wednesday, 22 February 2012 22:10:33 UTC+5:30, manu wrote:
>>
>> Hi Everyone,
>>
>> Please let me know how to get the column names of a Oracle table in
>> Oracle Apps application using QTP.
>>
>> *My Requirement:
>> *
>> I am having an oracle table in a application. My requirement is to
>> validate whether Emp No and Emp Name columns are present in that table or
>> not.
>>
>> *Note :*
>>
>> We can get the column names in a table for a Web or Sibel application but
>> i need the syntax for oracle apps application.
>>
>> Thanks in Advance,
>> Manoj
>>
> --
> --
> 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/groups/opt_out.
>
>
>
--
--
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/groups/opt_out.
