hi mzr, Instead of giving rownum could u plz give something other in where clause of the query and let us know the result.
On Sat, Dec 5, 2009 at 10:00 PM, <[email protected]> wrote: > 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]<mercuryqtp%[email protected]> > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > -- regd, mrinal -- 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
