Updating

[Deane Venske]

On Wed, 11 Feb 2004 01:33:17 +0200, Ruslan Zasukhin 
<sunshine at public.kherson.ua> wrote:

> on 2/11/04 12:43 AM, Deane Venske at deane.venske at eduss.com wrote:
>
>>> Hi Ruslan,
>>>
>>> I'm working with V4MD and I'm finding a very odd problem. I'm doing an
>>> update to a table and I'm even getting a records affected = 1, but the
>>> data is not being updated. I've made sure I void my cursor after doing
>>> selects on that table (I actually have a global query function that
>>> returns the query as a list and then get rid of the cursor by voiding
>>> it. Do I need to do a VCursor.close() or something like that? The odd
>>> thing is getting the records affected = 1. I also am using flush(db)
>>> once I've done the update.
>>>
>>
>> Seems the problem was having a method in that table stopped updates from
>> happening. Is this a bug?
>
> Unlikely.
>
> May be that method marked as UNIQUE?
> And new data cause it to unique value?
>
> Or something like such?
>

I couldn't even update a value that was unrelated to the method.
TABLE : exerciseID, mark, noQuestions, userID, assessmentMode
METHOD : percentage : (mark / noQuestions) * 100
When I tried to update userID it failed, gave records affected. Even a 
table wide update gave 15 records affected but no changes happened.

-- 
Deane Venske - Senior Programmer
www.eduss.com.au   deane.venske at eduss.com
+61 7 55974600  +61 405148718
Suite 29,  207 Currumburra Rd
Ashmore, Queensland, 4214
Australia