Chuck,
My suggestion would be:
The primary query loads the index, and does the query from the index,
only the first [Invoice item] record found will be loaded, and there
happens not to be a relational loop (see below).
The QSxF will need to load each record.
Since you have a lot of auto relations, you might have a 'long way
around' (tm) relational path.
maybe something like:
[invoice_line] -> [Invoice] -> [customer] -> [order]
which is changing the order selection/record and unloading it
Personally - i very rarely use auto relations for just such issues :)
Chip
On Thu, 7 Jun 2018 12:53:47 -0400, Chuck Miller via 4D_Tech wrote:
> env v 15.x
>
> I have the following set up
>
> order table
> order line table related auto to order
> invoice line table related auto to order line
> packing list table related auto to invoice one table
>
> I have the following queries
>
> QUERY([Order];[Order]Order_ID=$OrderIDS_aL{$Loop_L})
> // on record found
> $OH_CustomerPartNumber_atxt{$Loop_L}:=[Order]Cust_Part_No
>
QUERY([Invoice_Line];[Invoice_Line]Packing_List_ID=$OH_PackingListIDS_aL{$Loop_L})
> //order record still loaded
> QUERY SELECTION BY FORMULA([Invoice_Line];Find in
> array($as_charges;[Invoice_Line]Item)=-1)
> order record sometimes unloaded.
>
> Any ideas as to what is going in. Why would the order be unloaded
> after query by formula and not by the initial query
>
>
> Thanks and regards
>
> Chuck
>
------------------------------------------------------------------------------------------------
> Chuck Miller Voice: (617) 739-0306
> Informed Solutions, Inc. Fax: (617) 232-1064
> mailto:cjmiller<AT SIGN>informed-solutions.com
> Brookline, MA 02446 USA Registered 4D Developer
> Providers of 4D and Sybase connectivity
> http://www.informed-solutions.com
>
------------------------------------------------------------------------------------------------
> This message and any attached documents contain information which may
> be confidential, subject to privilege or exempt from disclosure under
> applicable law. These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution,
> disclosure, printing, copying, storage, modification or the taking of
> any action in reliance upon this transmission is strictly
> prohibited. Delivery of this message to any person other than the
> intended recipient shall not compromise or waive such
> confidentiality, privilege or exemption from disclosure as to this
> communication.
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ: http://lists.4d.com/faqnug.html
> Archive: http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:[email protected]
> **********************************************************************
---------------
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
