FAQ's - APPX Software, Inc. : APPX Utility : APPX System Administration :
Storing NULL/blank values in SQL files
No, currently there is no way to control that behavior.
|
|
FAQ's - APPX Software, Inc. : APPX Utility : APPX System Administration :
Storing NULL/blank values in SQL files |
| We encountered an issue when using APPX SQL files, moving from version 4.0.9 to
4.2.6 of APPX. In 4.0.9, empty fields without data were blank. In 4.2.6, these
fields are NULL. This is causing problems with other applications that access the
shared SQL tables, whose logic is checking for IS NULL.
Is there a way to have blank fields retain a value of blank, rather than be NULL in SQL Files?
No, currently there is no way to control that behavior.
| |
| [Append to This Answer] | |
| 2005-Oct-12 9:29am |
| Previous: |
 Known issue with SQL Server SP4
|
| Next: |
A Handy list of RDBMS commands for various RDBMS's
|
| ||||||||