Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
For Clause in Createindex()
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
For Clause in Createindex()
Miscellaneous
Thread ID:
00485415
Message ID:
00485415
Views:
38
I like to use conditional indexes for my customer maintenance form. I have a Financial app so clients that still owe me money vs all clients is important. I need to flip back and forth at will so I use the power of the index.

This code works in the command window:
index on upper(lname)+upper(fname) tag ilname

index on upper(lname)+upper(fname);
for bal_due> 0 tag lname

This is the code in the postinithook:
sele v_accnt_buyers
with this
.createindex('v_accnt_buyers','index on upper(lname)+upper(fname) tag ilname')
.createindex('v_accnt_buyers','index on upper(lname)+upper(fname);
for bal_due> 0 tag lname')
endwith

I always error on the second createindex line?

__Stephen
Next
Reply
Map
View

Click here to load this message in the networking platform