Q3291 When using SQLGetField(), the LONG data type -2,147,483,648 is being displayed as -214,748,364

ArticleID: Q3291
Created: 22/05/2001
Last Updated: 23/11/2007
Suggested By: Daniel Sun

Applies To:

CitectSCADA 5.xx, 5.31

---

Summary:

The SQLGetField() function truncates fields of 'LONG' data types. When using the SQLGetField() function, the values in 'LONG' data type fields are truncated to a string of length 10 if the values are -1,000,000,000 or below.

Solution:

CIT has confirmed this to be a problem in Citect for Windows versions up to 5.31. This problem has been fixed in version 5.40.

---

Keywords: