Hello, On Freitag, 21. M�rz 2003 11:49, Benjamin Lukner wrote: > Hi! > > We are using SAP DB with Windows XP SP1, Visual Basic 6 SP5 and ADO. > Works fine. > > But (now) we get an error when using DISTINCT or GROUP BY: > > Error Number: -2147467259 > Error Description: [SAP AG][SQLOD32 DLL][SAP DB]General error;-7008 > POS(78) Updates of this table not allowed. > Error Source: Microsoft OLE DB Provider for ODBC Drivers > > The statement is: SELECT DISTINCT Ort FROM LagerPlatz > Only views that contain a 1:1 correspondence to the underlying tables are uptadeable. So neither group by nor distinct will work. That means, you have to open your recordset in a way that makes it cclear that you don't want to do any updates. Unfortunately you didn't show how you opened the query.
Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
