[h-e-w] Would like to use vers 21.2 but ...

[Patrick Flaherty]

Just downloaded it and installed to try again what I've tried (unsuccessfully)

with the last several versions.  And it still doesn't work.

In 20.3.6.1 (which I still use) I can do the following in telnet mode:

SQL> select * from dailyvalues

cont> where portname='PATSY'

cont> LIMIT TO 10 ROW;

    PERFDATE   PORTNAME   PERFDATE_ID   SUMMARY       COUNTRY   ISO                  PORTVALUE               EQUITYVALUE                      CASH                 DIVIDENDS                DIVIDENDS_                  INTEREST                    INCOME

                   EXPENSE                INCOME_UNR               EXPENSE_UNR                PERF_FUDGE                   BUYCOST            TRANSFER_VALUE                   SELLNET                  SELLNET2                COMMTAXBUY  

                  COMMTAXSELL              WITHINDAYBUY             WITHINDAYBUY2             WITHINDAYSELL            WITHINDAYSELL2             CONTRIBUTIONS               WITHDRAWALS                 CASHTRANS                  BHEDGEGL  

              SHARE_POOLFUND_EXP        SHARE_POOLFUND_INC     INTERPORT_TRANSFER_IN    INTERPORT_TRANSFER_OUT     EVAL_ADJUST_CARRYOVER                    MGTFEE  

I didn't hit RETURN after each line of the sql - I used arrow-down.  And

then when I submitted the whole thing, the 'cont>''s were added automatically

And MOST IMPORTANT, when I do command recall in the telnet buffer,

I can back all the multiple lines of a single SQL query as one piece.

In all versions after 20.3.6.1 (that I've tried), including 21.2 that I just tried

now, I get the following:

SQL> select * from dailyvalues

where portname='DOLL' limit to 1 row;

select * from dailyvalues

where portname='DOLL' limit to 1 row;

                          ^

%SQL-F-AMB_KEYWORD, Ambiguous keyword abbreviation

SQL>

I believe the telnet mode relies on comint mode underneath (I've looked

through the code some).  So maybe it's just a usage problem, except that

in the newer versions I need to set some lisp variable that will give me the

behavior I want?  Here's hoping.

pat