diff options
| -rw-r--r-- | Source/TableSource.m | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/Source/TableSource.m b/Source/TableSource.m index 20a7ae11..cf7a7232 100644 --- a/Source/TableSource.m +++ b/Source/TableSource.m @@ -450,16 +450,30 @@ opens the indexSheet */ - (IBAction)openIndexSheet:(id)sender { - int code = 0; + int i, code = 0; // Check whether a save of the current field row is required. if ( ![self saveRowOnDeselect] ) return; + // Set sheet defaults - key type PRIMARY, key name PRIMARY and disabled, and blank indexed columns [indexTypeField selectItemAtIndex:0]; [indexNameField setEnabled:NO]; [indexNameField setStringValue:@"PRIMARY"]; [indexedColumnsField setStringValue:@""]; + [indexSheet makeFirstResponder:indexedColumnsField]; + + // Check to see whether a primary key already exists for the table, and if so select an INDEX instead + for (i = 0; i < [indexes count]; i++) { + if ([[[tableFields objectAtIndex:i] objectForKey:@"Key"] isEqualToString:@"PRI"]) { + [indexTypeField selectItemAtIndex:1]; + [indexNameField setEnabled:YES]; + [indexNameField setStringValue:@""]; + [indexSheet makeFirstResponder:indexNameField]; + break; + } + } + // Begin the sheet [NSApp beginSheet:indexSheet modalForWindow:tableWindow modalDelegate:self didEndSelector:nil contextInfo:nil]; |