B4A Question (SOLVED) Problem with UPDATE-DELETE and WHERE / AND SQL operators - Mahares (first post)    Oct 2, 2021   (1 reaction) DELETE you may want to use only one column in the WHERE clause to test to minimize the potential error... B4A Question SQL WHERE statement Syntax error - Declan    Nov 13, 2015 As Cursor
Curs = SQL.ExecQuery2("SELECT setpoint FROM Zones WHERE ToolName = " & MyTool & " AND WHERE Zone = " & MyZoneNum & "", Array As String... Spanish [B4XPages] jRDC2 + MySQL CRUD + Login - josejad    Feb 24, 2022   (14 reactions) 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... B4A Question Why SQL "WHERE" cannot detect column / no such column ? - MicroDrie (first post)    Jun 8, 2021 Next time I will pay more attention to these small details.š
It's kind of old school wisdom tha... B4A Question SQL WHERE clause sintax error - FERNANDO SILVEIRA (first post)    May 19, 2018   (1 reaction) 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:);)... B4A Question Where to download SQL Lib ver 1.3 & other User DLs? - Erel (first post)    Sep 18, 2016 @PhilMac please do not make duplicate posts.... B4A Question Select .. Where Date .. (RDC MySQL) - OliverA (first post)    May 28, 2018 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... Share My Creation JQuiz - API Server for B4XQuiz - aeric    May 18, 2023   (14 reactions) strSQL = strSQL & " FROM users" strSQL = strSQL & " WHERE name... " WHERE name = ?" strSQL = strSQL & " AND password = md5(?)"... strSQL = strSQL & " WHERE enabled = 1" strSQL = strSQL & " ORDER BY id... = "null" Then strSQL = strSQL & " WHERE t.enabled = 1"...(strSQL, Array As String(uid, pwd)) Else strSQL = strSQL & " WHERE t.id... B4A Question SqlCipher Where to find icudt46l.zip - DonManfred (first post)    Apr 12, 2018   (1 reaction) The question in this thread is answered.
For any new question you should create a new thread.... B4A Question Use Variable in SQL Where Clause - Startup (first post)    Dec 29, 2015 or use the .ExecQuery2 method ..
Cursor1=SQL1.ExecQuery2("SELECT number from testtable where word = ?",Array As String(wordselect))
That does it. Thanks!... Page: 1   2   3   4   5   6   7   |