[gnome-db] Problem with 2.99.5
- From: Phil Longstaff <plongstaff rogers com>
- To: gnome-db-list <gnome-db-list gnome org>
- Subject: [gnome-db] Problem with 2.99.5
- Date: Wed, 14 Feb 2007 04:11:34 -0800 (PST)
I downloaded the 2.99.5 tarball and built and installed it. I'm now having problems with it.
OS: SuSE 10.2
libgda: 2.99.5 built with --prefix= and --enable-debug
mysql: 5.0.26
The following section of code:
{
GdaQuery* query;
GdaQueryTarget* target;
GdaQueryField* allFields;
/* SELECT */
query = gda_query_new( be->pDict );
gda_query_set_query_type( query, GDA_QUERY_TYPE_SELECT );
/* FROM */
target =
gda_query_target_new( query, table_name );
gda_query_add_target( query, target, NULL );
g_object_unref( G_OBJECT(target) );
/* all fields */
allFields = gda_query_field_all_new( query, table_name );
gda_query_field_set_visible( allFields, TRUE );
gda_entity_add_field( GDA_ENTITY(query), GDA_ENTITY_FIELD(allFields) );
g_object_unref( G_OBJECT(allFields) );
return query;
}
followed by:
{
GError* error = NULL;
GdaObject* ret;
ret = gda_query_execute(
query, NULL, FALSE, &error );
if( error != NULL ) {
printf( "SQL error: %s\n", error->message );
}
return ret;
}
now produces this output:
FAMOpen failed, FAMErrno=0
[;31;1mImplementation missing: database_constraints_update_list() in gda-dict-database.c line 1214
[;31;1mImplementation missing: database_constraints_update_list() in gda-dict-database.c line 1214
COMMAND> SELECT t1.* FROM lots AS t1 (Provider MySQL on cnx 0x840cb30)
EVENT> ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM lots AS t1' at line 1 (on cnx 0x840cb30)
SQL error: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'FROM lots AS t1' at line 1
COMMAND> SELECT t1.* FROM budgets AS t1 (Provider MySQL on cnx 0x840cb30)
EVENT> ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM budgets AS t1' at line 1 (on cnx 0x840cb30)
SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM budgets AS t1' at line 1
I did not get this behavior with earlier versions of libgda.
Phil
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]