Hello,
It's as Mike said, i run another executable using the run command, the
main program is a menu who executes all the avaliable options by running
another exes.
But i'd like to disconnect the database from the main program while the
other exe is running and reconnect when it returns, so i can free that
connection and use less resources from the server because right now every
user needs two connections.
Thanks, best regards,
Ing. César Piñera García
GAFI Ferreléctrico S.A. de C.V.
Tel 747-4600 ext 103
-----Mensaje original-----
De: Fernando Ortiz [mailto:
fernando.ortiz@...]
Enviado el: miércoles, 30 de abril de 2008 01:29 p.m.
Para:
aubit4gl-discuss@...
Asunto: Re: [Aubit4gl-discuss] Working disconnected
Hola Cesar,
You can only be connected to one database at the time, so you must
connect to the 'correct' database everytime you change connection.
So you can connect to another database before calling myfunction() or
change database inside myfunction()
Note: database statement outside and main/end main, function/end
function is declartive for compilation only, so if you need to run
myfunction() always with anothe database you should put it twice
<code>
database otherdb # used at compile time for like's
function myfunction()
define ...
database otherdb # change connection at run-time
....
return
end function
</code>
Note2 : Aubit has the session extension so you can have 2 connections
active to different databases at the same time, does it help to you?
Saludos
César Piñera García escribió:
>
> Is it posible to work disconnected from a database?
>
>
>
> i want to do something like...
>
>
>
> database mydata
>
> main
>
> ...
>
> disconect
>
> call myfunction(params)
>
> database mydata #to connect again
>
> ...
>
> end main
>
>
>
> This is because myfunction is inside another .4gl file, so it uses
> another connection in the database.
>
>
>
> Thank you for your support.
>
>
>
>
>
>
>
> Ing. César Piñera García
>
> GAFI Ferreléctrico S.A. de C.V.
>
> Tel 747-4600 ext 103
>
>
>
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> ------------------------------------------------------------------------
>
> _______________________________________________
> Aubit4gl-discuss mailing list
>
Aubit4gl-discuss@...
>
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss>
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Aubit4gl-discuss mailing list
Aubit4gl-discuss@...
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone_______________________________________________
Aubit4gl-discuss mailing list
Aubit4gl-discuss@...
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
Some parts of this message have been removed.
Learn more about Nabble's security policy.
