xolo - you can get what you want if you want to use emacs ...

There is a emacs-lisp library available "sql.el" for the isql interface
which allows command line editing ...

bill

sibusiso xolo wrote:

>Paul Beach wrote:
>
>
>>Then, in ISQL you just type 'edit;' and the last command is loaded into
>>the editor. Do what you want with it and when you save and exit the
>>editor the buffer is passed the new string and it is executed by ISQL
>>
>>
>
>
>many thanks i tried with vi and it worked fine. And it is possible to cut and
>past with the mouse with vi, making table inserts even easier.
>
>On Saturday 31 August 2002 10:29, Paul Reeves wrote:
>
>
>>sibusiso xolo wrote:
>>
>>
>>>Question: Is there a switch to start isql so that the arrow keys are
>>>useful?
>>>
>>>
>>No - not in v1.0. This will change with v1.5
>>
>>
>>
>>>At the moment there is no line editing whatsoever each line has to
>>>be typed anew.
>>>
>>>
>>This is not true and has never been true.
>>
>>First, you need to set the $EDITOR variable for your environment - I
>>prefer pico, lots of people are happy with the system default (vi, I
>>think? Eurgh!).
>>
>>Then, in ISQL you just type 'edit;' and the last command is loaded into
>>the editor. Do what you want with it and when you save and exit the
>>editor the buffer is passed the new string and it is executed by ISQL.
>>
>>In many ways this is better than command line history as editing a
>>multi-line statement using the up/down arrow keys is pretty confusing.
>>
>>
>>Paul
>>
>>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>