PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → 2 connection same time on different databases
2 connection same time on different databases
Iniciado por bbnicu, 08,may. 2015 13:49 - No hay respuesta
Publicado el 08,mayo 2015 - 13:49
Hello, i hope i can find some answer here, i have the following situation:

On my server i have 2 databases , depending on giving parametter i must insert data in database A or database B , but i cannot do it, it always inserts it in Database A
I tryed to make 2 connections but when i make the connection i must choose the table it doesn't allow me to put a table in 2 connections

I tryed to change the analysis bot same problem

i used the following codes for changing the analisys

HClose("*")

HCloseAnalysis()
HOpenAnalysis("D:\WINDEV......ana\WD Utilisation des sockets_1.wdd","V....")
HOpenConnection(Conect )
HChangeConnection("*",Conect)
HOpen("*")

I also tried :

HOpenConnection("MyConnection_01")
HChangeConnection("*.*","MyConnection_01")
HExecuteQuery(MyQuery,hQueryDefault)