Ian wrote: > I notice that if I set my recordset to Readonly that the error goes away but surley >I shouldn't need to do this? > >I really don't need to update it anyway but it strange how it is not available for >updates. I was doing a simple SELECT althought it has 1 >innerjoin.. maybe this could be the problem > >Any ideas?
As far as I understand it is the cursor-type you used with ODBC. With some (one?) of them an implicit 'FOR UPDATE OF' syntax-part is appended to your statement. And the kernel checks if this select has any chance to produce an updateable cursor. In case of a join that is not the case and the kernel tells you that with the (ok, misleading) error -7008. I forwarded this message to the ODBC-guy to receive an explanation which cursor-types will use such a behaviour. But so far no response. Elke SAP Labs Berlin -----Original Message----- From: Ian [mailto:[EMAIL PROTECTED]] Sent: martes, 15 de octubre de 2002 14:48 To: '[EMAIL PROTECTED]' Subject: Error "Updates of this table not allowed" on SELECT Hi there, I got the following error on a standard SELECT statement, not and insert of anything like that [S1000] General error;-7008 POS(181) Updates of this table not allowed. Here is the SQL statement that seems to cause the problem. SELECT Acd_members.* , Users.* FROM Users INNER JOIN Acd_members ON Users.UserID = Acd_members.UserID WHERE (AcdID =1) AND (In_Out = 1) If I try running it in the SQL Studio it brings back results but in my app using the ODBC connection it always says the error msg. Anybody got any ideas, I am really stuck on this one, I can't understand why it reports that Updates are not allowed when I am only trying to do a select Thanks in advance Ian This email has been scanned for viruses and found to be clean. I can be contacted via MSN Messenger using [EMAIL PROTECTED] as the signin name. Why not use it!? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
