Help is appreciated. I have a table with integer columns rank, tot,
det with values in tot and det and I want to put an integer percent
(0-100) into rank
UPDATE av_summary SET rank=(det/tot)*100; returns 0 I assume
because the arithmetic is in integer
UPDATE av_summary SET rank=((det*100.0)/(tot)); only sets the
first row correctly then all the others have bogus data in rank
UPDATE av_summary SET rank=ROUND((det*100.0)/(tot)); works over all rows
Could someone explain. Also is there a "cast" operator in the SQL
that SQLite executes?
TIA,
Tom
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------