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