Query based update failed
Query based update failed
Query based update failed
Query based update failed
Query based update failed
Query based update failed Query based update failed Query based update failed Query based update failed Query based update failed Query based update failed Query based update failed Query based update failed
Query based update failed Query based update failed
Query based update failed
Go Back  Xtreme Visual Basic Talk > > > Query based update failed


Reply
 
Thread Tools Display Modes
  #1  
Old 12-25-2003, 01:37 AM
kliklu kliklu is offline
Freshman
 
Join Date: Mar 2003
Posts: 27
Default Query based update failed


Hi,

I have a program that works as a back end process ( a trigger program). The problem is, when it is running, most of the time, it will prompt the error,

"Query based update failed because row to update could not be found"

I have tried running the program line by line, but the error just doesn't come out. Please help.

Thanks
Reply With Quote
  #2  
Old 12-25-2003, 06:44 AM
Shurik12Query based update failed Shurik12 is offline
Steppe Walker

Retired Moderator
* Expert *
 
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
Default

Hi,

Could you give a bit more details? Eventually show the code.

Regards,
Shurik.
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'
Reply With Quote
  #3  
Old 12-25-2003, 02:58 PM
Optikal's Avatar
OptikalQuery based update failed Optikal is offline
Codeaholic

Retired Leader
* Guru *
 
Join Date: Oct 2002
Location: Winnipeg, MB, Canada
Posts: 4,543
Default

put proper error handling in your code that logs errors to a log file rather than to the screen.
__________________
There are 10 types of people in this world, those that understand binary, and those that don't.
Reply With Quote
  #4  
Old 12-30-2003, 03:04 AM
wesly wesly is offline
Newcomer
 
Join Date: Dec 2003
Location: Yangon, Myanmar
Posts: 9
Default

Hello kliklu

I think theres a problem with UPDATE SQL statememt.

First, you should find out the problem of your SQL statement in SQL Server Quary Analyzer by Running statement. (You can find your error in UPDATE or TRIGGER statement)

If it's work, check you code and then you permission to SQL Stored procedure.

Yours
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Query using WHERE Briandr Word, PowerPoint, Outlook, and Other Office Products 10 10-20-2003 01:18 PM
Access 2000 update query not working??? slim steve Database and Reporting 1 08-01-2003 02:27 AM
Urgent Update Query Needed pedro Database and Reporting 2 05-01-2003 11:44 PM
unable update data in report even if ado.command has executed a different query pragash79 Database and Reporting 4 08-29-2002 09:59 PM
How to compare an empty value in a query.. pragash Database and Reporting 1 10-23-2001 12:12 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Query based update failed
Query based update failed
Query based update failed Query based update failed
Query based update failed
Query based update failed
Query based update failed Query based update failed Query based update failed Query based update failed Query based update failed Query based update failed Query based update failed
Query based update failed
Query based update failed
 
Query based update failed
Query based update failed
 
-->