Hi Kusnardi,
please read my answer to you where I gave the solution!!! Sql select into a temporary cursor, select the cursor linked to the grid, ZAP it and append from the temporary cursor.
>Hi,
>
>I use sqlexec to retrieve record from mysql to vfp cursor. I used the cursor as recordsource in the grid. However when retrieve again from mysql to the same cursor, the grid change column and width and header. Actually I want to preserve the setting for the grid, the chages should be for the data.
>
>regards,
>Kusnardi