Can a Query Class update multiple tables at once ?
Query classes can’t, if you create views in Postgres instead you can
write insert and update rules that allow you to write logic that will
apply your insert or update query on your view into multiple
inserts/update into multiple tables.
On 14/3/18 12:22 pm, Das Goravani wrote:
> Can you update the fields and tables present in a query class by doing an $update on a row/list defined from the query class?
> Where mylist is defined from a query class containing say 3 tables, fields from 3 tables
> Will all the present columns get written back to the data?
> So can you update from a multi table query to multi tables?
> I know you can read from multi tables, that’s obvious. I didn’t see updating covered in the docs for query classes.
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:email@example.com