SQL Select Statement Opens Full Screen Browse But I Need To Suppress 2

[drosenkranz]

Hello There,

I have concateneated an SQL Select statement that pulls all records from a table where the unit is equal to user request in a text box.

I set the .RecordSourceType property of a grid on my form to (4) for an SQL Statement. I then assign my SQL Statement as the .RecordSource property of the grid. Then I issue THISFORM.GRID1.REFRESH()To populate the grid with the matching records. Here's the problem.

The result is displayed over the entire screen in the browse mode. If I close this "whole-screen" display that just pops open, I find my grid on the form behind as I intended it- its working, it just got shoved behind the screen that opened on top of my form.

WHY does the SQL Statement open up the full screen browse window display on top of my form?

How do I suppress this unwanted effect so only the original grid is displayed (refreshed) with the returned records from the SQL Statement?

Thanks
The 2nd mouse gets the cheese.

 

[fluteplr]

change the select statement

select * from whatever into cursor curwhatever

the default behaviour of a select is to select into a browse window

 

[DEDMOD]

Try using NOCONSOLE at the end of the SELECT. If that doesn't work, or you're already doing it, give us the SQL code to look at.

--Dave

 

[ramani]

THE SQL statement shall contain the clause INTO CURSOR. Failure to state the CURSOR or ARRAY sends the SQL to default browse window which is causing you the problem. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com