>Hi.
>I have a simple form that I extracted the DE into a VCX.
>I have a grid on that form and I linked it to a remote view.
>When I open it, the data from the view is showing up, but whenever I try to save the modifications, I have a CONNECTION IS BUSY error !
>
>Does somebody have any ideas.
>
>André Deshaies
Hi André!
If you're creating your view with the View Designer, select the "Advanced Option" in the "Query" menu (while you're editing your view, of course). In the Data Fetching section, the first option is "Number of records to fetch at a time". Select "All".
If you're creating your view in code, use something such as:
DBSetProp('ViewName', 'View', 'FetchSize', -1)
HTH!
Sylvain Demers