Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Regenerate a Grid
Message
 
À
14/06/2007 16:17:01
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:
01233284
Vues:
10
This message has been marked as the solution to the initial question of the thread.
>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 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform