Vers. 18 Here doc redirection broken?

Jun 11, 2008
26
0
#1
I thought I posted a message to this effect in August 2015 when I first found the issue, but cannot find it, so I am reposting now.

I have several .btm batch files that use "Here Doc Redirection" like this:

Code:
: create new database file
sqlite3 %dbf <<-ESQL
   CREATE TABLE brnch (
     asset      integer,
     branch     integer,
     custnum    integer,
     cap        integer,
     external   integer,
     schedext   integer,
     internal   integer,
     xtended    integer,
     pcode      integer,
     town       text,
     customer   text,
     riskgroup  text
);
ESQL

sqlite generates error message:
Error: incomplete SQL: C
This example was created under Version 12 and works fine up to Version 17.
It does not work under Version 18 upto TCC 18.00.30 Windows 7 [Version 6.1.7601].
My work-around is to run under Version 17.

Has anyone else noticed/reported an issue with Here Doc Redirection before now?

Is it perhaps a setting (setdos, option) that may be different between versions?

Or is something broken?


John
 
#2
I have no problem with TCC 19.
Code:
g:\sqlite> type test.btm
sqlite3 db.db <<-ESQL
  CREATE TABLE brnch (
  asset  integer,
  branch  integer,
  custnum  integer,
  cap  integer,
  external  integer,
  schedext  integer,
  internal  integer,
  xtended  integer,
  pcode  integer,
  town  text,
  customer  text,
  riskgroup  text
);
ESQL

g:\sqlite> test.btm

g:\sqlite> d *.db
2015-12-22  22:45  2,048  db.db
 
#4
V18 is also OK here. With the same BTM file ...
Code:
g:\sqlite> ver

TCC  18.00.32  Windows 7 [Version 6.1.7601]

g:\sqlite> del db.db
Deleting G:\sqlite\db.db
  1 file deleted  4,096 bytes freed

g:\sqlite> test.btm

g:\sqlite> d *.db
2015-12-23  13:04  2,048  db.db
 
Jun 11, 2008
26
0
#5
V18 is also OK here. With the same BTM file ...
I have updated my V18 to TCC 18.00.32 Windows 7 [Version 6.1.7601], but still get:
[C:\Users\John\Documents]
Sat 17:14: tst
Error: incomplete SQL: C

db.db is not created.

I have also installed V19_00_27. Under V19 the Here Doc redirection in this example appears to work as it did prior to V18. I will need to test more extensively to confirm this.

I acknowledge that I should have presented a more generic test example. I am now moving on with V19 and will only revisit this if I have problems in V19.

John