>>I am new to OOP for VFP 5.0, all of my programming experience has been in
>>top-down method.
>>
>>My problem is I would like to use the seek command to search on a very
>>large database. But the default one with the wizard uses locate and filter,
>>very slow :-(.
>>
>>The scenario is this, the user hardly ever knows the customer ID so they
>>must search on a combination of lastname and zipcode which would then give
>>them a browse box so they could determine if the customer exists, if it
>>does they would want to select it and return the main form with that
>>customer in edit mode. If the customer does not exist they want to be able
>>to return to the main form in add mode.
>>
>>Any help would be greatly appreciated and maybe if any of you do consulting
>>you would also let me know, Please email me directly if possible.
>>
>>Thanks for your time.
>>
>>==================================================================
>>Wayne Jordan
>
>Wayne, LOCATE is Rushmore optimized IF you have the necessary indexes. Do you have both LastName and ZipCode indexed? If so, the result should be as fast as a SEEK. Read the Help on LOCATE and check out the optimizing tips they refer to. This should get you up to speed
>
>I'll e-mail a copy of this as well as leaving it here...
>
>HTH
>Barbara
Furthermore, if you have SET DELE ON, then you should have an index on DELETED(), and when you perform a LOCATE turn your indexes off
i.e. SET ORDER TO 0