David,

I have the view code in a prg. I am not trying to edit it from view designer after it is created from the code. I dont know where to place () i.e brackets for AND and OR. I want your help with that.

Can you please help with that.

Thank You.


>Rick,
>
>Ah now the problem is clear. If the View designer can't create it correctly in the first place, how do you expect it to be able to edit it? *s*
>
>Once you've created a complex view with code, that's how you have to maintain changes to it. Just alter the code and rerun it, that will replace the view.
>
>>It does not give me an error. Instead, my view is created but the SQL statement is changed with brackets in inappropriate places.
>>It looks like this when I see the SQL from view designer's 'Veiw SQL' menu item.