Hi Ajit, > -----Original Message----- > From: Ajit Aranha [mailto:[EMAIL PROTECTED] > Sent: Montag, 10. Mai 2004 14:43 > To: [EMAIL PROTECTED] > Subject: ODBC and select count queries > > > Hi, > I am using SQLExecDirect to "select count(*) from sometable where > somecolumn='somevalue'". > > I get the error : SQL_ERROR - [SAP AG][SQLOD32 DLL][SAP DB] General > error;-7008 POS(162) Updates of this table not allowed (errcode -7008, > sql state "HY000")
Hm, the error message states position 162 in your SQL statement. However, it seems to be not that long. > Changing the count(*) to column name executes as expected. Is > there any > workaround to this?? Can you please send me an example for reproducing the error. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP AG, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
