>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.
>
AFAIR there is a share option for connection in the create SQL remote view.
Using SPT you set it as 1. parameter.
I prefer to work with CA - there I set the connection in a base class