selection set and @td

Barry Wiseman bwiseman at optonline.net
Thu Jan 17 09:25:03 PST 2008


dave kasper wrote:
> im trying to build a demand index with selection set of
> field eq @td  or field eq @t4 . my feild is (10,mdyy/) but doesnt work. 
> Im trying to bypass the sort selection scan of all records and just 
> build the index on the records needed to speed up the several reports 
> that need this data, but it never works i run this report everyday and 
> need it ti select just todays records only.  Any idea's? im on a unix 
> system and running v 5.6
> 

You need to say field EQF @td ("equal to field").  That should work with 
either @t4 or (assuming PFCMARK is set appropriately) @td.


More information about the Filepro-list mailing list