If I give other things in where clause (for example, where ACCT_NBR = xxxxxx) script works fine.
On Sat, Dec 5, 2009 at 11:48 AM, Mrinal <[email protected]> wrote: > 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]<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
