Peekay Active Member Licensed User Longtime User Feb 18, 2022 #1 I have this query in my config.properties file : sql.Menu7_Insert=INSERT INTO sitemessages (senderandroidid, receiverandroidid, message, thisdatetime,) VALUES(?,?,?,?) ; Click to expand... The parameters (defined as 'dim params(4) as string' and error are as per picture: What can be the problem? Thanks PK Attachments rdc error.jpg 102.8 KB · Views: 122
I have this query in my config.properties file : sql.Menu7_Insert=INSERT INTO sitemessages (senderandroidid, receiverandroidid, message, thisdatetime,) VALUES(?,?,?,?) ; Click to expand... The parameters (defined as 'dim params(4) as string' and error are as per picture: What can be the problem? Thanks PK
josejad Expert Licensed User Longtime User Feb 18, 2022 #2 How are defined the params in the database? You have an extra comma after "thisdatetime" I think. Upvote 0
Peekay Active Member Licensed User Longtime User Feb 18, 2022 #3 The params are defined in the code as they are without apostrophes, like params(3)=txtEdit.text PK Upvote 0
Alexander Stolte Expert Licensed User Longtime User Feb 18, 2022 #4 there is a comma at the end. Upvote 2
M Mahares Expert Licensed User Longtime User Feb 18, 2022 #5 That was answered by Jose in post#2 Upvote 0
Alexander Stolte Expert Licensed User Longtime User Feb 18, 2022 #6 Mahares said: That was answered by Jose in post#2 Click to expand... but it didn't look like the thread owner noticed. Upvote 0
Mahares said: That was answered by Jose in post#2 Click to expand... but it didn't look like the thread owner noticed.
Peekay Active Member Licensed User Longtime User Feb 18, 2022 #7 José J. Aguilar said: How are defined the params in the database? You have an extra comma after "thisdatetime" I think. Click to expand... Sorry, I did not notice. PK. Upvote 0
José J. Aguilar said: How are defined the params in the database? You have an extra comma after "thisdatetime" I think. Click to expand... Sorry, I did not notice. PK.
josejad Expert Licensed User Longtime User Feb 18, 2022 #8 Peekay said: Sorry, I did not notice. Click to expand... So... is it working without the comma? How are defined the fields in the mysql database? Not in B4A Upvote 0
Peekay said: Sorry, I did not notice. Click to expand... So... is it working without the comma? How are defined the fields in the mysql database? Not in B4A
Peekay Active Member Licensed User Longtime User Feb 20, 2022 #9 It is working now thx everybody. Upvote 0