Sorry but I am working on a frontend oracle apps.
I dont need to connect to db server etc. 
there is a control called oracle table on front end and I need column names 
for that.

On Wednesday, 3 July 2013 19:14:48 UTC+5:30, Amit Kumar wrote:
>
> 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]<javascript:>
> > 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]<javascript:>
>> To unsubscribe from this group, send email to
>> [email protected] <javascript:>
>> 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] <javascript:>.
>> 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.


Reply via email to