I have a select statement in which the column list contains expressions
(columns divided by 100, etc). Something that looks like
SELECT A.COL1,
                 A.COL2,
                 B.COL3/100,
                 B.COL4/1000
FROM     A, B
WHERE  A.COLK = B.COLK;
This select is launched from a WEB server using Microsoft IDC technology to
display the result in a WEB browser. It works fine except for one thing: I
cannot see the third and fourth columns. To make them appear, I have to
specify their column names in a HTX file (on the WEB server), but IDC does
not recognize neither "B.COL3/100" nor "B.COL4/1000" as column names.
With other RDBMS, there is a workaround: to use column aliases in the
select, so I can specify these aliases to display their values in the WEB
browser. The select statement would then look like this:
SELECT A.COL1,
                 A.COL2,
                 B.COL3/100 as COL3,
                 B.COL4/1000 as COL4
FROM     A, B
WHERE  A.COLK = B.COLK;
Unfortunately, Allbase does not seem to support column alias.

I tried the first SELECT statement within ISQL and I found out Allbase
assigns "(EXPR)" as column name to every column made of an expression. Then
I specified "(EXPR)" as the third column in the HTX file on the WEB server
and launched the query: It worked! Except I cannot find a way to specify the
fourth column name...

Does anyone know if it is possible to specify a column alias in a select
statement with Allbase?

Michel Gauthier
Donohue Inc.