>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
If you are not receiving an error, say, 'Index tag not found', then try to check the length of the name and compare it to the length of the clocvariable.
Include this on the syntax valid event of the textbox control:
SELECT table1
nLength = FSIZE('fieldname')
cLocVariable = STR(Thisform.TextBoxName.Value,nLength,0)
=SEEK(cLockVariable,'Table1','FieldnameTag')
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."