>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
You may just 'push' the grid to see its recordsource by resetting the property:
Grid.Recordsource=''
Grid.Recordsource='sqlresults'
Also, you may convert any cursor from read-only to read-write on fly:
use (dbf('curReadonly')) in 0 again alias curReadwrite
use in curReadonly
select curReadwrite
etc.
Edward Pikman
Independent Consultant