Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grids & SQL cursors
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00002374
Message ID:
00002444
Vues:
30
>>Is there an easy way to make a Grid display a SQL
>>cursor???
>>
>>Tom
>I assume you mean programmatically and not from
>the command window. I've found that setting the
>grid.RecordSourceType = 3 (Query) and
>grid.RecordSource to the name of the cursor (being
>careful to have the SQL code already saved in a
>QPR file of the same name), to be effective.
>Also, have the grid.ColumnCount set to -1 to
>accept all fields.
>Is this what you were looking for? 8-)


Michael

Thanks for the response. I do not know why QPR files would be better then embedded SQL -- of course this is VFP 3 so who knows!!! My main problem is the Grid losing properties during a refresh (ie: Column widths change). I have received on tip since I wrote the message & am about to test it.

Thanks
Tom
Tom
--------------------------------
Tom O'Hare
407-299-4268 -- tom@redtile.com -- http://www.redtile.com/
Independent Programmer Using Visual FoxPro, Visual Basic & more...
Operations Manager -- Virtual FoxPro User Group (VFUG)
http://www.vfug.org/ -- tom@vfug.org
President -- Central Florida FoxPro User Group (CFFUG)
http://www.redtile.com/foxpro/
Universal Thread Most Valued Professional (MVP)
http://www.transformation.com/foxpro/
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform