Hello, On Freitag, 22. November 2002 20:05, Gustavo Comba wrote: > Hi, > > I'm issuing the following query: > > SELECT FECHA AS CREATETIME, FECHA AS MODIFIEDTIME FROM > LECTURASHISTORICAS ORDER BY FECHA (actually this is only a part of the > query, but throws the same error) > > And I'm getting the following error: > > -5014, "Missing definite column name" > As long as the column name you order by appears to be ambiguous, you will get an error. (In this case it is in reality not ambiguous, as it will be the same value ever. But sapdb doesn't realize that)
You may help yourself out by making it unambiguous, perhaps by saying ...ORDER BY 1 Perhaps ORDER BY CREATETIME or ORDER BY MODIFIEDTIME might also work. You should try if you don't like positional numbering. Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
