How to change AUTO-QUERY!?
Posted: 24.03.2018, 19:40
When I save changes ZQuery sends AUTO-QUERY. For example:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I delete a record in the table and save it.(ZQuery1.Post, ZQuery1.ApplyUpdates)
Then ZQuery generates AUTO-QUERY and sends it to the mysql server. It may be (" DELETE FROM students.`ИС-15-2` WHERE `a`= 1 ... ")
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
That's automatically! And I need to add "LIMIT 1" on the end of AUTO-query.(" DELETE FROM students.`ИС-15-2` WHERE `a`= 1 ... LIMIT 1")
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I delete a record in the table and save it.(ZQuery1.Post, ZQuery1.ApplyUpdates)
Then ZQuery generates AUTO-QUERY and sends it to the mysql server. It may be (" DELETE FROM students.`ИС-15-2` WHERE `a`= 1 ... ")
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
That's automatically! And I need to add "LIMIT 1" on the end of AUTO-query.(" DELETE FROM students.`ИС-15-2` WHERE `a`= 1 ... LIMIT 1")