October 4, 2009 at 1:58 pm
I need to update a field in multiple rows with a bit of strinhg manipulation. I get an error though so I need to use some sort of loop or maybe even a stored procedure. Here is what I am trying to do...
update pkgstatus
set location=(left(location,14)+'E'+right(location,21))
where type = '1' and location not like '\\frdkemsms01\e$%'
I get the following error :
Cannot update more than one row at a time on this table, PkgStatus.
Basically I am trying to change a drive letter in the field, any ideas ? Many thanks.
October 4, 2009 at 2:40 pm
thats a most unusual error message. I would hazard a guess the table has a trigger on it that prevents multiple updates.
---------------------------------------------------------------------
October 5, 2009 at 7:57 am
Is there a trigger on the table?
Oops, didn't read all of George's response before posting. But at least we agree.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 13, 2010 at 6:57 am
Thanks guys, that was the fix, could have sworn I posted a reply, sorry for that!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply