Can a Query Class update multiple tables at once ?
SQL standards prevent updating multiple tables at the same time.
You would have to put into your object or table the code to do this, then you can call that method with a single line of code.
Not your old Omnis!
—————————————————-
Alan Grinberg
AG Systems/ZOO-INK
San Francisco, CA
www.zoo-ink.com <applewebdata://6FC2DC65-DAC8-49CC-8D78-96057B5C4CB7>
www.perfectfit.net
alan@perfectfit.net
—————————————————-
> On Mar 13, 2018, at 6:22 PM, Das Goravani <das@goravani.com> 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?
>
> Ie
>
> Mylist.$update(loldrow)
>
> 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:omnisdev-en@lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com