Hi Quinn,
>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.
Have you tried using the SEEK() function? It returns .T. if the seek works, .F. if it doesn't. It just saves you from having to do a FOUND() after the SEEK. But back to your question. Is the index expression locclient? The index expression has to match what you're seeking.
Have you tried doing a seek on ALLTRIM(locclient)?
Regrards,
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development