>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.
What others suggest is fine if simple, but if you have some non-default view properties such as setting update fields, a good way to do it is to use the view designer to approximate your view to the dbc, then run GENDBC, cut out all the view code, paste it to where you want it, and then edit the view settings as needed...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.