[fpc-pascal] Master Detail relationship in SQLdb

Michael Van Canneyt michael at freepascal.org
Fri Jul 13 17:08:57 CEST 2007

On Fri, 13 Jul 2007, Martin Schreiber wrote:

> On Thursday 12 July 2007 16.18, John wrote:
> [...]
> >
> > Another question (sort of related)
> >
> > The only way I have been able to get the query to 'read' the new
> > parameter value is to close and reopen the query.  Should this be so ?
> > This means it unprepares and then re-prepares the (same) query,
> > reallocates all the fields...  Is there not some way of just
> > re-executing the same prepared query with the new bound value(s) ?
> >
> > (I guess it means I could work around my problem by just modifying the
> > sql text each time, as I would have no additional overhead, but it seems
> > the "wrong way" to go about it!)
> >
> MSEgui has the component "tfieldparamlink" to implement master detail 
> relationship. In SVN trunk I just modified the tmsesqldb.refresh procedure 
> not to unprepare the SQL statement.
> If you need fast access to the lookup values you can use a "tdblookupbuffer".

Maybe a stupid question, but:

SQLDB has this already. 
So, why don't you help fixing SQLDB instead, and use that in MSEgui ? 
This way everyone benefits.

This is a lot of silly code duplication for no good reason...


More information about the fpc-pascal mailing list