hi flo, the problem is that the result column is not definite, in other words there are two result columns with same name: FIELD1. using sapdb one can avoid this problem by aliasing the result column name: 'Select Feld1 [as] newname, Feld1, Feld2 from Tabelle order by newname;'
this is actually much cleaner. John Holland Consultant BANCOTEC Ein Unternehmen der Cellent AG. Calwer Strasse 33, 70173 Stuttgart Tel: ++49 711 222 992 900 Fax: ++49 711 222 992 999 Mobile: ++49 172 7886719 mailto:[EMAIL PROTECTED] http:\\www.bancotec.de http:\\www.cellent.de <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:<[EMAIL PROTECTED]>. .. > 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? > > Thanks > > Flo _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
