>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