Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>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
Resetting the recordsource to '' then back to my cursor did the trick
Thanks
Mark
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement