FAQ's - APPX Software, Inc.: Oracle-Store blanks, not NULL !

APPX Knowledge Base Support answers, product how-tos, and troubleshooting guidance

	FAQ's - APPX Software, Inc. : APPX Utility : APPX System Administration : Oracle-Store blanks, not NULL !
	How can one force blanks into null fields, when converting Appx to the Oracle Database?
	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.
	2004-Jan-05 4:26pm

Previous:	Message: "Building Dynamic Index"
Next:	Where is Java/Client cache?

	[Search]	[Appearance]
This is a Faq-O-Matic 2.719.