Could you paste your VB code? Maybe I could help you with that.... I think the statement is rather ok.
Marcin Pytel Uzytkownik "Benjamin Lukner" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] > 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 > > The Create Statement is: > > create table LagerPlatz ( > Platz varchar(11) not null, > Ort varchar(3) not null, > Regal varchar(2) DEFAULT '' not null, > Reihe varchar(2) DEFAULT '' not null, > Hoehe varchar(2) DEFAULT '' not null, > Status int DEFAULT 0 not null , > Info varchar(30) DEFAULT '' not null, > cnt int DEFAULT 0 not null , > primary key (Platz, Ort) ) > > The Connection String is: > ;DRIVER=SAP DB > 7.4;SERVERNODE=TEST_PC;UID=XXX;PWD=YYY;SERVERDB=ZZZ;SERVER=TEST_PC > > !!!When trying the Statemtent with RDO or DBMCLI everything works!!! > > When trying SELECT Ort FROM LagerPlatz it works under ADO. > When trying SELECT Ort FROM LagerPlatz GROUP BY 1 I get the same error > as with DISTINCT. > > The error occured on SAP DB 7.3.0.29, so I installed 7.4.3.10. > I dropped the database and created a completely new one. > I also updated the ODBC driver and the DSN entry. > But that had no effect. I get the same error. > > Do you have any suggestions on this problem? > > > Kind regards, > > Benjamin Lukner > trinomix GmbH _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
