Search Results

DELETE you may want to use only one column in the WHERE clause to test to minimize the potential error...
link: I have a problem joining the DELETE-UPDATE-WHERE-AND operators receiving an error as in the picture...
link: Info WHERE Targa = ? AND Chilometri = ?" SQL1.ExecNonQuery2(query,Array As String(targaId...
link: I also solved it thanks to the SQL1.ExecNonQuery2. I also had to change the query (WHERE Targa...

As Cursor Curs = SQL.ExecQuery2("SELECT setpoint FROM Zones WHERE ToolName = " & MyTool & " AND WHERE Zone = " & MyZoneNum & "", Array As String...
link: remove the second WHERE...
link: use a ? where the value should be. Curs = SQL.ExecQuery("SELECT setpoint FROM Zones WHERE...

es: 1234 (almacenada en la base de datos como md5) sql.Login = SELECT * FROM B4X.users WHERE `username` = ? AND `password` = md5(?) sql.getEvents = SELECT * FROM B4X.events WHERE `month` = ? AND `id_user` = ? sql.updateEvents = UPDATE B4X.events SET `month`=?,`event_type`=?,`description`=? WHERE `id` = ? sql.deleteEvents = DELETE FROM B4X.events WHERE `id` = ? sql.addEvents = INSERT...
link: WHERE `month` = ? AND `id_user` = ? sql.getEventsAdmin = SELECT * FROM B4X.events WHERE `month`...

Next time I will pay more attention to these small details.? It's kind of old school wisdom that...
link: be accessed from other modules. . Ex: Public SQL1 As SQL Public rp As RuntimePermissions Public...
link: The Sqlite DB.DB database column CustomModule is defined as an INTEGER, not as a TEXT value. If it ...
link: The Sqlite DB.DB database column CustomModule is defined as an INTEGER, not as a TEXT value. If it h...

Tried to insert the Where clause before Order By? Haven't tried that, but now I did and it worked!! 68088 Thank you, Luca... :);):p:);)...
link: Did you try to insert the Where clause before Order By?...
link: : WHERE A.NamePerson LIKE "M%" at the end and then I get an SQL sintax error. SELECT...

production. It is based on MVC concept where it provides a web application front-end and includes php...

@PhilMac please do not make duplicate posts....
link: .... you can download latest version Here ..... SQL Library Version 1.3...
link: everyone is), that have been assembled and defined in one document. This would include the library SQL...
link: https://www.b4x.com/android/documentation.html I think latest SQL version is 1.3 and is included...

B4X.users WHERE `username` = ? AND `password` = md5(?) sql.getEvents = SELECT * FROM B4X.events WHERE...=?,`description`=?, `value` = ? WHERE `id` = ? sql.deleteEvents = DELETE FROM B4X.events WHERE `id` = ? sql... un enlace a los tutoriales en inglés. 1.- jdbcSQL Es una conexión directa desde la app al servidor SQL. Tiene algunas desventajas: - Insegura: Sería simple para un hacker obtener el usuario y la... datos Mejor rendimiento Las consultas SQL están configuradas en el servidor, lo cual es más seguro...

as md5) sql.Login = SELECT * FROM B4X.users WHERE `username` = ? AND `password` = md5(?) sql.getEvents = SELECT * FROM B4X.events WHERE `month` = ? AND `id_user` = ? sql.updateEvents = UPDATE...
link: In the first post: spoiler：sql sentences See there ！ sql.Login = SELECT * FROM B4X.users WHERE...
link: VALUES (null, ?,?) #sql.select_animal=SELECT name, image, id FROM animals WHERE id = ?; #sql...
link: =CST6CDT User=root Password=** #Java server port ServerPort=** sql.Login = SELECT * FROM B4X.users WHERE...

According to MySQL documentation (), the format should be 'YYYY-MM-DD', including the single quotes. If what you are saying '2018/05/27' works in your "direct select" test, then you need to include the single quotes with your date that your are submitting to jRDC, otherwise, you are not really doing the same thing (since you are using single quotes to delimiter your date...
link: I am using RDC for access to MySQL and it is working fine. The problem is that when I use...