Il giorno giovedì 23 maggio 2013 02:46:21 UTC+2, Simon Ashley ha scritto:
>
> Thanks Simone,
>
> A little more on this. 
> Seems to to be an issue with windows consuming memory and grinding the 
> system to semi halt. 
> The characteristic isn't there in Linux. (ubuntu under vmware hosted by 
> win7) 
>
> Are you sure on 
> db(query).update(**arguments)
>
> ? (seems to fall over with too many tables selected. Was my original 
> hesitation in doing an update on the results of a join)
>



hum ? i was referring to changing your code from 
row = db(query)
row.update_record(**arguments)


to
db(query).update(**arguments) 

what works in the first works in the latter.

As for updates involving multiple tables (i.e. updating a table with values 
from another one) as ex'plained earlier is a viable solution (albeit non 
present in DAL's code, but achievable with executesql) only on database 
supporting it. SQLite doesn't.

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to