Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complex Index expression
Message
From
03/11/2008 13:26:30
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01359216
Message ID:
01359225
Views:
34
May I ask WHY you need such an index tag? If you have index tags on the relevant fields, a SQL Select statement is normally instant, and most likely gives you exactly what you really want.

>Hi,
>
>I'm trying to create an index with the balance in descending order (first by time, then by balance). I can not figure this out.
>
>I tried this expression, but it's not working and I don't see why
>
>index on IIF(cStatus='PAYMENT ARRANGEMENT BROKEN','0','1') + DTOS(TTOD(tScheduleTime)) + ;
>*PADL(99999999999999 - yBalance,14,'0') tag tSchedule FOR !DELETED()
>
>Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform