Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug ? or am I missing something ?
Message
From
25/06/1998 13:01:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Bug ? or am I missing something ?
Miscellaneous
Thread ID:
00111621
Message ID:
00111621
Views:
65
Now, this would apply to whom that uses collate sequences.
Config.fpw :
codepage=1254 && Turkish windows
collate=TURKISH

-create a table
-index on a field
-enter some values to that indexed field ie: 5 records all "John Smith"
select * from mytable ;
  where myfield = "John Smith" &&Displays only one record
? _tally   && Prints 0
set collate to "MACHINE"
select * from mytable ;
  where myfield = "John Smith" &&Displays all
? _tally   && Prints 5
set collate to "TURKISH"
* Same as above _tally = 0
So what could I be missing ????
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
Next
Reply
Map
View

Click here to load this message in the networking platform