>I've used grids with tables and views (both local & remote) without any problem but now I want to create a grid that is tied to a cursor that I created on the fly with "CREATE CURSOR." I can't seem to make it work. I've name the cursor "Temp" and am selecting the datasourcetype/datasource as "Alias/Temp" and the columns all reference temp.column_names. I can select and BROWSE the grid and see the records but when I try and refresh the grid it just comes up blank. How do it tie the two together?
>
>Thanks,
>Robert
Create the cursor in load and you should be all well. Grid would come up blank (all white) when there is an error in one of column expressions. You can play with the cursor safely if in between you set grid's recordsource to empty string:
grid.recordsource = ""
*...
grid.recordsource = "temp"
However if you're working with cursors why not simply making it the recordsource from the start (RecordsourceType = 4 and RecordSource = whatever your SQL is).
Cetin