|
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? Ian -----Original
Message----- 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
|
