I've run into a pretty solid [plaster] wall today [not quite a brick wall, that is...(**)]  I tried something that I expected to work(*), only to find that the version of allbase and/or ODBC I'm using simply "doesn't do that" -- in a google search for "sql select alias allbase", I found this link:

http://www.hp.com/products1/evolution/e3000/news_events/new_features.html

which indicates that renaming a field ("select sum(qty) as total_qty", for example) is now available -- cool, that's just what I need, but what version does this apply to?  It isn't listed on the page, or at least I didn't spot it "immediately", [and for whatever reason, HP has done some "fancy coding" to their page to disable the "view source" menu item of Microsoft's IE browser -- guess I'll have to look at this page with a "better" browser ;) ]

Interestingly enough, "going back a level" on this page (to merely "news and events") goes to a page that does NOT have a link to this "new features" page, so I'm kind of at a loss as to which version of allbase this page talks about

Tom

(*)  Actually, there are a couple of things I tried: one was renaming the result of an expression, the second was to actually have more than one "expression" in the list -- under isql I could do this, but the second expression ended up with a null result.  From within VB, the ODBC result simply returned one column instead of two...

(**) basically, the program I'm working on does a select against a dataset with a key value, totalling up "just one field" for use in a comparison later.  I figured this was pretty wasteful to transfer down the entire list when I knew "sql" can do this "on the server" and return one result instead of thousands -- while it works, I have to change my program to use the result by it's ordinal position rather than by name, or else change the instances of the name to "(expr)", which is a pain...

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *