Android Question SQLite Insert Question

[AndyChang]

I try to Insert an Text Variable (item number) into SQLite.

I use two types of way to INSERT data

1. SQL1.ExecNonQuery2("INSERT INTO " & TableName & " VALUES (?,?)", Array As String(1, "itemNBR"))

2. SQL1.ExecNonQuery("INSERT INTO " & TableName & " VALUES (Null, 'itemNBR')")

I got the same results. The data which store in Sqlite is the String “itemNBR”. But I need "FMAS-2101".

What’s wrong with my code?

Andy

 

[DonManfred]

The data which store in Sqlite is the String “itemNBR”. But I need "FMAS-2101".

Why are you using itemNBR then?

SQL1.ExecNonQuery2("INSERT INTO " & TableName & " VALUES (?,?)", Array As String(1, "itemNBR"))

You are giving the values to insert in the Array As String... In this case 1 for the id and itemNBR for the string....

 

[DonManfred]

I suggest to use a structure like

SQL1.ExecNonQuery2("INSERT INTO " & TableName & " SET idfield=?, stringfield=?;", Array As String(1, "itemNBR"))
' Set 1 into the field idfield, itemNBR into the field stringfield

 

[AndyChang]

Dear Manfred,
Thanks a lot for your so quick response to my problem.
I change the code as shown in the my attached png. It can't pass the compile stage. Error message as attached png.
Andy

 

[Erel]

Please post the code and the error message as text. Right click on the logs to copy it.

 

[AndyChang]

I right click on the logs and choose "copy all to clipboard".
Then how can I get the Log file.
Andy

 

[AndyChang]

Dear Erel
I meant where to get the log file. Where is the clipboard.
Andy

 

[klaus]

I suppose that itemNBR is a variable.
So, remove the double quotes around itemNBR and replace String by Object, it should be:
SQL1.ExecNonQuery2("INSERT INTO " & TableName & " VALUES (?,?)", Array As Object(1, itemNBR))

 

[AndyChang]

Dear Klaus
It works very well. Thanks you so much.
Andy