MYSQL. When I save my changes(ZQuery1.Post) zquery sends automatic query. For Example: I Delete one record and ZQuery creates this query automatically (" DELETE FROM `tablename` WHERE `1`=1 AND `2`='2' ") and sends this to the server.
I want to take an AUTO-QUERY and change it. For Example: add LIMIT 1 on the end (" DELETE FROM `tablename` WHERE `1`=1 AND `2`='2' LIMIT 1 ").
PLEASE!!! HELP ME!!! Every day I try to find it...
How to change AUTO-QUERY!?
-
marsupilami
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: How to change AUTO-QUERY!?
Hello fefted,
It seems like your table lacks a primary key. With Zeos you have two options at this time:
Jan
It seems like your table lacks a primary key. With Zeos you have two options at this time:
- Add a primary key to your table. Zeos will use it automatically.
- Use a TZUpdateSQL object. There you can specify your own SQL for updates, deletes and what not. There is a chapter about this in the Zeos Documentation collection
Jan