|
yaronbb -> Operation must use an updateable query (10/5/2006 5:49:39)
|
hi to all
i am trying to run this code in frontpage2002
"update table_insert set total = (select total from table_total where userid = ::userid:: and event = ::event::)
where per is null and userid = ::userid:: and event = '::event::'"
and when i try to run it i get this error
"Operation must use an updateable query"
when i try to run it like that
"update table_insert set total = 10
where per is null and userid = ::userid:: and event = '::event::'"
its working good
thanks
|
|
|
|
