PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV Mobile 2024 → [WM23] Stored Procedures on a server
[WM23] Stored Procedures on a server
Iniciado por ARV, dez., 13 2019 9:07 PM - Sem resposta
Membro registado
498 mensagems
Popularité : +8 (8 votes)
Publicado em dezembro, 13 2019 - 9:07 PM
Hi everyone,

I'm creating this thread because I want to know if it is possible to get access to another data base through a stored procedure on a server.

Here's the situation
I have two DB let's call it
DB1
DB2

on DB1 I have important tables of information to show to the user
on DB2 I have tables for managment connections to a lot of DBs

I want to create stored procedures for DB2 but those stored procedures need information of tables that only DB1 have.

I was hoping if there's any way possible to access the tables of DB1 through stored procedures of DB2.

Hope anyone know about a function or if I need to set something to make it work.
Thanks!

--
Best Regards
ARV