Re: [sqlite] After sqlite3_create_function, calling function returns no such function

2008-02-05 Thread Igor Tandetnik
Joe Cosby [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] rc = sqlite3_create_function16(db, LTimeToHms, 1, SQLITE_ANY, NULL, sqliteTimeToHms, NULL, NULL); Which returns SQLITE_OK, then later I have this query wstring testSql = L select TimeToHms(time) L from meta_data_master L

[sqlite] After sqlite3_create_function, calling function returns no such function

2008-02-04 Thread Joe Cosby
I can't spot what I'm doing wrong here, maybe somebody else can see it ... I define a function: static void sqliteTimeToHms(sqlite3_context *context, int argc, sqlite3_value **argv) { sqlite3_result_text(context, 0:00:00, 8, NULL); } Then call rc = sqlite3_create_function16(db,