|
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
|
