Search found 3 matches

by thecoder
02.01.2012, 14:32
Forum: MySQL
Topic: TZQuery update adding where clause to sql statement
Replies: 4
Views: 3522

Can anyone tell me the best way to update data in mysql, since the above does not work.

Thanks
by thecoder
01.01.2012, 03:37
Forum: MySQL
Topic: TZQuery update adding where clause to sql statement
Replies: 4
Views: 3522

Hi,

Yes, I get the same result. I cannot imagine where the extra where clause is coming from.

The date one is already in that format.
Ta
by thecoder
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...