[sqlite] sqlite3_create_function function name when called?

2007-06-12 Thread Omar Eljumaily
When you create a function with sqlite3_create_function, the callback function is something like: myFunc(sqlite3_context *context, int argc, sqlite3_value **argv) { } Is it possible to get the name of the function that the callback was called because of? I want to write just one callback

Re: [sqlite] Why does "SELECT julianday('some_date') AS dateNumber" get me a string via ODBC?

2007-06-05 Thread Omar Eljumaily
I believe ODBC will do type conversions for you. If not, use sscanf. All sqlite data is stored as strings, I believe, anyway, so there's lots of type conversion going whether it's explicit or not. Representing dates as floating point numbers can be tricky because of subtle rounding issues,

Re: [sqlite] Re: Dropping updates after exiting application

2007-06-04 Thread Omar Eljumaily
at this point, so don't try anything important with it. Thanks, Omar Igor Tandetnik wrote: Will Leshner <[EMAIL PROTECTED]> wrote: On 6/4/07, Omar Eljumaily wrote: qlite3_prepare_v2(con->_db, text.c_str(), text.size(), &_stmt, ); sqlite3_bind_text(_stmt, which, s.c_

Re: [sqlite] Re: Dropping updates after exiting application

2007-06-04 Thread Omar Eljumaily
Igor Tandetnik wrote: Do you, by any chance, begin a transaction, perform the updates, then close the DB connection without committing the transaction (e.g. when exiting the app)? If you do this or something similar, the transaction gets rolled back. Igor Tandetnik This is what I have

[sqlite] Dropping updates after exiting application

2007-06-04 Thread Omar Eljumaily
I have this problem where my application is is dropping updates after exiting my application. create mytable { int id primary key, name text }; Something like: "insert into mytable(name) values('myname')" would update properly. However "update mytable set name = 'newname' where id = 1"