Re: [sqlite] Error:"Expression cannot be evaluated" withsqlite3_exec()

2008-10-16 Thread John Belli
On Thu, 16 Oct 2008 08:23:10 + (GMT), Alberto Tellaeche <[EMAIL PROTECTED]> wrote: >int ActualizarBBDDAlumnos(char *dni, float nota) >{ >char *errorMsg; > >char *orden_SQL = sqlite3_mprintf("update ALUMNO set nota=%0.1f where > dni=%Q;",nota,dni); >

Re: [sqlite] Error:"Expression cannot be evaluated"withsqlite3_exec()

2008-10-16 Thread Igor Tandetnik
"Alberto Tellaeche" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > after sqlite3_mprintf() function, I obtain the string like this: " > update ALUMNO set nota=0.2 where dni='12345678J' " > After sqlite3_exec() errorMsg=NULL (0x Bad ptr), and the > command is not exectuted in

Re: [sqlite] Error:"Expression cannot be evaluated" withsqlite3_exec()

2008-10-16 Thread Alberto Tellaeche
on´t understand what is happening, so, as always, thank you very much. Regards, Alberto - Mensaje original De: Igor Tandetnik <[EMAIL PROTECTED]> Para: sqlite-users@sqlite.org Enviado: miércoles, 15 de octubre, 2008 22:18:48 Asunto: Re: [sqlite] Error:"Expression cannot

Re: [sqlite] Error:"Expression cannot be evaluated" withsqlite3_exec()

2008-10-15 Thread Igor Tandetnik
Alberto Tellaeche <[EMAIL PROTECTED]> wrote: > Tank you very much for the response. > the array is as expected, sprintf is woking fine. Also I get the same > error if I write the SQL command directly in the sqlite3_exec() > function, so this is not the error... Show the CREATE TABLE statement for