Android Question SQLite Exception near "00"

Espinosa4 · Jun 17, 2015

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!

B4X:

        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 · Jun 17, 2015

Try:

B4X:

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

sorex · Jun 17, 2015

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

LucaMs · Jun 17, 2015

sorex said:
@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 · Jun 17, 2015

LucaMs said:

Try:

B4X:

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 · Jun 17, 2015

LucaMs said:
and the field starting with S are... string?

Yessss.

Espinosa4 · Jun 17, 2015

sorex said:
@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 · Jun 17, 2015

cool, you need to encapsulate string in single quotes.

B4X:

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 · Jun 17, 2015

sorex said:
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 · Jun 18, 2015

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

Android Question SQLite Exception near "00"

Espinosa4

Active Member

LucaMs

Expert

sorex

Expert

LucaMs

Expert

Espinosa4

Active Member

Espinosa4

Active Member

Espinosa4

Active Member

sorex

Expert

LucaMs

Expert

sorex

Expert

Similar Threads

Android Question SQLite Exception near "00"

Active Member

Expert

Expert

Expert

Active Member

Active Member

Active Member

Expert

Expert

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency