>This is an extract from the VFP Help:
>"RECNO( ) issued without the optional arguments nWorkArea or cTableAlias returns the current record number for the table in the currently selected work area.
>If you have issued SEEK unsuccessfully in an indexed table, you can specify 0 for nWorkArea to use “soft seek” logic to return the record number of the closest matching record. RECNO(0) returns 0 if a close match cannot be found. Visual FoxPro generates an error message if you issue GO RECNO(0) when a close match isn’t found."
>
>My question is how do I bypass GO RECNO(0) without generating an error.If I try to LOCATE FOR records that are not in the table , the error message is generated.
>Any Suggestions?
>Thank You All
>Zaraq Bari
Look at the SET NEAR command.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer