CABRLU63
asked on
SQL Server & WebFocus
Is it possible to use sql language into a webfocus .fex proceedure and obtain data from a sql server table?
ASKER
Thanks!
SET SQLENGINE = SQLMSS
SQL SQLMSS SET SERVER we put in server name ;
SQL SQLMSS EX we put in stored procedure;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HDATA
END
However, nothing returned
SET SQLENGINE = SQLMSS
SQL SQLMSS SET SERVER we put in server name ;
SQL SQLMSS EX we put in stored procedure;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HDATA
END
However, nothing returned
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You should package all your SQL in Stored procedures on MS SQL Server and then execute these stored procedures from WebFocus
Something like the following :
SET SQLENGINE = SQLMSS
SQL SQLMSS SET SERVER MyDataSource ;
SQL SQLMSS EX dbo.WF_GetData ;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HDATA
END