Search found 4 matches

by wat4dog
19.12.2011, 19:20
Forum: 6.6 - stable
Topic: How can I filter ZQuery by multiple fields?
Replies: 6
Views: 1080

use ZTable then instead of ZQuery maybe? I think it's not good idea, when I need to join more than 2 tables :) Hard to imaginate... :shock: So, I've just made checking on "param value changed", also, made small delay after user press key in search field: so, I actually refresh query after...
by wat4dog
19.12.2011, 15:35
Forum: 6.6 - stable
Topic: How can I filter ZQuery by multiple fields?
Replies: 6
Views: 1080

But it's working worse than filter... So, I need to filter results on user typing... Like "search on the fly" And REFRESH query every time is not good because there is so many records in tables. I think better to filter records locally than refresh every user "Key press". I'm hop...
by wat4dog
19.12.2011, 14:59
Forum: 6.6 - stable
Topic: How can I filter ZQuery by multiple fields?
Replies: 6
Views: 1080

Oh :) cool! You've opened my eyes LOL ;)
Thanks a lot!

PS: all ingenious is simple! :)
by wat4dog
19.12.2011, 14:32
Forum: 6.6 - stable
Topic: How can I filter ZQuery by multiple fields?
Replies: 6
Views: 1080

How can I filter ZQuery by multiple fields?

Hi ALL :) I'm trying to merge old Delphi app from BDE+MySQLODBC to Zeos. I have a complicated query which joins few tables: SELECT *, bodyType(cars.id) as `class` from cars LEFT JOIN clients ON cars.client_id = clients.id LEFT JOIN models ON cars.model_id=models.id LEFT JOIN engine_types ON cars.eng...