I have a drop-down listbox in Visual Class Form; code
is shown below. See embedded comments for clarifications.
QUESTION is below code snippets.
I have code in my Visual Class Form init() routine:
form.init()
...
...
SELECT TRIM(DD_ships.sh_name)+" "+TRIM(DD_ships.sh_type)+"-"+TRIM(DD_ships.sh_hno) AS ship, ;
DD_sdilist.sl_shipid,TRIM(DD_ships.sh_type),val(DD_ships.sh_hno), ;
DD_sdilist.sl_idxtype ;
FROM DD!DD_sdilist inner JOIN DD!DD_ships ON ;
DD_sdilist.sl_shipid=DD_ships.sh_shipid ;
&l_cWhere ;
ORDER BY 3,4 INTO CURSOR curSDIlist
...
*// cboShip is drop-down listbox
*// RowSourceType is 6 - Fields
THISFORM.cboShip.ROWSOURCE="curSDIlist.ship,sl_shipid"
...
...
* In cboShip.InteractiveChange() method code is:
WITH THISFORM
...
...
...
SELECT DISTINCT dd_sdidata.si_index FROM dd_sdidata ;
WHERE dd_sdidata.si_shipid=VAL(THIS.VALUE) INTO CURSOR
curIndexList
...
...
ENDWITH
>>>>>>>>>>
My question is how does the InteractiveChange() method for drop-down list pick the 2nd column (Field) from Rowsource for cboShip Value. I've confirmed this fact through debugging.
FZ (Boston MA)
Don