Updating

[Ruslan Zasukhin]

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?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------