Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I Use Conditions Within A View?
Message
From
17/06/2009 17:14:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can I Use Conditions Within A View?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01406759
Message ID:
01406759
Views:
91
I am using the following code in a VFP view to return customer information from a SQL server. This view includes references to SQL server stored procedures named getcustomerbalance and getcustomeramountdue. I'm trying to speed up this view and was wondering if I could make the call to getcustomeramountdue only if getcustomerbalance returns a value greater than zero. If so whats the best way to implement it?


SELECT Customer.customerid, ;
Customer.cCUSTNO, ;
Customer.dENTERED, ;
Customer.nCOBALANCE, ;
Customer.dBILL, ;
Customer.dLASTPMT, ;
Customer.cREP, ;
Customer.cLASTNAME, ;
Customer.cFIRSTNAME, ;
Customer.cTITLE, ;
Customer.cADDRESS, ;
Customer.cCITY, ;
Customer.cSTATE, ;
Customer.cZIP, ;
Customer.cPHONE, ;
Customer.cPHONE2, ;
Customer.cPHONE3, ;
Customer.cCONTACT, ;
Customer.mNOTES, ;
Customer.cTAXNO, ;
Customer.cIDNO, ;
Customer.cIDDESC, ;
Customer.dNEXTPMT, ;
Customer.nTAX, ;
Customer.lCharge_Off, ;
Customer.cfinanceno, ;
CAST((RTRIM(Customer.clastname)+', '+Customer.cfirstname) AS CHAR(68)) AS cfullname, ;
CAST((RTRIM(Customer.cfirstname)+' '+Customer.clastname) AS CHAR(68)) AS cprtname, ;
Dbo.getcustomerbalance(Customer.cfinanceno) AS qybalance, ;
Dbo.getcustomeramountdue(Customer.cfinanceno) AS qyamountdue, ;
Dbo.GetPmtsInvoiced(Customer.cfinanceno) AS nPmtsInvoiced;
FROM dbo.Customer Customer ;
ORDER BY 26

Thanks In Advance

Jeff
Next
Reply
Map
View

Click here to load this message in the networking platform