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