Hi Nathaniel,

You don't need to set any properties with DBSETPROP. Simply create your views, and drop then in the dataenvironment.

Usually, views are designed to retrieve small result sets so they are parameterized and NoDataOnLoad property is set to True. When users enter parameters the view is requeried using REQUERY('ViewName')

>I created a view with SQL. I didn't specify any properties with DBSETPROP and think this might be my problem, but read on. I filled out the control source for each column in the grid and I also used set to double check the view and make sure that it had the right info.
>I also double checked where I requeried and this seems to be ok also.
>My problem is, that even though the view appears to be correct and the control source of the grid is correct nothing shows up in the grid once I specify controls source for the columns. Can anyone tell me what properties I need to set with DBSETPROP for the view?
>
>Let me know,
>
>-Nathaniel