Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to Filter SPT
Message
From
30/10/2008 20:26:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Need to Filter SPT
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01358528
Message ID:
01358528
Views:
70
Here is my SPT

testString = "Select webprddt6.resmngt3.recseq, task, hours2, SUM(ahours) As ah From webprddt6.resmngt2" +;
" Join webprddt6.resmngt3 On webprddt6.resmngt3.projindex = webprddt6.resmngt2.recseq" +;
" Join webprddt6.resmngt3b On webprddt6.resmngt3b.taskindex = webprddt6.resmngt3.recseq" +;
" Where status = 1 And projected = 0 And deptno = '660' Group By webprddt6.resmngt3.recseq, task, hours2"

Would like to show only records where ah is lesthan hours2.
Next
Reply
Map
View

Click here to load this message in the networking platform