>I have a grid and when I load it up, I want the rows to be populated with the results of a sql statement. What shoudl I set the properties to? (Record source etc.)
>
>Currenty I have
>RecordSource: select *., from track.dbf
>RecordSouce: Sql Statment
>
>I am missing something aren't I?
>
>TIA
>
>Jeff T.
I would SELECT the data into a cursor, then bind the cursor to the grid:
SELECT ... INTO CURSOR MyCursor ...
THISFORM.MyGrid.RecordSource = "MyCursor"
There will probably be more you'll have to do for formatting, etc., but you get the idea and you can play with it to get it set up the way you want.
On the way out of the form you can clean up by getting rid of the cursor with:
USE IN SELECT( "MyCursor" )
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.