>Hi,
>Except _tally OK but I hate to have different idea about _tally than other folks. _tally, to my arguable experience doesn't work correctly always and depends on some settings. ie: if collating sequence is not machine, executing an SQL returning many rows (reccount() returns correct number) you could get _tally = 0. To test it simply set collate to "TURKISH" (it hit me with that sequence), index some field and add some records, execute your SQL. _tally returns 0 whatever the actual match count is. Set collate to machine and _tally starts to return correct values.
>Cetin


Thanks for the warning. Their could be an entire NG devoted to Fox Gotcha's!