Download user manual - Instant Developer Documentation

Transcript
Andrea Maioli – Instant Developer: User's Guide
In its default form, the document's master query is equal to the query that the framework would have run automatically. Each column of the query is related to a public
property of the document.
We can now see how to use the master query to avoid calculation of the order total
with a separate query in the AfterLoad event.
You can simply add a new column to the query, assign it to the OrderTotal property
and use as an expression a subquery capable of calculating the total. The advantage of
this solution is that everything is resolved with a single query instead of two, which
helps optimize execution by the database server.
188