Hi,
We recently migrate our LF servers to 10.3, including Forms.
We're currently changing our Forms lookups from SQL Server to SQL via ODBC since 10.3 allows this possibility.
We are able to connect to the tables and views of the Database we connected with ODBC but Forms does not seem to see the stored procedures, we do not have the choice in the forms lookups.
The user we use to connect to the database have the rights to Execute stored procedure.
First, does ODBC support Stored procedures lookup with the Forms ?
If yes, we were wondering if there is a specific configuration we have to do somewhere so that Forms are able to use Stored procedures with ODBC ?
Thanks !