>Hi,
>
>Im using the seek command to seek a client name in a very large database with 1.7 m records. i have set the order to name2 which is the clients surname and then using the command SEEK locclient. locclient is a varible and the value is gotten from a textbox. I have tried several different syntax's but nothing will find the record. i am working in VFP 3.0 and i have tried go top.
>
>Please help
>
>thanks
>~Quinn
Although this may seem like a basic question, do you have an index tag on this field?
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!