>Hi alls
>I have a simple table.
>It has three fields: Name, Last Name and DNI and three common index; one with name other with last name and one with name+last name.
>
>When I make the search for name, It´s Ok.
>When I make the search for last name. It´s Ok.
>
>... But when I choice the compound index (name+lastname) and make a search it doesn´t work.
>
>What could be happening..???
>
>I consider the spaces mades for the texbox, for it I use Alltrim().
If your index expression is allt(name)+allt(lastname) then your seek command should be:
SEEK(ALLT(varname)+ALLT(varlastname),'yourtablename','yourindextagname')
That should work.
HTH
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."