Error on insert into

[AlessioForconi]

Hello everyone,

having this command sql

Code: Select all

put "INSERT INTO tb_godute ('fld_data', 'fld_ore', 'fld_causale') VALUES (:1, :2, :3)", miadata, ore, causale into sqlInsert
revExecuteSQL conn, sqlInsert 

miadata --> 2018-11-30
ore --> 3
causale --> ROL

I get this error

There was a problem saving this record: ner "2018": sintax error

but from what I understand SQlite accepts dates in YYYY-MM-DD format.
The data field in the database is of type text, even if you try the datetime or date type the error is the same

Where's the mistake?

[Klaus]

Buonasera Alessio,

I think the variables need to be in quotes and must not be part of the roiginal SQL statement:

Code: Select all

put "INSERT INTO tb_godute ('fld_data', 'fld_ore', 'fld_causale') VALUES (:1, :2, :3)" into sqlInsert
revExecuteSQL conn, sqlInsert, "miadata", "ore", "causale" 

If in doubt ALWAYS take a look into the dictionary!


Best

Klaus

[bangkok]

You should use the more straightforward syntax, instead of placeholders.

It will ease the debugging by allowing you to "see" exactly what is the query.

Code: Select all

put "INSERT INTO tb_godute (fld_data, fld_ore, fld_causale) VALUES ('"&miadata&"','"&ore&"','"&causale&"')" into sqlInsert
answer sqlInsert
revExecuteSQL conn, sqlInsert 
put the result into sqlResult
 if sqlResult is not a number then answer error sqlResult

[AlessioForconi]

@klaus @bangkok

Both solutions work, I got there close but I missed putting the "" in the right order.

I always look at the dictionary before writing, if only for not annoying you uselessly and to succeed on its own.

Thank you very much indeed

[Klaus]

I have my example from the dictionary!

[AlessioForconi]

I have my example from the dictionary!