Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grids and SPT
Message
De
04/12/1999 11:05:41
 
 
À
04/12/1999 11:02:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00298661
Message ID:
00298667
Vues:
12
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform