Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COUNTon a computed field in SQL SELECT
Message
From
12/06/2001 16:20:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
COUNTon a computed field in SQL SELECT
Miscellaneous
Thread ID:
00518587
Message ID:
00518587
Views:
56
Is it possible to use the COUNT function in a SQL SELECT statement against a computed field?

ie:

sele str(auction,5,0)+lotno as auctoin from larglots group by auctoin having count(auctoin) >1 order by auctoin into cursor xxy

Or am I missing something in the syntax?
On a CLEAR day you can see forever.
Next
Reply
Map
View

Click here to load this message in the networking platform