Android Question SQLite Exception near "00"

[Espinosa4]

Hi!

I need to insert in the same record differents values. some of them are null values. The programa give me a syntax error (Code1).

Can you help me please?
Thank you!

        Campos = "NumServicio,TToma,TDeje,TJornada,SLinea,TNocturnas,SObservaciones,SCorrespondencia,Grupo,Actualizado,Peculiar,Fecha"
        sSQLViejos.ExecNonQuery("INSERT INTO ServOrdinarios ("&Campos&") VALUES("&Serv&","&Tom&","&Dej&","&Jor&","&Lin&","&Noc&","&Obs&","&Cor&","&Gru&","&act&","&Pec&","&Fec&")")

 

[LucaMs]

Try:

sSQLViejos.ExecNonQuery2("INSERT INTO ServOrdinarios (" & Campos & ") VALUES(?,?,?,?,?,?,?,?,?,?,?,?)", Array As String(Serv, Tom, Dej, Jor, Lin, Noc, Obs, Cor, Gru, act, Pec, Fec))

 

[sorex]

@Espinosa4 : you didn't mention if these are numeric or text field. are the fields starting withT text fields?

 

[LucaMs]

@Espinosa4 : you didn't mention if these are numeric or text field. are the fields starting withT text fields?

and the field starting with S are... string?

 

[Espinosa4]

Try:

sSQLViejos.ExecNonQuery2("INSERT INTO ServOrdinarios (" & Campos & ") VALUES(?,?,?,?,?,?,?,?,?,?,?,?)", Array As String(Serv, Tom, Dej, Jor, Lin, Noc, Obs, Cor, Gru, act, Pec, Fec))

Thank very very much indeed LucaMs! It works perfectly!!

Cheers

 

[Espinosa4]

and the field starting with S are... string?

Yessss.

 

[Espinosa4]

@Espinosa4 : you didn't mention if these are numeric or text field. are the fields starting withT text fields?

Hi sorex,
All are string but in those cases where I need to know speedy what I was stored, the field starts with S for string, t for time, etc...

The problem is the null values. But LucaMs resolved my problem.

Cheers

 

[sorex]

cool, you need to encapsulate string in single quotes.

sSQLViejos.ExecNonQuery("INSERT INTO ServOrdinarios ("&Campos&") VALUES("&Serv&",'"&Tom&"','"&Dej&"','"&Jor&"',"&Lin&","&Noc&","&Obs&","&Cor&","&Gru&","&act&","&Pec&","&Fec&")")

(I didn't change all of them so copy pasting might still give errors )

 

[LucaMs]

cool, you need to encapsulate string in single quotes.

ExecNonQuery2 solve this problem (and in this way you do not have to fight with the quotes)

 

[sorex]

I know but I prefer the other method for debugging reasons.