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
_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list
