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:[email protected]
**********************************************************************
