| If an Appx alpha field contains all blanks and the database field allows NULL values, then Appx stores a NULL value in the corresponding database field. If the database field does not allow NULL values, then Appx stores spaces in the database field. If you don't want Appx to store null values in he field, make sure that the database field has the NOT NULL attribute set.
You can use the field override option in the File Specifications to specify that null values are not allowed. Do this before running Create Files to create the table.
|
FAQ's - APPX Software, Inc. : 
Message: "Building Dynamic Index"