Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complex index is this possible?
Message
From
11/06/2013 08:00:57
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01575993
Message ID:
01576006
Views:
54
>>index on dupkey+codex + Cast(2^31-1- Cast(strtran(COPYNO, chrtran(COPYNO, '0123456789', '')) AS I) AS M) DESCENDING TAG docky
>
>Thanks I will try it

update


index on dupkey+codex + Padr(Cast(2^31-1- Cast(strtran(COPYNO, chrtran(COPYNO, '0123456789', '')) AS I) AS M), 10) DESCENDING TAG docky
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/
Never explain, never complain (Queen Elizabeth II)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform