[Lazarus] Master/detail relationships: what am I missing?

Reinier Olislagers reinierolislagers at gmail.com
Tue Dec 18 08:35:32 CET 2012


On 18-12-2012 3:33, John wrote:
> On 12/17/2012 09:43 PM, Reinier Olislagers wrote:
> As you are playing with Master/detail, how are you setting the parameter
> datatype in the detail SQL ?  I am finding that if I set it at design
> time (in the object inspector), that value is not restored on run, or on
> re-poening Lazarus.  I have worked around this by setting it in a
> beforeopen event on the table.
See the wiki page I linked to. No problems with that minimal approach
(Firebird embedded, FPC x86 2.6 (or possibly trunk), Laz trunk, Windows).

I do vaguely remember some issues with having to set parameter type on
PostgreSQL but haven't looked into it.

> Also, sometimes, when the master is scrolled, the detail query closes. 
> (I have put a check / repoen the detail query in an afterscroll event on
> the master query to work around this).
Haven't seen it but have made no extensive tests.
If you can reproduce, could you file a bug report?

In any case, additions to the wiki welcome - even to document
workarounds for failures that may not happen to everyone.




More information about the Lazarus mailing list