Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore, don't get it
Message
From
22/04/2005 04:03:49
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
22/04/2005 04:00:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01006860
Message ID:
01007386
Views:
14
>>Gregory,
>>Views:) This solution is similar to the one I sent to Fabio. There I also said I wouldn't use bintoc() alone to index a cursor. David also suggested not to do.
>>Whereever I have bintoc() it's a composite index, otherwise I prefer directly indexing on integer and never had a problem.
>>Cetin
>
>I have written I was assessing the conversion to int, and I will (I think)
>
>
>Still, such circumstances make one's trust shake a bit.
>This issue may be solved ( I do not know yet whether index on int has no problems, it has taken me 10 years to find one with bintoc())
>
>What about composite indexes like bintoc(a) + bintoc(b) where
inlist(0, mod(b,256), mod(b, 256^2), mod(b, 256^3)) && The X files ?
Couldn't understand:)
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
Next
Reply
Map
View

Click here to load this message in the networking platform