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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
