Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexseek(), Seek, Seek()
Message
From
18/09/2003 13:20:47
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
18/09/2003 12:50:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00830146
Message ID:
00830392
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform