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