>I have a grid on a form that I want to populate using a selected portion of the records in a table. Basically, when a person logs on I find their logon ID and get the records from the table that match.
>
>I thought the best way to do this was with a query and made that the recordsourcetype of the grid. But in my form controls that refresh the query, I am running into a select problem. I want to issue a SELECT this.field, that.field FROM mytable INTO query.qpr WHERE name = thename.
>
>Foxpro reports that the code has a syntax error and I find it is related to the INTO clause. And Intellisense doesn't seem to allow an INTO for a query, only for a cursor or array.
>
>What am I doing wrong, or is there a better way to fill the grid.
>
>TIA
INTO is to be followed by a cursor, or by a table:
... into cursor TempCursor
or:
... into table MyTempTable
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)