Applies To:
  • CitectSCADA 1.00 1.01 1.10 1.11 1.20 2.00 2.01
Summary:
If you have specified a dBASE device format where the field names are longer than 10 characters, Citect will not be able to open or create the dBASE DBF file. This is because the dBASE file format limits all field names to a maximum of 10 characters. For example the device format "{FLOUR}{WATER}{MILK}{FORMULANAME}" will be invalid for a dBASE device, because FORMULANAME is longer than 10 characters.

If the device is not a dBASE device then this restriction does not apply. If your devices work OK as ASCII_DEV, PRINTER_DEV, SQL_DEV but not dBASE_DEV then this may be the cause. Note also that the SQL_DEV will also have this restriction if the native file format for the SQL server is dBASE file format.

 

Solution:
The fix for this problem is to reduce the field names to 10 characters or less. In Version 2.01 Citect will automatically truncate the field names to 10 characters, to allow the creation of the dBASE file. However the Cicode functions DevSetField and DevGetField will not operate correctly as they don't truncate the field name.

In version 2.10 and later the DevSetField and the DevGetField functions will also truncate the field names to 10 characters allowing these functions to work correctly.
Keywords:
 

Attachments