SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Insert [Into] selecting column name

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Insert [Into] selecting column name
Author Message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Insert [Into] selecting column name Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
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 View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.