while giving the query give like this

select * from customer where customername='Prasad'

By giving this query you will be getting a single value.

Regards
Mahesh




On Sat, Mar 22, 2014 at 11:32 AM, pavani b <[email protected]> wrote:

> Hi,
>
> U can try this
>
> Move to the particular row using this
>  rs.Move(3,1)-moves to 3rd position from starting
>
> Read the value from req column
> rs.Fields(3).value-refers to 4th column value(whre index starts form 0)
>
>
>
>
>
>
> On Monday, March 17, 2014 2:42:40 PM UTC+5:30, L V Prasad wrote:
>
>> Hi All,
>>
>> I am with QTP DataBase connections, Could you please guide me on below
>> scenario:
>>
>> - We have a table (customer) with Column as CreatedDate.
>> we already have some scripts to create connection and insert/update query
>> for it.
>>
>> Now I wanted to read the value (date) under CreatedDate column for a
>> specific line (say where customername=Prasad)
>>
>> how to read the date in specific table.
>>
>> 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.
>

-- 
-- 
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.

Reply via email to