>>
>> 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

You are a genius, thanks you very much