Hello Jan, nice to return here
The info you provided sounds very promising, at least I'll have a direction to dig into. I'll try to look into things.
Thanks for help!
Would be nice if Zeos supported INSERT...RETURNING clause for queries linked to datasets and visual components. For support I mean executing INSERT statement as selectable query and copying the returned values to current row cache. I'd wish to implement it myself but Zeos structure with its interfac...
Under some conditions cursor for detail DS may jump on master refresh. I catched it with the following scheme: Master: TZTable, Detail: TZQuery, DetailGrid: TDBGridEh (a grid from EhLib, version 3.6) connected to Detail. Now if we execute Master.Refresh, the cursor for Detail jumps downward. This ha...
So it's "by design"... I was very surprised with this behavior. With BDE I've never bored about master-detail under-the-carpet techniques. Actually this phrase in the article: This is the default behaviour of a BDE TTable component. ... With client sided filters both DataSets first tran...
There's a problem in TZGenericCachedResolver.DefineWhereKeyColumns when the current table is actually a VIEW. Currently the procedure tries to get primary keys by DatabaseMetadata.GetPrimaryKeys(%view_name%) but obviously fails because the key actually belongs to a table not to a view. So the wmWher...
First of all, thank you guys for your work, I'm currently migrating from BDE and Zeos seems very easy to migrate to. But I noticed that if I use 2 TZTables for master-detail via MasterSource/MasterField/LinkedField the detail TZTable selects ALL records from the DB table. Is it really desired behavi...