>I have a grid control that I would like to display the contents of a single table. This table gets over-written through an odbc call to mysql. The table structure may not be the same twice in a row. How do I get the grid to dynamically refresh without knowing what the table structure will look like?
>
>Any ideas would be greatly appreciated...
>
>Thanks in advance-
>
>Tom Welch
Hi Tom,
Yiu can get the necessary info about the table structure with FCOUNT() and FIELD() functions. Then you can readjust the number of columns in the grid, and reassign RecordSource and column ControlSourses as necessary.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison