MySQL Grid Problem?

[warik]

Hi, I make a MyODBC (MySQL) to write down table to grid with this code:

NumRows = SQLEXEC(myConnection, "select Mailbox from coba", 'MyCursor')
ThisForm.Grid1.RecordSource= "mycursor"

But If I modified that table value (delete or Add record), I have to refresh the grid value. To refresh the value I can not use thisform.grid1.refresh, because it have to read from MySQL server to get newest data. Well, so I have to recall the code above again to show at the same Grid.

The problem is, when I use above code for show grid for the second time, the grid event will be reset so the format for column width, header text, etc. Also the event at clik procedure or dblclick procedure will be gone.

What should I do to solve this problem?
Thank you in advance.

 

[Mike Lewis]

Warik,

The usual solution to this problem is to maintain two cursors. Use one of them as the recordsource for the grid; use the other to receive the data from the server. When you need to refresh the data, zap the first cursor and append to it all the records from the second cursor.

That way, the grid will never lose its recordsource, and the problems you mentioned won't arise.

If you would like to see some sample code for this, look at my article "Controlling grid data dynamically", at:

http://www.ml-consult.demon.co.uk/foxst-20.htm

Mike




Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[warik]

Yes Mike, you right with make a temporary cursor and copy all data to it will be keep the grid setting.

Thank you very much, your help and your link for sample is really great and it solved my problem.

 

[badukist]

Hi
You can also define a remote view based on MySQL table and execute Requery() when you want to refresh data. You will need a database container for this.