Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Regenerate a Grid
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01233274
Message ID:
01233290
Views:
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.


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.
Previous
Reply
Map
View

Click here to load this message in the networking platform