Treeview doesnt refresh upon reopenning window

[Jason Brisbane <darkeen westnet com au>]

Hello All,

I am looking for a fix for a Treeview issue that I am having.

I have created a Treeview that gets its data from a database and 
populates the list with the results of the database.
This works well as even if the database table was empty (rows=0) then it 
still displays the headers (better than I thought).

In my example, I have a treeview on one half of the screen and the 
database fields showing the data on the right (table). This shows the 
data just wonderfully.
If I add a record, or conversely if I select a record and delete it, the 
treeview doesnt get updated.
I am calling the _show function after each time, but I dont believe that 
the gtk_destroy_treeview is actually doing its job. Surely it would kill 
the treeview, model, store, and everything with it when you kill it?

Here is the "_show" code. Of course this works fine on starting the 
window the first time but doesnt refresh.
I get the following message when the window tries to update:
(battlemaster:11819): Gtk-CRITICAL **: gtk_scrolled_window_add: 
assertion `bin->child == NULL' failed

PS: Do I need to g_free/g_object_unref the list_store or other objects 
before returning?


Thanks in advance.
----
void
on_monstertype_show                    (GtkWidget *widget, gpointer 
user_data)
{
gchar   *sql;
MYSQL   *conx;
MYSQL_RES *result_set;
MYSQL_ROW db_row;
MYSQL_FIELD *field;
GtkListStore *list_store;
GtkTreeModel *model;
GtkTreeIter iter;
GtkWidget *view;
GtkCellRenderer *renderer; 
GtkTreeSelection  *selection;

gtk_widget_destroy(lookup_widget(widget, "treeview4"));
/* First, connect to the database. */
conx = mysql_init(0L);
if (conx != 0L)
{
  conx = mysql_real_connect(conx, LOCALHOST, USER, PASS, DBASE,0,0L,0);
  if (conx != 0L)
  {
   sql = g_strconcat("select monsterid, creaturetype from monstertype ; 
", 0L);
   if (mysql_query (conx, sql) == 0)
   {
   result_set = mysql_store_result (conx);
   // CREATE THE TREE_VIEW and hook the row selection event into it!
   view = gtk_tree_view_new();
   selection = gtk_tree_view_get_selection(GTK_TREE_VIEW(view));
   gtk_tree_selection_set_select_function(selection, mt_selection_func, 
NULL, NULL);
   // CREATE COLUMN HEADERS
   // -- Column 1 --
   renderer = gtk_cell_renderer_text_new();
   gtk_tree_view_insert_column_with_attributes(GTK_TREE_VIEW(view), -1, 
"ID", renderer, "text",
        COLUMN_ONE, NULL);
   // -- Column 2 --
   renderer = gtk_cell_renderer_text_new();
   gtk_tree_view_insert_column_with_attributes(GTK_TREE_VIEW(view), -1, 
"Type",   
        renderer, "text", COLUMN_TWO, NULL);
   // Now Fill with the Data
   list_store = gtk_list_store_new (2,G_TYPE_STRING, G_TYPE_STRING);
   // ADD ONE ROW FOR EACH MYSQL ROW RETRIEVED
   while ((db_row = mysql_fetch_row (result_set)) != 0L)
   {
      // Display the Columns in the gtkListstore
      gtk_list_store_append (list_store, &iter);
      gtk_list_store_set (list_store, &iter,
           COLUMN_ID, db_row[0],
           COLUMN_LOCATION, db_row[1],
           -1 );
   }
   model = GTK_TREE_MODEL(list_store);
   gtk_tree_view_set_model (GTK_TREE_VIEW(view), model);
   g_object_unref (model);
   gtk_container_add (GTK_CONTAINER(lookup_widget(widget, 
"scrolledwindow4")), view);
   gtk_widget_show_all(widget);
   mysql_close(conx);
  }
 }
}
}


--
Regards,

Jason Brisbane