Re: libgnomedb3.0: WARNING **: could expand "" into list of field

[paragasu <paragasu gmail com>]

i am sorry, maybe this email should go to gnome-db list. but, i can
help but to continue use this thread for this time.

But i come accross another problem. It compile, but now give critical error.
I try to check what is wrong and tried to search using google but
return no result. so,
again i have to ask this list to guide me the direction. Anything i
miss here, i look at the
code many times but i cannot spot the problem.

thank you again..

CRITICAL **: gda_parameter_list_find_param: assertion
`GDA_IS_PARAMETER_LIST (paramlist)` failed
CRITICAL **: gda_parameter_restrict_values: assertion
`GDA_IS_PARAMETER (param)` failed

here is the code

[code]
/*notebook page 1*/
GtkWidget *page_1(GdaConnection *conn)
{
	GtkWidget *vbox;
	GdaQuery *query;
	GdaDict *dict = gda_dict_new();
	gda_dict_set_connection(dict, conn);

	query = gda_query_new_from_sql(dict, "SELECT acc_id, name, ic, tel
FROM account", NULL);
	GdaDataModel *acc_list_model = gda_data_model_query_new(query);
	g_object_unref(query);
	
	query = gda_query_new_from_sql(dict,"SELECT acc_id, name, ic from
account WHERE acc_id=##/*name=:'accountNo' type:gint*/",NULL);
	GdaDataModel *payment_model = gda_data_model_query_new(query);
	g_object_unref(query);

	GdaParameterList *params =
gda_data_model_query_get_parameter_list(GDA_DATA_MODEL_QUERY(payment_model));
	GdaParameter *param = gda_parameter_list_find_param(params, "accountNo");
	g_assert(gda_parameter_restrict_values(param, acc_list_model, 0, NULL));
	

    	GtkWidget *grid = gnome_db_raw_grid_new(acc_list_model);
	GtkWidget *form = gnome_db_raw_form_new(payment_model);
	
	gtk_box_pack_start(GTK_BOX(vbox), grid, FALSE, FALSE, 3);
	gtk_container_add(GTK_CONTAINER(vbox), form);

	return vbox;
}
[/code]

p/s: i did try to download V4-branch, but have some problem compiling
it. some of dependencies is missing on my debian lenny. i will try
again..

On 9/1/08, Vivien Malerba <vmalerba gmail com> wrote:
> 2008/9/1 paragasu <paragasu gmail com>:
>> i am very new into this gtk and libgnomedb. this is my first attempt
>
> Please post to the Gnome-Db list if your post is about Gnome-DB.
>
>> write one, i have one
>> function.
>>
>> [snip]
>> GtkWidget *page_1(GdaConnection *conn)
>> {
>>        GtkWidget *vbox;
>>        GdaQuery *query;
>>        GdaDict *dict = gda_dict_new();
>>        gda_dict_set_connection(dict, conn);
>>
>>        query = gda_query_new_from_sql(dict, "SELECT * FROM account",
>> NULL);
>>        GdaDataModel *acc_list_model = gda_data_model_query_new(query);
>>        g_object_unref(query);
>>
>>        query = gda_query_new_from_sql(dict,
>>                        "SELECT * from account"
>>                        "WHERE acc_id=##/*name=:'acc_id' type:gint
>> descr:'account id'*/",
>>                        NULL);
>>
>>        GdaDataModel *payment_model = gda_data_model_query_new(query);
>>        g_object_unref(query);
>>
>>        GdaParameterList *params =
>> gda_data_model_query_get_parameter_list(GDA_DATA_MODEL_QUERY(payment_model));
>>        GdaParameter *param = gda_parameter_list_find_param(params,
>> "acc_id");
>>
>>
>>    GtkWidget *grid = gnome_db_raw_grid_new(acc_list_model);
>>        GtkWidget *form = gnome_db_raw_form_new(payment_model);
>>
>>        gtk_box_pack_start(GTK_BOX(vbox), grid, FALSE, FALSE, 3);
>>        gtk_container_add(GTK_CONTAINER(vbox), form);
>>
>>        return vbox;
>> }
>>
>> [/snip]
>>
>> the code compile well. except it give up warning  and segmentation fault.
>>
>> WARNING **: could  expand 'account.*' into list of fields
>
> The (hidden and not obvious) reason is that the dictionary you use is
> not up to date with the database structure, and specifically it knows
> nothing about the "account" table. To solve this you can either make
> sure the dictionary is up to date (use
> gda_dict_update_dbms_meta_data()), or you can simlply re-write your
> code and replace the '*' from "SELECT *..."  with the actual fields to
> select.
>
> BTW, if you are starting with the library on new code, I strongly
> encourage you to use the last 3.99.x version as its API is far easier
> to use and less buggy (the only disadvantage is that the API is not
> yet stable but mostly).
>
> Regards,
>
> Vivien
>