Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexseek(), Seek, Seek()
Message
De
18/09/2003 13:20:47
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
18/09/2003 12:50:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00830146
Message ID:
00830392
Vues:
16
>Hi,
>Thank you for your help.
>
>My key is cName C(25)+cBrNum C(3)+cBrName C(20)
>
>Yes, all SEEK, SEEK() and INDEXSEEK() are failing.
>
>The value of lcTxtVal is "William 003Woodland Hills " 48 chars long.
>
>This is what is shown in the Watch window of the debugger.
>
>I don't understand why it doesn't find it? I know it does exist in the dbf, 100% sure (verified).
>
>Again, thanks for your help.

Reread what I'm saying. Your key would fail because it's checking for :
'William 003Woodland Hills' && Underscore serves as space

Try this instead :

lcTxt = padr('William',25)+padr('003',3)+'Woodland Hills'

* 'William                  003Woodland Hills'
PS: If I'm misinterpreting what you say and actually padding, then also consider casing. Your key should be something like upper(...). If so upper(lcTxtVal) too.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform