Link to home
Start Free TrialLog in
Avatar of CABRLU63
CABRLU63Flag for United States of America

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?
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Yes
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
Avatar of CABRLU63

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
ASKER CERTIFIED SOLUTION
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial