That’s not an error, its just the display format. Try using “show select…”
So in a q session, by executing the commands line by line, the results are individuals. Say “count t” produces one result “6” and “select from t” produces one result which is the table.
But when all the commands are written into a script, all the results of each command will be printed on screen as a general mixed list.
So in this case, the results of “count t” and “select from t” will be transferred into a list (general mixed list) and print it on screen. That’s why the table is not printed in the table form but the enlisted form.
i.e. running the script is equivalent to entering (system"l dbTEST15";count t;select from t) in the console
Another way of displaying the result in table format when you run the script is to format the result of “select from t” to plain text and write it to standard output…
Try this in the script:
\l dbTEST15
count t
1 .Q.s select from splay
Should be same as using “show select from t”…
The console uses .z.pi, which by default is {.Q.s value x}.
Results generated within scripts use 0N!x to output their result.
As Manish says, the difference here is just the display format.