Updating

[Deane Venske]

On Wed, 11 Feb 2004 09:06:15 +0200, Ruslan Zasukhin 
<sunshine at public.kherson.ua> wrote:

> on 2/11/04 1:40 AM, Deane Venske at deane.venske at eduss.com wrote:
>
>>>> 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.
>
> Please send me snapshot of your db
>
> And UPDATE command.
>
> I assume it not works from viSQL also?
>

I haven't tried viSQL, but from vStudio it is also broken. I'll recreate 
the problem (DIdn't backup the DB before removing the method), and send 
you the sample DB

-- 
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