473,225 Members | 1,338 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,225 software developers and data experts.

Simple update query is making me lose my mind...

I feel so stupid for posting this but I cannot figure out why I'm getting an error with this simple update query.

Expand|Select|Wrap|Line Numbers
  1. update [spa work order pgsql]
  2. set [scan_closing] = '02/14/06 06:00:00 AM'
  3. where [scan_closing] = '02/14/20 06:00:00 AM'
Gives me the following error:

Server: Msg 512, Level 16, State 1, Procedure HIFL3253_SO_15155, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

And that's it. I cannot grok that error message BECAUSE THERE'S NO SUB QUERY. I can see no reason why this should error out. Thanks in advance to anyone who points out whatever simple thing I've missed.
Oct 20 '06 #1
3 3508
Check your update triggers.
Oct 20 '06 #2
Check your update triggers.
Thank you kind sir. There was a trigger in there I didn't know about. It just didn't occur to me to look at those.
Oct 20 '06 #3

I'm in the process of doing a lot of clean up work on the db.
When I first got here there were 117 triggers on the main table that ran everytime ANY entry was updated. Performance killer would be a kind way to put it. Those triggers came from an ASP page that actually PRODUCED a trigger for a dealer that sent an email when their product shipped. I dealt with those triggers and ASP pages and got it down to 3 triggers for the table. Anyway, you've just alerted me to ANOTHER page that was doing the same thing, just not with the same frequency so it escaped my attention because I thought I'd finished with that horrible mess.

Thanks again. Knew it was something simple I was missing.
Oct 20 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: dr. zoidberg | last post by:
Hello, I'm creating simple menu. MySQL: +----+-----+----------------------+ | id | sid | Title | +----+-----+----------------------+ | 1 | 0 | Main Menu 1 | 2 | 0 | Main Menu 2 | ...
by: Andrew Baker | last post by:
What is the best way to lock an individual row in the following scenerio: --TODO - LOCK THIS ROW -- Return the next id SELECT next_id INTO next_id_out FROM owner.my_id_table WHERE app_id =...
by: Joshua Moore-Oliva | last post by:
I have a query that is asking me to GROUP a column, yet when I GROUP it it causes an error near GROUP. What is very strange about the following query is that the line list_size_active =...
by: Randy Harris | last post by:
I imported records into a table, later found out that many of them had trailing spaces in one of the fields. If I'd caught it sooner, I could have trimmed the spaces before the import. This...
by: wildbill | last post by:
I have an Excel spreadsheet with 1000+ rows that I need to import into an Access 2002 db once a month or so. I then need to use that information to update any existing records(multiple fields may...
by: graham | last post by:
Hi all, <bitching and moaning section> I am asking for any help I can get here... I am at the end of my tether... I don;t consider myself a genius in any way whatsoever, but I do believe I have...
by: Ben | last post by:
I'm designing a fairly involved database system. As part fo the process, I use the \i command a great deal. I set up fairly involved queries, sometimes simply for the purpose of shortening column...
by: ChasW | last post by:
Is it possible, within Access, to create an update query that replaces all spaces with underscores for text data in a given field? I am aware that it can be done by going into Edit -> Replace,...
by: Ivan Marsh | last post by:
Hey Folks, I'm having a heck of a time wrapping mind around AJAX. Anyone know of a simple, straight-forward example for pulling a simple query from mysql with PHP using AJAX? As I...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.