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, L"TimeToHms", 1, SQLITE_ANY, NULL, > , NULL, NULL); > > Which returns SQLITE_OK, then later I have this query > > wstring testSql = L" select TimeToHms(time)" > L" from meta_data_master" >

[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,