Record Source Property in a grid

[manosubbiah]

Hai,
I am new to vfp programming.
When i give the recordsource property for a grid at run time as follows,
thisform.grdi1.recordsource = "select * from table1 where table1.field1 = +mnbr"
I have set the recordsourcetype property as sql stt in design time itself.
When the record source property is assigned to the grid , the browse window pop's up. I don't need the browse window to pop up. This has to be prevented. I am held up with this problem. Please help me out to fix it asap.
Rajam

 

[DEDMOD]

I hope you get a good answer to this question soon. I've got the same problem. It seems to me I asked something about it a few days ago, but I haven't got it working yet.

For the time being, I've just switched to a different way of getting the data to the grid. -- Dave

 

[foxdev]

Add to your statement " into cursor temp" or some such. Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org

 

[rajam]

Hai,
I got the answer.
the sqlstt should be
select * from table1 where table1.field1 = +mnbr into cursor
cursor1.It works fine
Thank you.
Rajam