 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Insert [Into] selecting column name |
|
Insert dbo.
Pops up table names, good. If you select a column name it drops it in. I think it should work like Select in that if you select a column name it expands to the following:
Insert dbo.Table (Column,
then changes to the column list with checkboxes allowing the arrow nav/select system you already have. Maybe throw in that ending paren for good measure...
|
|
Fri Jan 08, 2010 3:09 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
I assume you are running 4.8.x
Try this
INSERT INTO <pick table, but don't expand column names, press Enter key]
or this
INSERT INTO <pick table, but don't expand column names, press Shift+Enter key] after this type ( symbol, and viola, you now should have a list of columns with checkboxes.
|
|
Fri Jan 08, 2010 4:57 pm |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
Yes, those are good things and good behavior. But Insert still behaves differently from Select and Update in that you can expand the columns immediately and choose columns.
|
|
Fri Jan 08, 2010 5:53 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|