Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting Records
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01440504
Message ID:
01440558
Views:
39
PRIVATE nIndex
nIndex=0

SELECT GetIndex() As recindex, *;
FROM customer;
WHERE postal_cde like 'J2K%';
HAVING empty(mod(recindex - 79, 7))

FUNCTION GetIndex() As Number
	nIndex=nIndex+1
RETURN nIndex 
This solution is probably less elegant, requires extra variable and function; but excludes RECNO() from the equation.
Previous
Reply
Map
View

Click here to load this message in the networking platform