B4J Question SQL

[RobRock92]

how do I insert data from EditText with a button in the database using dbutils?

 

[Erel]

Something like:

Dim m As Map
m.Initialize
m.Put("col1", EditText1.Text)
DBUtils.InsertMaps(SQL, "Table1", Array as Object(m))

Note that if you need to insert multiple rows then you should add them to a list and insert them in a single call. It is much (100x) faster than inserting them one by one.

 

[RobRock92]

out this error in log:

InsertMaps (first query out of 1): INSERT INTO [clienti] ([Id]) VALUES (?)

 

[Erel]

This is not an error. DBUtils prints the queries in the logs.

 

[RobRock92]

ah ok, and how put this in the table?

 

[Erel]

DBUtils.InsertMaps inserts the data to the database and prints the first query to the logs. You can see how it is implemented. It is not too complicated.

 

[RobRock92]

Thanks a lot Erel

 

[RobRock92]

Erel one last thing, how do I delete a record that I have selected from a combobox?

 

[Erel]

You can add the DeleteRecord sub that I posted here (to DBUtils module): http://www.b4x.com/android/forum/th...tabases-are-now-simple.8475/page-2#post-60395

 

[RobRock92]

great, thanks Erel