Hi MZR
Are you giving the following query in one line or two lines?
' strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs WHERE rownum
<
11"
Also, what is the error message that you are getting? (Check whether
your query is correct first)
Let me know.
If you are giving it in two lines, then you have to give continuation
character.
A vague answer is:
' strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs "&vbcrlf&_
"WHERE rownum <11"
Savy.
On Dec 4, 8:12 am, [email protected] wrote:
> Hi,
> One more issue I am facing right now.
> I am trying to read a certain # or rows from DB but the script does not
> work. If I try to read everything, script works fine.
> Am I missing something?
> See script below. Any suggestion will be appreciated.
> Thank you.
> MZR
>
> Set objDB = CreateObject("ADODB.Connection")
> objDB.ConnectionString = "DSN"
> objDB.Open "DRIVER={Microsoft ODBC for
> Oracle};UID=XXXXXX;PWD=######;SERVER=tday1.world;"
> ' strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs WHERE rownum <
> 11" ' // This query does not execute
> strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs" ' // This works
> fine
> Set objResults = objDB.Execute(strQuery)
--
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
