At 1:40 PM +0000 3/12/07, [EMAIL PROTECTED] wrote:
Tom Shaw <[EMAIL PROTECTED]> wrote:
Here ya go.
>Tom Shaw <[EMAIL PROTECTED]> wrote:
>> UPDATE av_summary SET rank=((det*100.0)/(tot)); only sets the
>> first row correctly then all the others have bogus data in rank
>
>That seems wrong. Can you post a sample database that demonstrates
>this behavior?
>
I tried this on the database you sent me. The answers
all look right to me.
Using sqlite 3.3.5
UPDATE av_summary SET rank=((det*100.0)/(tot));
sets first row to an integer (serendipity?) and then all the other
rows are real or text which caused problems since I was expecting
that column was integer since that is how the table was created. I
see when I export that the numbers are real in the text exported.
This must have been what confused me. There is obviously something
here that I don't grok.
Thanks,
Tom
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
