Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In Sequel Pro we used a different (and in my eyes simpler) method: We implemented <code>control:textView:doCommandBySelector:</code> in the delegate of the TableView. This method is hard to find -- it can be found in the <strong>NSControlTextEditingDelegate Protocol Reference</strong>. (Remember that NSTableView is a subclass of NSControl)</p> <p>Long story short, here's what we came up with (we didn't override left/right arrow keys, as those are used to navigate within the cell. We use Tab to go left/right)</p> <p>Please note that this is just a snippet from the Sequel Pro source code, and does not work as is</p> <pre><code>- (BOOL)control:(NSControl *)control textView:(NSTextView *)textView doCommandBySelector:(SEL)command { NSUInteger row, column; row = [tableView editedRow]; column = [tableView editedColumn]; // Trap down arrow key if ( [textView methodForSelector:command] == [textView methodForSelector:@selector(moveDown:)] ) { NSUInteger newRow = row+1; if (newRow&gt;=numRows) return TRUE; //check if we're already at the end of the list if (column&gt;= numColumns) return TRUE; //the column count could change [tableContentView selectRowIndexes:[NSIndexSet indexSetWithIndex:newRow] byExtendingSelection:NO]; [tableContentView editColumn:column row:newRow withEvent:nil select:YES]; return TRUE; } // Trap up arrow key else if ( [textView methodForSelector:command] == [textView methodForSelector:@selector(moveUp:)] ) { if (row==0) return TRUE; //already at the beginning of the list NSUInteger newRow = row-1; if (newRow&gt;=numRows) return TRUE; if (column&gt;= numColumns) return TRUE; [tableContentView selectRowIndexes:[NSIndexSet indexSetWithIndex:newRow] byExtendingSelection:NO]; [tableContentView editColumn:column row:newRow withEvent:nil select:YES]; return TRUE; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POArrow keys with NSTableView
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJakob Egger
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis looks really powerful, but it would help a lot if you explained a bit better what you're doing / how. e.g. I tried this, and it never captures up/down arrow keys for me - although it does capture the user hitting Return on a cell, and editing that cell?
      singulars
      1. PO
      1. USAdam
    2. COThis only works while editing a cell. When you click into a cell of an NSTableView, the windows field editor is placed above the cell and you can edit the text. While you are editing text in the field editor, the above message is sent to delegate of the table view. The documentation for the delegate method we used is [here](http://developer.apple.com/library/mac/documentation/cocoa/reference/NSControlTextEditingDelegate_Protocol/Reference/Reference.html#//apple_ref/occ/intfm/NSControlTextEditingDelegate/control:textView:doCommandBySelector:).
      singulars
      1. PO
      1. USJakob Egger
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload