Skip to end of metadata
Go to start of metadata

Description

When using ODBC to retrieve data from a SQL Database, data is displayed as Scientific Notation.

Solution

  1. Re-open SQL table, instead of integers, use varchar.
  2. Delete and Recreate the ODBC link
    1. Start | Programs | Loftware Labeling | Data Sources.
    2. Highlight the Data Source, and click Remove.
    3. Click Add, select the SQL Driver, and point to the location of the updated SQL Table.
  3. Re-link label fields in Loftware Design Mode to the new ODBC by editing the Data Source for each of the fields in the label.

Article Number

2009199

Versions

All supported LPS family product versions.

Environment

Any supported LPS Family product environment