The following are some guidelines for configuring database connections in eFORMz: • Plan for switching between development and production. • Define databases using Databases.xml. Defning ...
When returning a large number of columns from an SQL call, you can create placeholder names for all the columns in just a few quick steps. Every column gets a name and the name is spelled ...
SQL Update will return a single record from an SQL database. For returning arrays, use SQL Load. How to implement To implement a database SQL update within the eFORMz Composer 1. From the Project ...
Problem: When using a stored procedure to get data from MySQL data source in eFORMz, eFORMz returns the error, “Statement did not return a result set” But you see a result set ...
The purpose of an SQL Lookup is to return additional data to an eFORMz project based upon a value in a data file. Normally this value is an indexed item to a table in a database. Step One: ...
SQL Load is an eFORMz procedure to load one or more rows of data from one or more columns of a relational database. Use the eFORMz function Table Lookup to load a single value from a row of a ...
You can call stored procedures using an eFORMz database connection. First, you configure the database connection, then create a variable to pass to the stored procedure, and then create a ...
Table lookup is a simple way to get one value from a row of a relational database. If you require multiple values, use SQL Lookup. In this scenario, you have invoices that eFORMz makes into PDF ...
You can call built-in and user-defined functions (UDFs) through an eFORMz database connection. First, you configure the database connection, then create a variable to pass to the function as a ...
Example of configuring a database in eFORMz Troubleshooting information is at https://www.minisoft.com/support/index.php/troubleshooting-a-database-connection/. DB2 (iSeries) Database name: ...