>Hi,
>
>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

Did you requery the view.
requery("viewname")