Chip,
You haven't got a SET QUERY DESTINATION somewhere have you?
Pat

On Mon, 15 Oct 2018 at 23:24, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Background
> - I use 2 tables to manage listboxes.
> - I am on an entry form, which includes a selection listbox.
> - I am trying to display, in a dialog (Mac so a type 34 sheet window),
> a different listbox (array) to allow the user to make a selection.
>
> before the below code executes, the current selection of
> [listbox_table] reflects the definition for selection listbox
> displaying on the current entry form (ID 1327).
>
> I make this call : arylstbx_Setup ("lb_Display_Choices";"Choose_Item")
> In the above call there are these lines of code:
>   //gets base info for listbox description
> QUERY([List_Box_Table];[List_Box_Table]Listbox_Name=$Listbox_Name;*)
> QUERY([List_Box_Table]; & ;[List_Box_Table]Primary_Use=$Primary_Use)
>
> $Listbox_Name = $1 = lb_Display_Choices
> Primary_Use = $2 = Choose_Item
>
> Results:
> - after the Query, the current record has not changed!
> - If I issue an Unload record (in debugger) before the query, no record
> is loaded
> - in 'user' environment' the same query locates, and loads a different
> record (ID 1505).
>
> State:
> in transaction [Listbox_Table] is read only & Locked
> all actions are occurring inside the same transaction.
>
> My thoughts and attempts to resolve:
> - entry form listbox was doing some sort of background query on
> [listbox_table] during on display detail, so I set the listbox
> invisible before opening the type 34 dialog window. -- no effect.
> - I have put traces in the code for the listbox and the form  to see if
> something is running and changing the selection of the [listbox_table]
> table - noting is running.
> - all of the code for the dialog is 'linear' to the entry form, i.e.
> the dialog is opened inside the same process and same transaction so -
> conceptually - no other code should be running to change the selection
> in the [listbox_table]
> - relations - only one relation, completely manual.
>
> and ideas?
> sorry for wall of text
>
> Chip
> ---------------
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************



-- 
*************************************************
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to