>We use a number of views and SQLPT and need to share the connection, I dont think there is any way to do that if we open the view using a connection string.
>
>Thanks
Mike,
The CONNSTRING clause can contain a character string with the necessary connection information or it can contain a numeric value designating the connection handle to use. This is available i VFP 8 and is documented in the Enhanced Classes, Commands, and Functions section.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao