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:
01233290
Vues:
7
>>>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.


Yep,
I prefer 3 :o)
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
Répondre
Fil
Voir

Click here to load this message in the networking platform