>Hi,
> I don't really know whether there is a way of doing this, I want to create a view without using the View Wizard with an SQL statement that I type. From the view wizard, I can see the equivalent SQL statement, but I couldn't edit it. Is there any way of doing this?
>And this view may have parameters and it will be included in DE of a form. I basically want to avoid writing SQL queries(the cursors) in the code and want to keep them in a view.
>
>Please help.
>
>Thanks
>Puri
Puri,
Copy that SQL and in command window try :

create sql view myview ;
as select ....
* select .. part is what you copied

Cetin