The ability to do ANSI std. column aliasing has been an SR now for a long time,
and has also been on the SIG Allbase enhancement list for some time.  The
different ODBC driver vendors take different approaches to it since it isn't part of
Allbase proper.  Some such as ODBCLink/SE return the column name as given
by Allbase (i.e. every column is named "(EXPR)" for expressions or "(CONST)"
for constants), whereas other vendors 'fudge' that name a bit like appending a
serialization number to that name to make it unique (i.e. "(EXPR1)", "(EXPR2)").
Therefore, even if you use a driver which can uniquely name the columns, you'll
have to be very careful in your coding if you ever change the select statement,
or change ODBC driver vendors.

  The lack of column aliasing wasn't a big issue when most everything was host-
based, but it is a big problem for client/server or web-based applications.

Regards,
Michael L Gueterman
Easy Does It Technologies
email: [log in to unmask]
http://www.editcorp.com
voice: (888) 858-EDIT -or- (509) 943-5108
fax:   (509) 946-1170
--

-----Original Message-----
From:   Michel Gauthier [SMTP:[log in to unmask]]
Sent:   Friday, March 19, 1999 8:04 AM
To:     [log in to unmask]
Subject:        [HP3000-L] Allbase question

<snip>

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

Michel Gauthier
Donohue Inc.