Android Question Insert into

[Peekay]

I have this query in my config.properties file :

sql.Menu7_Insert=INSERT INTO sitemessages (senderandroidid, receiverandroidid, message, thisdatetime,) VALUES(?,?,?,?) ;

The parameters (defined as 'dim params(4) as string' and error are as per picture:

What can be the problem?

Thanks
PK

 

[josejad]

How are defined the params in the database?
You have an extra comma after "thisdatetime" I think.

 

[Peekay]

The params are defined in the code as they are without apostrophes, like params(3)=txtEdit.text

PK

 

[Alexander Stolte]

there is a comma at the end.

 

[Mahares]

That was answered by Jose in post#2

 

[Alexander Stolte]

That was answered by Jose in post#2

but it didn't look like the thread owner noticed.

 

[Peekay]

How are defined the params in the database?
You have an extra comma after "thisdatetime" I think.

Sorry, I did not notice.
PK.

 

[josejad]

Sorry, I did not notice.

So... is it working without the comma? How are defined the fields in the mysql database? Not in B4A

 

[Peekay]

It is working now thx everybody.