Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange problem index on two strings
Message
 
 
To
13/06/2003 15:29:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00799975
Message ID:
00799980
Views:
22
>I have an interesting problem (at least I don't understand what's wrong) I have a table indexed on two (2) string fields. Indexed on “str1+str2”. However, when I attempt to seek on the index using the two strings it returns a .f.
>
>as in seek(mystr1+mystr2,”mytable”,”myindex”) returns false.
>
>If I check the fields in the table I find they match. I'm using the program to check the fields against the strings.
>
>?table.field1 == mystr1
>?table.field2 == mystr2

try this test instead:
? table.field1 + table.field2 == mystr1 + mystr2
this shouldn't really return anything different, but you never know.

>
>Both return true. Of course I place cursor on the correct record.
>
>Does anyone understand why this is not working? Is there something I don't understand about the index?????
>TIA
>
>John
censored.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform