sc_change_connection Don't Work

Developers Databases
#1

I Try change connection on running app

sc_change_connection("Old", "new") ;

but, don’t work.

I Need some one command…?

#2

Re: sc_change_connection Don’t Work

Hello,

Please make sure that both connections are working properly.

regards,
Bernhard Bernsmann

#3

Hi Ramorales,
You can change the connection using sc_change_connection macro in scriptcase.

Assuming that your connections are working properly. Try something like this:

sc_change_connection("Old", "new") ;
sc_redir('destination');

Now all your applications are using the new connection. Example in Destination APP:

sc_lookup(ds, "sql command");

Please note when using sc_change_connection you need to redirect to another application to see the changes the first time.