Activity overview
Latest activity by jamiet
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 / comments
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 whol...
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 / comments
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...
Thanks guys!!! / comments
Thanks guys!!!
Column list in INSERT statement
Can SQL Prompt build the column list for me after I type:
"INSERT INTO MyTable ("
???
If it can, I haven't found how to do it. If it can't, consider that a feature request!
-Jamie
Thanks Tilman.
So then, if that is true, my question in the first post of this thread is valid, is it not? / comments
Thanks Tilman.
So then, if that is true, my question in the first post of this thread is valid, is it not?
Ignore this.... using aliases for DELETE isn't valid syntax!
Sorry :oops:
[Shame you can't delete posts on here [image] ] / comments
Ignore this.... using aliases for DELETE isn't valid syntax!
Sorry :oops:
[Shame you can't delete posts on here ]
Alias doesn't seem to work for DELETEs
Hi,
When I type the period at the end of this code snippet
"SELECT * FROM mytable t WHERE t."
then I am presented with the candidate list showing all columns in mytable. All good.
When I type:
"DEL...
UPDATE...SET...FROM
I've looked within the options panel for a way of exporting snippets but I can't find a way. So I might as well just post it up here in freetext:
Snippet: usf
Description: UPDATE...SET...FROM
Categ...