Month: April 2009

Windows Keyboard Short Cuts – ALT F4 is my Favorite

Windows key + R = Run command box
Windows key + E = Windows Explorer
ALT + Tab = Switch between windows
ALT + Space + X = Maximize window
CTRL + Shift + Esc = Task Manager
Windows key + Break = System properties
Windows key + F = Search
Windows key + D = Hide/Display all windows
CTRL + C = copy
CTRL + X = cut
CTRL + V = paste
Alt + Esc = Switch between running applications(mnimized apps on task bar)
Alt + Underlined letter will Select menu item by underlined letter
Ctrl + Esc Open Start Menu
Ctrl + F4 or Alt + F4 Close active document or group windows (does not work with some applications)
Ctrl + Left and right arrow Move cursor forward or back one word
Ctrl + Up, Down arrow Move cursor forward or back one paragraph
F1 Open Help for active application
Windows + M = Minimize all open windows
Shift + Windows + M = Undo minimize all open windows
Windows + F1 = Open Windows Help
Windows + Tab = Cycle through the Taskbar buttons (In vista invokes 3d-flip)
Windows + Break = Open the System Properties dialog box
SHIFT+DELETE = Deletes selected item permanently without sending to recycle bin.
CTRL+SHIFT while dragging an item will create a shortcut of it.
F2 = Rename selected item.
CTRL+A = Select All items
F3 = Search for a file or folder
ALT+ ENTER = Show the properties of the selected file/folder.
ALT+SPACEBAR = Opens the shortcut menu of Active window.
F4 in Windows Explorer or Internet Explorer will show the addressbar list.
CTRL+TAB = Move forward through tabs.
CTRL+SHIFT+TAB = Move backward through tabs.
TAB = Move forward through options
SHIFT+TAB = Move backward through options
Windows key+M = Minimizes all window
Windows key+U = Opens Utility manager
CTRL+RIGHT ARROW = Move the insertion point to the beginning of the next word.
CTRL+LEFT ARROW = Move the insertion point to the beginning of the previous word.
CTRL+DOWN ARROW = Move the insertion point to the beginning of the next paragraph.
CTRL+UP ARROW= Move the insertion point to the beginning of the previous paragraph.
CTRL+SHIFT with any of the arrow keys = Will highlight a bloack of text.
SHIFT+ Any arrow key = Will select more than one item.

Some shortcuts for Windows Accessibility features:

Hold Right Shft key for 8 seconds to Invoke Filter keys settings window.
Tap on Shift key for 5 times will invoke Sticky keys settings window.
Left ALT +left SHIFT +PRINT SCREEN……. Switch High Contrast on and off.
Left ALT +left SHIFT +NUM LOCK……. Switch MouseKeys on and off.
Hold NUM LOCK key for five seconds will Switch ToggleKeys on and off.

Some shortcuts for FIREFOX Accessibility features:

CONTROL + CLICK on LINK ……OPENS a NEW TAB


SELECT_SQL Examples

SELECT_SQL FIELDS((#W_COUNT ‘count(*)’)) FROM_FILES((REQUEST )) WH
           ERE(‘CLIENT_ID = :RITAID AND STATUS_CODE = 4    AND  BA
           TCH_SEQ_NUM = 0’)                                      
ENDSELECT                                                         
SELECT_SQL FIELDS((#CRGUID ) (#CRTED ) (#CROBATCH ) (#CRBATCH ) (# 
           CRCCNO ) (#CREXPDT ) (#CRAMNT ) (#CRSWIPE ) (#CRQOVR )  
           (#CRRITAS ) (#CRRITAID ) (#CRTCN ) (#CRMUSR ) (#CRCCET  
           ) (#CRORIG ) (#CRFAIR )) FROM_FILES((CRTRAN )) WHERE(‘S 
           UBSTR(CROBATCH,1,2) = :XBFRGN AND CRSWIPE <> :WSWIPE AN 
           D (CRRITAS = 5 OR (CRRITAS = 200 AND CRAMNT < 0))’) ORD 
           ER_BY(‘CROBATCH,CRBATCH’)                               
********** OK to Mark for Completion                               
SELECT_SQL FIELDS((#W_COUNT ‘count(*)’) (#W_SUM ‘SUM(INT(TRANS_AMO
           UNT))’)) FROM_FILES((REQUEST )) WHERE(‘CLIENT_ID = :RIT
           AID AND STATUS_CODE = 4    AND  BATCH_SEQ_NUM = 0 AND C
           OMMAND =:COMMND’) IO_STATUS(#W_IOSTS) IO_ERROR(*NEXT)  
ENDSELECT                                                         
********** put decimal place in amount                            

SUBROUTINE NAME(GETRITASTS)                                       
**********                                                        
SELECT_SQL FIELDS((#INTRN0001 ‘INTRN_SEQ_NUM’) (#STATU0001 STATU00
           001)) FROM_FILES((REQUEST )) WHERE(‘ORIG_SEQ_NUM = :WRT
           AID’) ORDER_BY(STATU00001) IO_ERROR(*NEXT)             
LEAVE                                                             
ENDSELECT                                                         
**********                                                        
IF_NULL    FIELD(#INTRN0001)                                      
SELECT_SQL FIELDS((#INTRN0001 ‘INTRN_SEQ_NUM’) (#STATU0001 STATU00
           001)) FROM_FILES((REQUEST )) WHERE(‘INTRN_SEQ_NUM= :WRT
           AID’) ORDER_BY(STATU00001) IO_ERROR(*NEXT)             
LEAVE                                                             
ENDSELECT                                                         

SELECT_SQL FIELDS((#W_COUNT ‘count(*)’)) FROM_FILES((REQUEST )) WH
           ERE(‘CLIENT_ID = :WRITAI AND STATUS_CODE = :WRITAS  AND
             BATCH_SEQ_NUM = 0’)                                 
ENDSELECT