B4J Question MySql

bogdanc

Active Member
Licensed User
Longtime User
Hi
I trying executing a query:
B4X:
sql_qurery="INSERT INTO tickets (ticket,date_time,machine_id) VALUES ("",'test string',"value test 2")"   
sql1.ExecNonQuery(sql_qurery)

where ticket is auto increment.

When I do the query manually by SQL on the server is working fine.
Is not working for me when I try to pass an empty value by my app.
I passing empty because is autoincrement.
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…