bogdanc Active Member Licensed User Longtime User Feb 25, 2016 #1 Hi I trying executing a query: Code: 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.
Hi I trying executing a query: Code: 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.
Siam Active Member Licensed User Longtime User Feb 25, 2016 #2 hi remove ticket and the empty value from your query. andy Upvote 0
bogdanc Active Member Licensed User Longtime User Feb 25, 2016 #3 Siam said: hi remove ticket and the empty value from your query. andy Click to expand... Thank You. Upvote 0
