Search found 263 matches

by Fr0sT
30.08.2017, 13:26
Forum: ZeosLib 7.2 Forum
Topic: [Request] Support INSERT...RETURNING transparently
Replies: 7
Views: 968

Re: [Request] Support INSERT...RETURNING transparently

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!
by Fr0sT
15.08.2017, 13:30
Forum: ZeosLib 7.2 Forum
Topic: [Request] Support INSERT...RETURNING transparently
Replies: 7
Views: 968

[Request] Support INSERT...RETURNING transparently

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...
by Fr0sT
05.08.2016, 09:54
Forum: ZeosLib 7.2 Forum
Topic: SQL statment at TzUpdatesql is not getting saved when adding new field
Replies: 5
Views: 961

Re: SQL statment at TzUpdatesql is not getting saved when adding new field

Fixed. Info Diff: src/component/ZUpdateSqlEditor.pas | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/src/component/ZUpdateSqlEditor.pas b/src/component/ZUpdateSqlEditor.pas index f6453db..160eb8b 100644 --- a/src/component/ZUpdateSqlEditor.pas +++ b/src/component/ZUpdate...
by Fr0sT
01.08.2014, 15:38
Forum: ZeosLib 7.2 Forum
Topic: Cursor jumps in detail DS on master refresh (w/fix)
Replies: 7
Views: 1608

Cursor jumps in detail DS on master refresh (w/fix)

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...
by Fr0sT
15.05.2014, 13:00
Forum: ZeosLib 7.1 stable Forum
Topic: Master-Detail with TZTable - selects all records
Replies: 2
Views: 1445

Re: Master-Detail with TZTable - selects all records

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...
by Fr0sT
15.05.2014, 12:38
Forum: ZeosLib 7.1 stable Forum
Topic: wmWhereKeyOnly fails for VIEWs
Replies: 1
Views: 2017

wmWhereKeyOnly fails for VIEWs

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...
by Fr0sT
08.05.2014, 12:24
Forum: ZeosLib 7.1 stable Forum
Topic: Master-Detail with TZTable - selects all records
Replies: 2
Views: 1445

Master-Detail with TZTable - selects all records

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...