>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, you can copy that SQL statement, change it, and run in Command window like:

CREATE SQL VIEW myView AS ;
SELECT * from myTable ;
WHERE field1 = ?parameter1

Nick