Database Lookup with Stored Procedure

Follow

Sim Poh Loon

• November 06, 2020 14:58

I want to use stored procedure to populate data in database lookup. How to bind the return results into TextBox in the eForm?

0

• 

  sysberry GmbH

  • November 16, 2020 22:02

  Hi Sim, you need to write a select statement with something like SELECT ExRate '' from (exec ...).
  Regards
  Alexey

  0

  Comment actions Permalink
• 

  Jean-Sébastien Renaud

  • November 16, 2020 22:18

  If you want to bind a textbox in your form with the result of your lookup, you can use a Auto-Lookup in your form.

  Your textbox internal name should have the same name as the field that your auto lookup returns.

  For example, in your case, the textbox name should be :  ExRate

  I'm using the same syntax as you (Exec Statement in the MANUAL tab of the lookop config) and it works.

  0

  Comment actions Permalink

Please sign in to leave a comment.