Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple index ASC / DESC
Message
From
15/05/2000 23:05:06
 
 
To
15/05/2000 16:48:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00369394
Message ID:
00369832
Views:
19
>INDEX ON STR(999999999 - Field1) + Field2 + Field3 TAG MyTag
>You'll need to adjust the STR function to handle decimals.

Yep, and if you ever want to decend part of a character field, this should do it (call this code form your index):
lparameters tcString
local lcString, lnI

lcString = ''
for lnI = 1 to len(alltrim(tcString))
	lcString = lcString + chr(255 - asc(substr(tcString, lnI)))
endfor 

return lcString
Previous
Reply
Map
View

Click here to load this message in the networking platform