• BIT Field Sheet Editor now can handle NULL values

• Field Editor Sheet field name label also displays NOT NULL if set 

1 files changed, 5 insertions, 0 deletions

diff --git a/Source/SPCustomQuery.m b/Source/SPCustomQuery.m
index 2a805da2..ae1b01c0 100644
--- a/Source/SPCustomQuery.m
+++ b/Source/SPCustomQuery.m
@@ -2262,16 +2262,21 @@
 			NSString *fieldType = nil;
 			NSUInteger *fieldLength = 0;
 			NSString *fieldEncoding = nil;
+			BOOL allowNULL = YES;
+
 			// Retrieve the column defintion
 			fieldType = [columnDefinition objectForKey:@"type"];
 			if([columnDefinition objectForKey:@"char_length"])
 				fieldLength = [[columnDefinition objectForKey:@"char_length"] integerValue];
 			if([columnDefinition objectForKey:@"charset_name"] && ![[columnDefinition objectForKey:@"charset_name"] isEqualToString:@"binary"])
 				fieldEncoding = [columnDefinition objectForKey:@"charset_name"];
+			if([columnDefinition objectForKey:@"null"])
+				allowNULL = (![[columnDefinition objectForKey:@"null"] integerValue]);
 
 			[fieldEditor setTextMaxLength:fieldLength];
 			[fieldEditor setFieldType:(fieldType==nil) ? @"" : fieldType];
 			[fieldEditor setFieldEncoding:(fieldEncoding==nil) ? @"" : fieldEncoding];
+			[fieldEditor setAllowNULL:allowNULL];
 
 			id originalData = [resultData cellDataAtRow:rowIndex column:[[aTableColumn identifier] integerValue]];
 			if ([originalData isNSNull]) originalData = [prefs objectForKey:SPNullValue];