I am giving query in one line and I don't see and records when I run the query. Note that if I run only strQuery = "Select * FROM loanmdtst1.clpac...@gtas08pcs, my script works fine.
On Fri, Dec 4, 2009 at 11:15 PM, savy <[email protected]> wrote: > 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]<mercuryqtp%[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 "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
