Android Question MYSQL update with VARIABLE

[Samo]

Hello,
Can you please help me with MYSQL problem.
I am using MAriaDB library and B4A latest version

This is working:
'MySQLConnection.AddNonQueryToBatch ("UPDATE `promet` SET `datum` = '2017-01-16' WHERE `promet`.`ime` = 'JON DOE' AND `promet`.`datum` = '2017-05-14'")


When i try to use variable vime not working.

Dim vime As String
vime = "JON DOE"

MySQLConnection.AddNonQueryToBatch ("UPDATE `promet` SET `datum` = '2017-01-16' WHERE `promet`.`ime` =" .vime. "AND `promet`.`datum` = '2017-05-20'"")
MySQLConnection.ExecuteNonQueryBatch("updatepromet")

 

[ronell]

MySQLConnection.AddNonQueryToBatch ("UPDATE `promet` SET `datum` = '2017-01-16' WHERE `promet`.`ime` = " &vime& " AND `promet`.`datum` = '2017-05-20'")

try to remove the dot

 

[Samo]

Not working.
" &vime& "
also without the dot.

 

[ronell]

did you remove the last quotation mark? i edit the code sample at post #2 .. try it again

 

[DonManfred]

=" .vime. "

B4A is not PHP.

If you want to concenate strings you should use & or better directly use the Smart String Literal.

 

[Samo]

Yes i remove it.

    MySQLConnection.AddNonQueryToBatch ("UPDATE `promet` SET `datum` = '2017-01-21' WHERE `promet`.`ime` =" &vime& "AND `promet`.`datum` = '2017-05-20'")

 

[ronell]

&vime& " AND `

put spacing after vime

edit:
also add apostrophe

`ime` ='" &vime& "' AND `promet`

 

[DonManfred]

put spacing after vime

exactly put a space BEFORE the AND

 

[ronell]

use logs to see the result .. if you didnt put space before the AND
the result will be = JON DOEAND

dim vime as string
vime ="JON DOE"
dim query as string
query = "UPDATE `promet` SET `datum` = '2017-01-16' WHERE `promet`.`ime` = " &vime& " AND `promet`.`datum` = '2017-05-20'"

log(query)

 

[Samo]

Same result - grrrrrr

    MySQLConnection.AddNonQueryToBatch ("UPDATE `promet` SET `datum` = '2017-01-23' WHERE `promet`.`ime` ='" &vime& "' AND `promet`.`datum` = '2017-05-20'")

    MySQLConnection.AddNonQueryToBatch ("UPDATE `promet` SET `datum` = '2017-01-23' WHERE `promet`.`ime` =" &vime& " AND `promet`.`datum` = '2017-05-20'")

 

[ronell]

what is the error? any error message, or error log

 

[Samo]

Sorry - where i can find this log? I newer used logs before.

 

[ronell]

add this line when using release to access logs

#bridgelogger: true

 

[afields]

Hello.
In what i know if you would use directly in Heidi (which is a query tool for databases) you would write:
UPDATE promet SET datum = '2017-01-16' WHERE ime = vime AND datum` = '2017-05-20'
for that i assume that:
i've got a table whose name is promet;
that that table has fields datum ( which is a string), and ime (which is the variable)
so ( i do not have that library ) but it seem to me that you would write:
"update promet set datum='2017-01-16' where ime=".vime." and datum='2017-05-20'"

 

[ronell]

"update promet set datum='2017-01-16' where ime=".vime." and datum='2017-05-20'"

that has nothing to do with b4a,

B4A is not PHP.

If you want to concenate strings you should use & or better directly use the Smart String Literal.

 

[afields]

thanks ronell!
update promet set datum='2017-01-16' where ime="& vime &" and datum='2017-05-20'"