Can I populate values from an external database in a form in CFLOW?
Yes, you can. CFLOW lets you connect to any external database (Oracle, SQL Server, MySQL, PostgreSQL), execute a stored procedure and populate the return values to fields in your form. You can do all this without writing a single line of code.
Specify the connection properties to connect to the database of your choice. Ensure that you specify the parameters correctly and select the fields that need to be populated.

During runtime, when a value is entered in the triggering field and you move to the next field, the stored procedure is executed and the other fields are populated as configured.
Try it out and avoid duplicate data in multiple databases.
© Copyright 2016 Cavintek, Inc.