>I'm probably missing something basic but....
>
>I have a cursor build from an SQL Passthrough to a Oracle backend. I want to display the results of the sql in a grid. The grid's RecordSourceType is set to '1 - Alias' and the RecordSource to the name of the cursor. When I fetch the cursor (and verify that it has data) then run the form containing the grid, nothing shows in the grid.
>
>If I change the RecordSourceType to '4 - SQL Statement' and the RecordSource to 'Select * from sqlresults into cursor gridcursor' the data appears in the grid (but is now read only). I'd rather not have the additional select statement and a couple of the columns need to be updateable.
>
>Any Thoughts?
>
>Thanks
>Mark

This is due to the fact that the Grid is instantiated prior to the SPT being done. I assume you are doing your SPT in the form init? If so, move the SPT to the form Load, then the cursor will exist when the Grid is instantiated and the design time setting won't have to be redone.

BOb