Android Question Struggling with 'Insert'

Anirban Sen

Member
Licensed User
I have a table "BetPosition" where "BetNo" is auto incremented.
I intend to insert records through user interface where information for "odds1", "odds2"..etc comes from text boxes.
I do not know how to write the statement where text boxes values gets updated to the database.
I wrote:
Sql1.ExecNonQuery ("Insert into BetPosition (Odds1, Odds2, Favourite, Amount, BetTeam) values (EditText2.Text, EditText7.Text, EditText6.Text, EditText9.Text, EditText8.Text) ")

which is not working.

Please help with the correct syntax.

Thanks in advance.
 

Attachments

  • BetPosition.JPG
    25.8 KB · Views: 323
Sort by date Sort by votes

DonManfred

Expert
Licensed User
Longtime User
Anirban Sen said:
gets updated
Click to expand...
First RULE: INSERT does NOT UPDATE anything

Try it with something like
B4X: 
Sql1.ExecNonQuery2 ("UPDATE BetPosition SET Odds1=?, Odds2=?, Favourite=?, Amount=?, BetTeam=? WHERE BetNo=?",Array As Object(EditText2.Text, EditText7.Text, EditText6.Text, EditText9.Text, EditText8.Text, idofitem) ")
where idofitem should be replaced with the id of the dataset you want to update. BetNo should replaced by the fieldname of the ID (if it is not BetNo (i used this based on your Screenshot)).

https://www.sqlite.org/lang_insert.html
https://www.sqlite.org/lang_update.html
 
Last edited:
Upvote 0

Anirban Sen

Member
Licensed User
I am sorry for the confusion. Actually, when I mentioned "updated", I meant the record to be inserted in the database. I am trying to enter a new record. Since BetNo is auto incremented, I need not insert a value for BetNo specifically.
Based on your suggestion, I have modified my INSERT statement as under:
Sql1.ExecNonQuery ("Insert into BetPosition (Odds1=?, Odds2=?, Favourite=?, Amount=?, BetTeam=?) values (EditText2.Text, EditText7.Text, EditText6.Text, EditText9.Text, EditText8.Text) ")
But this is not working.
 

Attachments

  • Mithun-Betting.zip
    172.4 KB · Views: 341
Last edited:
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
Learn the SQL language.

I posted links to the documentation above. You did not read/understand it

B4X: 
    Sql1.ExecNonQuery2("Insert into BetPosition SET Odds1=?, Odds2=?, Favourite=?, Amount=?, BetTeam=?",Array As Object(EditText2.Text, EditText7.Text, EditText6.Text, EditText9.Text, EditText8.Text))

For any new question; please create a new Thread
 
Upvote 0

Anirban Sen

Member
Licensed User
This throws following error:
Caused By : SQL(query) error or missing database.
(near "SET": syntax error (code 1): , while compiling: Insert into BetPosition SET Odds1=?, Odds2=?, Favourite=?, Amount=?, BetTeam=?)

In any case, I will try to read/ understand from the links again. Thanks for your support.
 
Upvote 0

Anirban Sen

Member
Licensed User
This is working..thank you.
Sql1.ExecNonQuery("Insert into BetPosition (Odds1, Odds2, Favourite, Amount, BetTeam) Values ('"& EditText2.Text &"', '"& EditText7.Text &"', '"& EditText6.Text &"', '"& EditText9.Text &"', '"& EditText8.Text &"')")
 
Upvote 0
You must log in or register to reply here.

Similar Threads

Y
  • Question
Android Question Unable to Perform Click on Buttons (e.g., Send, Follow) Using Accessibility Service in Third-Party Apps like WhatsApp/Instagram
Replies
0
Views
864
ykucuk
Y
  • Article
Android Code Snippet Fighting with sending HTML-content to Outlook. A simple solution for that mess...
Replies
3
Views
3K
BlueVision
  • Article
B4A Library aPOI - A wrapper for jPOI for Android - reading and writing XLS, XLSX on Android 5+
2
Replies
27
Views
15K
Tim Chapman
T
K
  • Question
Struggling with HttpUtils2 and Google API
Replies
3
Views
2K
keirS
K
W
  • Question
GetBytes Returning Negative Numbers?
Replies
2
Views
4K
wdegler
W
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…