Column list in INSERT statement

• 
  Hi,
  
  Thanks for posting. I'm getting the columns at that point, although the CL doesn't pop up automatically, I have to press Ctrl + Shift to get it. Is that what's happening for you? If not, could you tell me what version of SQL Prompt and what editor you are using? And if possible the exact script?
  
  Regards,
  
  Tilman

  Tilman January 31, 2007 10:58

  - 0 +
• 
  Hi Tilman,
  Yeah, I experience the same (except I have it configured to use the default CTRL-spacebar).
  
  What I would like though is to automatically populate the column-list with every column in the table. Similar to how typing "SELECT *" followed by a tab creates the whole column-list.
  
  Does that make sense?
  
  Regards
  Jamie

  jamiet January 31, 2007 11:26

  - 0 +
• 
  Hi Jamie,

  except I have it configured to use the default CTRL-spacebar

  Whoops, my bad, I meant Ctrl + Space. It's currently not possible to configure that command.
  

  What I would like though is to automatically populate the column-list with every column in the table. Similar to how typing "SELECT *" followed by a tab creates the whole column-list.

  Sorry, misunderstanding on my part. You can't expand the wildcard there, I'm afraid, but you can use the column picker, which is almost as quick. Please see the help on how to use the column picker (SQL Prompt>Help>Working with SQL Prompt>Using the Candidate List>Selecting candidates using the column picker).
  
  Regards,
  
  Tilman

  Tilman February 01, 2007 04:04

  - 0 +
• 

  Tilman wrote:

  Hi Jamie,
  

  What I would like though is to automatically populate the column-list with every column in the table. Similar to how typing "SELECT *" followed by a tab creates the whole column-list.

  Sorry, misunderstanding on my part. You can't expand the wildcard there, I'm afraid, but you can use the column picker, which is almost as quick. Please see the help on how to use the column picker (SQL Prompt>Help>Working with SQL Prompt>Using the Candidate List>Selecting candidates using the column picker).
  
  Regards,
  
  Tilman

  
  Good stuff, thanks Tilman.
  
  Consider that a feature request then.
  
  -Jamie

  jamiet February 01, 2007 09:56

  - 0 +
• 

  Consider that a feature request then.

  Duely noted
  
  Regards,
  
  Tilman

  Tilman February 01, 2007 11:10

  - 0 +

Add comment

Please sign in to leave a comment.