Hello,
On Dienstag, 4. Februar 2003 10:57, [EMAIL PROTECTED] wrote:
> Hello @all!
>
> We changed from Adabas to SAPDB.
> In our program we use(d) SELECT Statements like
> 'Select Feld1, Feld1, Feld2 from Tabelle order by Feld1;' with no problems
> on Adabas.
> Using SAPDB we get an error
> 'Error: SAP DB:-5014[SAP AG][SQLOD32 DLL][SAP DB]General error;-5014
> POS(68) Missing definite column name.'
> WE can fix it with
> 'Select NUM(Feld1), Feld1, Feld2 from Tabelle order by Feld1;' but this
> would mean a lot of work on our sourcecode.
> Any ideas or workarounds to solve it otherwise?
>
you might also fix it by saying 
select ... from ... order by 1
thus making the column definitely unambiguos. SPDB is somehow too critical 
here, in my opinion.

Peter Willadt
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to