Well, if you have a question. 1. Open http://groups.google.com/group/MercuryQTP/post
or from menu: Discussions <http://groups.google.com/group/MercuryQTP/topics?start=> *+ new post * 2. write Subject 3. write Message 4. Post message Thanks, Moderator On Wed, Jun 24, 2009 at 2:42 PM, Kamran <[email protected]> wrote: > Hi , > I know its not related to "Action vs Function" but I thought you guys have > any solution that's why I replied . > > Thanks, > MK > > > On Wed, Jun 24, 2009 at 2:39 PM, Roman <[email protected]> wrote: > >> >> Kamran, >> >> How does your question related to topic "Action vs Function..."? >> And also, thank you for sending invitation to chat to 1711 members of >> this group. >> >> Moderator >> >> >> On Jun 24, 2:27 pm, Kamran <[email protected]> wrote: >> > Hi Guys, >> > I need help to execute SQL query in QTP , here is the scenario that I >> have >> > several SQL queries in some of them trying to get data from view but >> these >> > queries not runing in QTP, Other queries which dont have view are runing >> > fine please help me ASAP . >> > >> > *SQL query with view* >> > >> > SELECT DISTINCT >> > max(ir.RoundDate), >> > p.Name , >> > bd.BusinessDesc >> > FROM >> > PortfolioCompanyFinancials pf, >> > PortfolioCompanyView p, >> > Disbursement d, >> > PortfolioCompanyBusinessDesc bd, >> > InvestmentRound ir, >> > *FirmView* firm, *(View)* >> > Fund fund >> > WHERE >> > p.PortfolioCompanyID = pf.PortfolioCompanyID >> > and d.RoundId=ir.RoundID >> > and bd.PortfolioCompanyID=p.PortfolioCompanyID >> > and ir.PortfolioCompanyID=p.PortfolioCompanyID >> > and firm.FirmID = fund.FirmID >> > and fund.FundID = d.PEInvestorID >> > and pf.CurrentRatio between 1 and 2 >> > and pf.IsLatest = 'Y' >> > and firm.NationCode = 'US' >> > and fund.FundraisingStatusCode in ('F' , 'Z') >> > GROUP BY p.Name, bd.BusinessDesc >> > ORDER BY p.Name >> > >> > *SQl query with out view working fine* >> > >> > USE PrivateEquity >> > GO >> > SELECT DISTINCT >> > max(ir.RoundDate) as LastInvestmentReceived, >> > p.Name as CompanyName, >> > bd.BusinessDesc as BusinessDescription >> > FROM >> > PortfolioCompanyView p, >> > PortfolioCompanyFinancialsCurrencyFields pf, >> > PortfolioCompanyBusinessDesc bd, >> > InvestmentRound ir >> > WHERE >> > pf.PortfolioCompanyID = p.PortfolioCompanyID >> > and ir.PortfolioCompanyID=p.PortfolioCompanyID >> > and bd.PortfolioCompanyID=p.PortfolioCompanyID >> > and pf.CurrencyCode = 'USD' >> > and pf.NetSales between 20000000 and 100000000 >> > and pf.ProfitMargin between 1 and 10 >> > and pf.IsLatest = 'Y' >> > GROUP BY p.Name, bd.BusinessDesc >> > >> > I would really appreicate >> > >> > >> > >> > On Wed, Jun 24, 2009 at 10:04 AM, Roman Zilber <[email protected]> >> wrote: >> > > Hi, >> > >> > > Function: >> > >> > > Easier to maintain 15 functions, than 15 actions : >> > > You can choose nice location (ex. folder named lib/) >> > > You can split functions to number of vbs files with meaningful name >> > > example: >> > > App_Login(name, password) >> > > App_Logout() >> > > App_LoginTest(name) >> > >> > > in file APP_Login.vbs >> > > Easy to maintain source control, only text files need to be saved >> (have to >> > > be unicode format) >> > > Easier to manage code (diff between text files, and diff between >> Action >> > > folders) >> > > Easier to share code between projects >> > > QTP doesn't create extra runtime datasheet each time you call a >> function >> > > (it make me crazy when I work with Actions) >> > > You can open many functions at the time >> > > ... >> > >> > > Actions: >> > >> > > Build in connection to Data table (in function you need to specify >> data >> > > table name) >> > > You can record directly in Action (can't in functions) >> > > Big minus - you don't see Actions name, if a Test with the actions is >> not >> > > open. >> > >> > > Roman >> > >> > > Clear interface - you see function name and function parameters >> > >> > > On Wed, Jun 24, 2009 at 4:47 AM, johnthenu <[email protected]> >> wrote: >> > >> > >> Hi, I have a customer form filling script with 15 pages......i am >> > >> using DP for all the objects....except for page name and browser >> > >> name...... >> > >> > >> Each customer will see different combination of pages depending on >> > >> requirement which will be defined from the drive script..... >> > >> > >> In this scenario should i make each of the page a action or a >> > >> function....and what are the benefits making them as a function as >> > >> apposed to action.... >> > >> > >> Many Thanks.... >> > >> > -- >> > Regards, >> > Kamran >> >> > > > -- > Regards, > Kamran > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
