hello, I am facing a very bizarre issue. I am on mac os x 64 bits.
I needed a uuid() function that generates GUID. I created then a dll with Qt like: #include "/usr/local/include/sqlite3ext.h" SQLITE_EXTENSION_INIT1 #include <QtCore/QUuid> #include <string.h> extern "C" void sqlite3_uuid(sqlite3_context *context, int argc, sqlite3_value **argv){ QUuid uuid = QUuid::createUuid(); QString s = uuid; s.remove(0,1); s.remove(s.size()-1,1); QByteArray to_utf8 = s.toAscii(); sqlite3_result_text( context, to_utf8.constData(), -1, SQLITE_TRANSIENT ); } extern "C" int sqlite3_extension_init( sqlite3 *db, char **pzErrMsg, const sqlite3_api_routines *pApi ){ SQLITE_EXTENSION_INIT2(pApi) sqlite3_create_function(db, "uuid", 0, SQLITE_UTF8, 0, sqlite3_uuid, 0, 0); return 0; } I compiled Qt with cocoa then after when I run a script, only in a shell, when I first try to insert a GUID, it says that the primary key already exists, which is obviously wrong. However, this error occurs only in a shell script, not in the command line (unbelievable!). I could only fallback to use uuid from boost and it works perfectly. Is it safe to use Qt to implement a dll for creating user functions? Do you have any idea on what happens here? (any hints?) I have no idea how to narrow down the problem, is someone interested to investigate? if yes I can build a minimal project (and try to reproduce the same issue) Any hints are warmly welcome. Best regards, Sylvain _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users