Add the ability to navigate between tables via foreign key relationships, addressing the first part of #209:

 - For the first column linked by each foreign key, display a link arrow within the table cell
 - When clicking on the link arrow, select the reference table and set the table filters to select the clicked value
 - Also uses the table cell subclass to allow the entire cell to be editable, not just the contained text (addresses #250)

1 files changed, 4 insertions, 2 deletions

diff --git a/Source/TableContent.h b/Source/TableContent.h
index e2bc5730..3053db1b 100644
--- a/Source/TableContent.h
+++ b/Source/TableContent.h
@@ -28,7 +28,7 @@
 #import <Cocoa/Cocoa.h>
 #import <MCPKit_bundled/MCPKit_bundled.h>
 
-@class CMMCPConnection, CMMCPResult, CMCopyTable;
+@class CMMCPConnection, CMMCPResult, CMCopyTable, SPTextAndLinkCell;
 
 @interface TableContent : NSObject 
 {	
@@ -55,8 +55,9 @@
 	CMMCPConnection *mySQLConnection;
 	
 	NSString *selectedTable, *usedQuery;
-	NSMutableArray *fullResult, *filteredResult, *keys, *oldRow;
+	NSMutableArray *fullResult, *filteredResult, *dataColumns, *keys, *oldRow;
 	NSString *compareType, *lastField;
+	NSString *targetFilterColumn, *targetFilterValue;
 	NSNumber *sortCol;
 	BOOL isEditingRow, isEditingNewRow, isSavingRow, isDesc, setLimit;
 	NSUserDefaults *prefs;
@@ -87,6 +88,7 @@
 
 //additional methods
 - (void)setConnection:(CMMCPConnection *)theConnection;
+- (void)clickLinkArrow:(SPTextAndLinkCell *)theArrowCell;
 - (IBAction)setCompareTypes:(id)sender;
 - (IBAction)stepLimitRows:(id)sender;
 - (NSArray *)fetchResultAsArray:(CMMCPResult *)theResult;