Welcome! Log In Create A New Profile

Advanced

Topic 6B-2

Posted by Dennis 
Announcements Last Post
Announcement myUnisa availability 21 to 24 March 2019 03/17/2019 02:24PM
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
Topic 6B-2
September 26, 2006 08:55PM
Topic completed

Re: Topic 6B-2
September 26, 2006 09:08PM
I have to add a comment because I had this problem today. If your UPDATE fails and you are stumped as to why, consider that there might be a deadlock on the record. I had a problem today when a stored procedure faled to do its job and no-one knew why. I then ran one UPDATE sql from the proc on its own, and got a deadlock error. It turned out that there was a trigger on one of the tables, and because the proc only commits at the end of the code, the UPDATE deadlocked with the trigger UPDATE. This can also happen if another database user is editing the same record via a database editor and hasn't commited his changes yet. The good news is that this can't happen in a web environment.

Anyway, all my tasks are completed, and it's 'min dae' till the project has to be in, so it's to get involved! See you guys in the prac forum!
Re: Topic 6B-2
September 28, 2006 10:08AM
Topic completed
avatar Re: Topic 6B-2
October 10, 2006 09:26PM
all done.
Re: Topic 6B-2
October 11, 2006 07:32AM
Topic completed
Re: Topic 6B-2
October 23, 2006 08:50PM
Topic Completed
Re: Topic 6B-2
November 01, 2006 09:59PM
Topic completed. I have found this chapter much more enjoyable than some of the others. This may be because I work a lot with Access databases so am pretty familiar with SQL commands, and also because the code actually works as it is described in the course book!
Sorry, only registered users may post in this forum.

Click here to login