I'm still trying to display my SELECT results in a grid. I have a form that contains a grid which displays AGENTS_VIEW. I've put a SELECT ... INTO CURSOR AGENTS_VIEW statement in the Load method of the form and the grid displays the results perfect. However, if I want to execute another SELECT statement into the same cursor, I get nothing. If I quit my program and re-execute it, I get the second SELECT results in the grid if I take out the form's Load method SELECT statement. So, it appears to have done it, but just not displayed it (yes, I am refreshing the grid). If I issue a SET FILTER TO statement and then LOCATE, the results are displayed in the grid.

1) Can I issue subsequent SELECT statements into the same cursor and display the results into the same grid?

2) Am I missing something to make this work?

3) If I have to use SET FILTER instead of SELECT, do they both use the same wildcards?

Thanks.