Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

2007-04-20 Thread Dennis Cote
David A O L wrote: Im using 3.3.13, I will like if you can show a little snipped of how to go with something like the next.. (The following at sqlite prompt) create table some(xthing varchar, count integer); insert into some values("hi", 0); insert into some values("hi there", 0); update some

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

2007-04-20 Thread David A O L
Use sqlite3_libversion(). See http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details. Im using 3.3.13, I will like if you can show a little snipped of how to go with something like the next.. (The following at sqlite prompt) create table some(xthing varchar, count integer); insert i

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

2007-04-20 Thread Dennis Cote
David A O L wrote: That mean Im using sqlite version 2?? (Because it say database locked). Like I know I have here sqlite3 I will search the way to print the version of the library used... David, Use sqlite3_libversion(). See http://www.sqlite.org/capi3ref.html#sqlite3_libversion for deta

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

2007-04-20 Thread David A O L
What I whant is that in // Here! I whant to update (increment, decrement, > etc). > > But it say that the DB is locked... With sqlite v2, yes. If you were using sqlite v3 you could do the UPDATE in the SELECT callback. That mean Im using sqlite version 2?? (Because it say database locked). Like

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

2007-04-19 Thread Dan Kennedy
On Thu, 2007-04-19 at 13:29 -0500, David A O L wrote: > I have a very basic sql statement, mainly Im printing it... > > static int GuardaActividadEnArchivo(void *arg1, int argc, char **argv, char > **azColName){ > int i; > char *nombre, *ok, *ko, *actividad; > nombre = ok = ko = activi

[sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

2007-04-19 Thread David A O L
I have a very basic sql statement, mainly Im printing it... static int GuardaActividadEnArchivo(void *arg1, int argc, char **argv, char **azColName){ int i; char *nombre, *ok, *ko, *actividad; nombre = ok = ko = actividad = 0; for (i = 0; i < argc; i++) { printf("%s = %s ", azC