>
> 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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement