Hi Vivien, > Note: if I create that query without 'analize_time' and the > > "datetime('now')" part, I got the query committed in the database, after > > parameter setting of course.. > > What's going wrong? > > I guess there is a bug in the gda-query-parsing.c file or in the > SQLite provider. Would it be possible for you to send me a complete > sample (source file + dictionary file) so I can reproduce the problem > here? > > Regards, > > Vivien > here it is the test case with the tables.sql used to create de db. I don't use a dictionary The test case comes from an Anjuta's plugin I'm coding so I tried to clean it from foreign code making it simpler to compile. I'm using latest libgda 3.0 from svn. giving something like gcc main.c `pkg-config libgda-3.0 --libs` `pkg-config libgda-3.0 --cflags` `pkg-config glib --libs` -o main should lead to a clean compile but probably I'm wrong. Anyway the dependences are glib and libgda only. Last but not the least: please set the TABLES_SQL and PRJ_DIRECTORY to your settings. Be sure that prj_directoy exists, or create it. The 'wrong behaviour' happens on db_engine_add_new_workspace (), in particular the 2nd and 3rd queries are executed with errors. thanks and regards, Massimo -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Vinci Pedigree!Entra in Club Doglovers e gioca subito in palio tanti premi Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6311&d=20070324
Attachment:
test_case.tar.bz2
Description: application/bzip