Information générale
Titre:
extraneous browse window
Related thread: SELECT ... WHERE process in ?lcProcess
Being unable to pass a parameterized list to a view I'm
attempting a different approach.
Given:
Grid with
RecordSource:
SELECT Itmlayer.thickness, Itmlayer.color, Itmlayer.process FROM glass!itmlayer
WHERE Itmlayer.process in (select Process from Process_cursor)
RecordSourceType: SQL
Form.Load:
CREATE CURSOR Process_cursor (Process C(2))
Form.lstProcess:
*** lstProcess.Click
*** Created: 08/14/96
*** Purpose: keep track of selected items in this box.
FOR nCnt = 1 TO This.ListCount
IF This.Selected(nCnt)
insert into Process_cursor (Process) values (THIS.List(nCnt,2))
ELSE
delete from Process_cursor where process = THIS.List(nCnt,2)
ENDIF
ENDFOR
With this code:
wait window "Command1.Click begin"
THISFORM.Grid1.RecordSource = "SELECT Itmlayer.thickness, Itmlayer.color, Itmlayer.process;
FROM glass!itmlayer WHERE Itmlayer.process in (select Process from Process_cursor)"
wait window "Command1.Click end"
the CORRECT results are showing up in Grid1, but a browse window is also showing up. Can this be suppressed? How?
Thanks, Kim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement