PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WEBDEV 2024 → Can Stored Procedures in HFCS access other databases in analysis like MySQL?
Can Stored Procedures in HFCS access other databases in analysis like MySQL?
Iniciado por Stephen Myers, dez., 15 2011 10:55 AM - Sem resposta
#1
Publicado em dezembro, 15 2011 - 10:55 AM
I have been trying to use a Stored Procedure in an effort to speed up process of parsing records from a MySQL database table (in the analysis) into a table in HF-Server. I've successfully used stored procedures before, but for some reason when I run this one it just returns with no error. It appears that it is never doing the read of a record from the MySQL database.

It finally dawned on me that it may be the stored procedure in HFCS can't access another database table in MySQL. IF this is the case, is their another way to access the MySQL in the Stored Procedure? I'm thinking I may have to explicitly make the connection to MySQL in code and do SQL queries rather than using WLanguage to read the MySQL. Before I spend the time coding that, I was hoping someone might know if this would even work.

Thanks!
Stephen
→ Voltar para WEBDEV 2024