Thanks for reply.
how to use singular connection for all views?

My form has three remote views but in MySQL, it costs seven connections.
the other form has four views, but takes 9 connections.

I wish to reduce those connections.



>>I'm using VFP with MySQL database.
>>and I figured out it that every (remote) view will cost MySQL one connection.
>>
>something totally different from your OP.
>Using a singular connection for all views on each backend is good practice.
>
>>That why I tried to convert some views to public variables in order to save the resources.
>
>views are cursors - moving the data into memvars is often counterproductive.
>If you need it, try to work via a pattern similar to ActiveRecord.
>I personally prefer scattering to a special .oData on a biz object or a CA in this case.
>
>HTH
>
>thomas