Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Regenerate a Grid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01233274
Message ID:
01233288
Vues:
9
>>Hi!
>>
>>How to re-generate (re poblate) a Grid that use a cursor previously?...
>>
>>When trying to repoblate Grid (with the regenerated cursor) , it Grid loose the columns references...
>>
>>Thanks in advance
>>Carlos Burgos
>
>Carlos,
>There are several ways:
>1. Redefine whole your grid AFTER your second select:
>
>thisform.Grid1.RecordSource = NULL
>SELECT ....
>       INTO CURSOR Test READWRITE
>thisform.Grid1.RecordSource = [Test]
>thisform.Grid1.Colum1.ControlSource - [Test.Field1]
>....
>
>
>2. Create a cursor, bind the grid on it and when you need to change the data just ZAP it and then select the records in it:
>
>SELECT MyGridCursor
>ZAP
>INSERT INTO MyGridCursor;
>SELECT ......
>
>
>3. use CursorAdapter with dynamic WHERE clause and just CursorRefresh() it :-)

I vote for the number 3 :) and 2.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform