Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why reccount() and _tally are different ?
Message
From
06/05/1998 16:42:49
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Why reccount() and _tally are different ?
Miscellaneous
Thread ID:
00097511
Message ID:
00097511
Views:
81
Is there an explanation why RECCOUNT() doesn't return the right value in the following code ?
create table t1 (f1 C(1))
insert into t1 (f1) VALUES ("A")

create table t2 (f1 C(1))
insert into t2 (f1) VALUES ("B")
index on f1 tag f1

select "t1"
scan
	SELECT * FROM t2 WHERE f1 = t1.f1 INTO CURSOR tmp
	? reccount()  && display 1
	? _tally      && display 0
endscan
RECCOUNT() returns 1 while it is supposed to return 0. This problem occurs only if you create an index on f1 in table t2. Without the index, it returns 0.

Thanks.
François Guay
EMail: fraguay@videotron.ca
Next
Reply
Map
View

Click here to load this message in the networking platform