RE: Error "Updates of this table not allowed" on SELECT

[Ian]

Hi Thomas,   Excuse my ignorance.. where do I find this value??? I looked under parameters not there, and under ODBC…. Any ideas?   Thanks in advance   Ian   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Koetter, Thomas Theodor Sent: martes, 15 de octubre de 2002 18:00 To: 'Ian'; [EMAIL PROTECTED] Subject: RE: Error "Updates of this table not allowed" on SELECT   Hi Ian   How did you set the SQLSetStmtAttr (SQL_ATTR_CONCURRENCY)?   If you set it to SQL_CONCUR_READ_ONLY, the error should not appear, i.e. the "FOR UPDATE" will not be added to the statement.     Greetings  Thomas     ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin   SAP DB is open source. Get it!    www.sapdb.org   -----Original Message----- From: Ian [mailto:[EMAIL PROTECTED]] Sent: Dienstag, 15. Oktober 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!?