title:Back-to-basics -- TCL Stack
issue:Multi-value Solutions - Dec 97
The TCL stack provided with Advanced Pick and D3 is a valuable addition to the Pick OS over the previous versions. Most of the Pick Licenses include a TCL stack with their OS. This commonly used the dot stack that followed the EDITOR syntax.
In AP and D3, the stack uses the Update Processes syntax, although the dot stack is still available.
A TCL stack allows a user working from TCL to keep track of any and all TCL commands they enter. This allows them to pull up a previous command and reprocess and/or modify it. This is handy when trying to create an ACCESS report. You can process the same SELECT statement over and over again without having to rewrite the whole SELECT statement. Once you have the report working the way you want it, you can copy it into a macro or into a program.
The commands for the TCL stack using the update process are the following:
<ctrl>b - move cursor up one line
<ctrl>n - moves cursor down one line
<ctrl>e - erase from the position of the cursor to the end of the line. If the cursor is at the beginning of the line, then deletes the entry from the stack.
<ctrl>g - go to end of the line
<ctrl>j - move one character to the right
<ctrl>k - move one character to the left
<ctrl>l - deletes one character to the left
<ctrl>o - deletes the word
<ctrl>r - toggle between insert and replace
<ctrl>t - move cursor to the beginning of the command
<ctrl>u - go to the next word
<ctrl>y - go to the previous word
<ctrl>x - exit or cancel any changes done to current command
<ctrl>a - Search from top to bottom
<ctrl>d - move to previous command in stack
<ctrl>f - moves to next command in stack
<ctrl>p - copies current command and move the copy to the top of the stack.
When making any changes to a command, the changed command overwrites the old command unless a copy was made using the <ctrl>p.