How do I prevent FORM1 from displaying values as program executes

[smsmail]

Hello,

How do I prevent form1 from display values as program executes.

I am executing a loop and form1 display results of a select statement. How do I prevent this?

I have tried SET TALK OFF.

Thank you in advance

 

[Mike Lewis]

You need to add INTO CURSOR or INTO ARRAY to the end of your SELECT statement. For example:

SELECT AField, AnotherField FROM MyTable ;
  ORDER BY AField ;
  [b]INTO CURSOR MyCursor[/b]

Without the INTO clause, the query results will be sent to a Browse window, which is probably what you are seeing. By the way, it's got nothing to do with the fact that the form is closing; the same would happen with any SELECT statement.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[smsmail]

Mike, Thanks again!

Added the cursors, the program is not displaying the browse window.

Again, I appreciate you help.