Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek on composite key will not find record
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01527452
Message ID:
01527454
Vues:
92
This message has been marked as the solution to the initial question of the thread.
The val1 has to be the same length as ut_name and so on
Try
SEEK PADR(val1, LEN(ut_name)) + PADR(val2, LEN(ut_code)) 
>
>I have a table witb a regular index (composite) made up of two fields namely ut_name+ut_code. The index name is UT_UNAMCOD. The fields are both of type character
>
>I use the seek as follows to find the record:
>
>use mytable shared in 0 order UNAMCOD
>
>select mytable
>seek val1 + val2
>
>When I put valid values in val1 and val2 it does not find the record. If I seek on a index made up of single value the record is found but not on a composite one.
>
>I have tried to set exact and set near in both on and off state and it makes no difference. This has worked in the past but not now.
>
>Any suggestions on the problem.
>
>Thanks in advance.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform