>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.