Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Function SEEK()
Message
 
 
To
18/01/2000 07:04:38
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00319354
Message ID:
00319367
Views:
15
>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."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform