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: ...
Using Microsoft SQL Server TSQL Language, a wide variety of things can be created under the title ‘stored procedure’. From eFORMz’s point-of-view, we are expecting a process that falls into one ...
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 ...