Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Former Member Absent Member.
Absent Member.

[archive] NULL in MsSQL Fields (Acu4GL)?

[Migrated content. Thread originally posted on 17 August 2005]


i try to bring my vision-data into an MSSQL - Server.
Works pretty good so far, but:

All fields with only SPACE were transformed into . (and therefore our MsAccess databases have problems with the data)

I already tried the config entry: 4GL_ILLEGAL_DATA CONVERTED.
But it has no effect.
AcuSupport told me, that this entry has a bug and does not work correctly (what i can proof!).

The support guy has reached his knowlege-limit and all of his suggestion aren't working.

Has anyone here an idea?

The tables were created with "allow NULL" in some fields .. some other fields do not have these flag .. i can not find the rule behind this. Maybe someone here who knows how to control this flag?

I would be glad about any suggestion. Thanks.

p.s. i dont use sql syntax .. simply xfd's and the DEFAULT_HOST SQL entry.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.