Can anyone tell me the best way to update data in mysql, since the above does not work.
Thanks
Search found 3 matches
- 02.01.2012, 14:32
- Forum: MySQL
- Topic: TZQuery update adding where clause to sql statement
- Replies: 4
- Views: 3522
- 01.01.2012, 03:37
- Forum: MySQL
- Topic: TZQuery update adding where clause to sql statement
- Replies: 4
- Views: 3522
- 31.12.2011, 18:05
- Forum: MySQL
- Topic: TZQuery update adding where clause to sql statement
- Replies: 4
- Views: 3522
TZQuery update adding where clause to sql statement
Please help. I am using zeoslib 6.6.6 Mysql & Delphi. When I try to update a database table using TZQuery object, with the following simple code, no updates happen. Upon checking the TZSQLMonitor log, I noticed that additional ' WHERE logincnt=0 AND entrydate IS NULL ' clauses are being added as...