Hi Puri ---

Yes. Open the database and create the view in code.

OPEN DATABASE mydbc
CREATE VIEW myview AS ;
   SELECT * FROM mytable ORDER BY name

Use DBSETPROP("myview","VIEW",{property},{setting}) to modify view settings such as updateable, etc.



>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