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 **********************************************************************