Sorry but it fails as a singl line or concatinated in any form. I say that its the FOR clause. __Stephen >Stephen, > >Try: > >.createindex('v_accnt_buyers','index on upper(lname)+upper(fname) ' + ; >' for bal_due> 0 tag lname') > >HTH > >Rex > >>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
