Toad World® Forums

Get 'select * from' when you type just select


#1

Message from: kashif

I’m looking for something similar to what we can set in M.S Word. I would
like my toad 9.5 to get 'select * from ’ whenever I type just
‘select’.

Please help me in setting this shortcut.


Historical Messages

Author: M Kashif
Date: Thu Feb 10 23:20:05 PST 2011
I’m looking for something similar to what we can set in M.S Word. I would
like my toad 9.5 to get 'select * from ’ whenever I type just
‘select’.

Please help me in setting this shortcut.

__



#2

Morning Kashif,

I’m looking for something similar to what we can set in M.S
Word. I would like my toad 9.5 to get 'select * from ’
whenever I type just ‘select’.

Please help me in setting this shortcut.

View->Toad Options.
Editor/behaviour
Click Code Templates button.

Click ADD button.

Set shortcut name = sel
Set Description = Anything you like.
Click OK.

In the middle pane of the main dialoge, enter the text:

select * from |

Note the pipe character, this is where the carat will be placed when you
execute this macro.

Click ok until you are back in the editor.

Type in sel and press CTRL+SPACE. Sel will be replaced by "select * from
" and the cursor is waiting for you at the end, to type in the
tablename.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#3

Message from: kashif

Thanx


Historical Messages

Author: M Kashif
Date: Sun Feb 13 05:02:56 PST 2011
Thanx

__

Author: Norman Dunbar
Date: Fri Feb 11 00:59:36 PST 2011
Morning Kashif, >> I’m looking for something similar to what we can set in M.S

Word. I would like my toad 9.5 to get 'select * from ’ >> whenever I type
just ‘select’. >> >> Please help me in setting this shortcut. View->Toad
Options. Editor/behaviour Click Code Templates button. Click ADD button. Set
shortcut name = sel Set Description = Anything you like. Click OK. In the middle
pane of the main dialoge, enter the text: select * from | Note the pipe
character, this is where the carat will be placed when you execute this macro.
Click ok until you are back in the editor. Type in sel and press CTRL+SPACE. Sel
will be replaced by "select * from " and the cursor is waiting for you at the
end, to type in the tablename. Cheers, Norm. [TeamT] Information in this message
may be confidential and may be legally privileged. If you have received this
message by mistake, please notify the sender immediately, delete it and do not
copy it to anyone else. We have checked this email and its attachments for
viruses. But you should still check any attachment before opening it. We may
have to make this message and any reply to it public if asked to under the
Freedom of Information Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any Environment Agency address may also
be accessed by someone other than the sender or recipient, for business
purposes. If we have sent you information and you wish to use it please read our
terms and conditions which you can get by calling us on 08708 506 506. Find out
more about the Environment Agency at www.environment-agency.gov.uk
__

Author: M Kashif
Date: Thu Feb 10 23:20:05 PST 2011
Message from: kashif I’m looking for something similar to what we can set in
M.S Word. I would like my toad 9.5 to get 'select * from ’ whenever I
type just ‘select’. Please help me in setting this shortcut.
_______________________________________ Historical Messages Author: M Kashif
Date: Thu Feb 10 23:20:05 PST 2011 I’m looking for something similar to what
we can set in M.S Word. I would like my toad 9.5 to get 'select * from ’
whenever I type just ‘select’. Please help me in setting this shortcut.


__



#4

Thanx