>
> I have a problem, I need only one connection in all
> my application (it is very expensive to have an engine with
> more than 60 PC on line and more than 120 connections open). But, I need
> to use a numbered connection
> because I use stored procedures in MSSQLSERVER 6.5 (1 connection), and I
> use remote views (another
> connection). The views have the shared connections option set to .T..
> In the application I have first SQLCONNECT() and then a USE of sqlview.
> My question is: How can I do to get the sqlview to use the connection
> already open?
> Please help
> me,S.O.S.,S.O.S.,S.O.S.,S.O.S.,S.O.S.,S.O.S.,S.O.S.,S.O.S.,S.O.S.,S.O.S.,S.O
> .S.

Hi Claudio Abad
I suggest open u r view first and then get its connection no.

PUBLIC gnConnection
gnConnection = CURSORGETPROP('CONNECTHANDLE',your view name/alias)

In forms DE is loaded first, then u r remote view had established connection no
then in init of form get connection no and use in program.

Thank Q
Waheed