FYI: Noselect in Query ->SQL Select

291 views

Skip to first unread message

Spencer Simpson

unread,

Jul 30, 2008, 12:41:17 PM7/30/08

to mapi...@googlegroups.com

This actually works! Well, sort of.

I've discovered that if you type

<seltablename> Noselect

into the field labeled with "Into table named:" while filling in the SQL select dialog, the query will actually be made (as long as seltablename isn't already open), and the current selection won't be affected.

The only problem occurs if you check the "Browse Results" checkbox. Instead of checking what you typed into the dialog, SQL Select checks the current selection (probably via SelectionInfo() or some internal equivalent). If there's no selection, you'll get a spurious No records were selected message box and no browser. You'll have to open a browser window manually. If there is a selection, it browses the seltablename you typed in.