Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtering count without cursor
Message
From
05/02/2009 09:56:30
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01379421
Message ID:
01379472
Views:
17
I agree with the the _tally elimination, but if I (or other) will create accidently other 'TempCount' cursor?
>I added shared and particular alias in the use command and eliminated _tally since you can count to a variable.
>
>That's it.
>
>>?
>>>>Excellent!
>>>>Can you take a look on the following?
>>>>
ccount=getfiltercount("mytable", "between(id,521548,529785)")
>>>>thisform.txt1.value=ccount
>>>>
>>>>function getfiltercount(tctable, tcfiltercondition)
>>>>	local lnselect, lncount
>>>>	lnselect = select() && Save current work alias!
>>>>	select 0
>>>>	use (tctable) again alias TempCount shared
>>>>	count for &tcfiltercondition to lnCount
>>>>	use
>>>>	select(lnselect)
>>>>	return (transform(lncount))
>>>>endfunc
>>>>
>>>>
>>>>
>>>>
>>>
>>>See two minor fixes inside.
Thank you
Chaim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform