Data From an SQL Database Displaying as Scientific Notation

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 Where data is extracted to produce labels. Loftware Label Manager provides a variety of data sources, including the keyboard, a database, serial number, a formula, via the UCC or UPN Wizard. For RFID labels and tags, data can come from the Keyboard data source or by configuring data blocks using the Block Configuration 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.