TechNote

Column names in a database used for supplying form object values should not differ by case only

Issue

Form objects that have the same name but different capitalization, and are bound to a database, display the same value when the form is previewed or saved as PDF.

Example:

The database contains the following entries:

test	tESt	TesT
red	blue	green

When this database is used as a source of form objects, it creates 3 objects on the form: test, tESt, and TesT. However, when you are previewing the form or saving it as PDF, all three objects display green as their value.

Reason

The LiveCycle Designer ES plug-in uses the Microsoft ADO API to provide database access capabilities. The ADO Connection object does not have the capabilities to recognize case sensitivity settings of the database provider. This object is case-insensitive.

Solution

When creating a database that will be used as a source of objects and their values in the form design, make sure that the names that are used for column identifiers are unique and do not vary by case only.