September 27, 2002 at 7:37 am
I have suddenly got a problem, whenever I try too run a SQL statement like "update MyTable set Field1 = 'Test' where Field2 = 23" I get this error msg "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
"
Anyone got any idea why this hapens???
Any help would be greatly appreciated.
September 27, 2002 at 7:41 am
I presume this query used to work on the table and that the query has not changed?
Have you modified the table at all? Maybe added a trigger? I have had this before. The error was infact refering to the tables being called within the trigger...not on the table used in the update.
Clive Strong
September 27, 2002 at 7:49 am
Thx!!!
It was a trigger!
quote:
I presume this query used to work on the table and that the query has not changed?Have you modified the table at all? Maybe added a trigger? I have had this before. The error was infact refering to the tables being called within the trigger...not on the table used in the update.
Clive Strong
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply