> 1. Does the relation of the parent and child have to be based on numbers? I
> ask this because of the fact that a primary key must be a number currently.
> I was not able to determine the data type from your example.
No, only ApplyUpdates need the primary key to be a number. (which is a
bug, actually)
> 2. I noticed the indexdefs was set on the sqlquerys on your forms. It
> appears
> that indexdefs is a list (array?). But is it used? If is is used - how is
> it used?
Well, it contains the indexes. Not that sqldb does something with them.
The only thing is that they are used to find what the primary key is.
Btw: if you open a tsqlquery, and ParseSQL is true, it'll get a list of
indexes which do exist on that table from the DB-server. That's how it
finds out what the primary key is.
> 3. I noticed that the child relation is moved/set in the code. The code below
> is the example from your code. And wonder if this is required or there was
> some other reason. I would have expected sqlquery2 (child) to follow
> sqlquery1 (parent).
As said, master-detail isn't supported by sqldb yet, so I made it
myself, with the lines of code below:
> procedure TFBedrijven.QBedrijvenAfterScroll(DataSet: TDataSet);
> begin
> SaveData;
> with QRelaties do
> begin
> if Active then close;
> Params.ParamByName('bedrijfid').asinteger :=
> Dataset.fieldbyname('bedrijfid').AsInteger;
> open;
> end;
> end;
>
> procedure TFBedrijven.QRelatiesAfterInsert(DataSet: TDataSet);
> begin
>
> Dataset.FieldByName('bedrijfid').Assign(QBedrijven.fieldbyname('bedrijfid'));
> end;
>
> John
>
> On Thursday 30 March 2006 01:27, Joost van der Sluis wrote:
> > You could implement Master-detail in sqldb, or look at an example here:
> > http://www.cnoc.nl/fpc/pgg/
> >
> > That program is written for a sort of demonstration we've had here in
> > the Netherlands. (It's in Dutch, but I suppose you can sort it out, the
> > code is in the .tgz file)
> >
> > On Thu, 2006-03-30 at 00:12 -0800, johnf wrote:
> > > Hi,
> > > Could someone explain how to setup a Master Detail using the SQLdb or a
> > > link to something explaining what to do.
> > >
> > > John
> > >
> > > _________________________________________________________________
> > > To unsubscribe: mail [EMAIL PROTECTED] with
> > > "unsubscribe" as the Subject
> > > archives at http://www.lazarus.freepascal.org/mailarchives
>
> _________________________________________________________________
> To unsubscribe: mail [EMAIL PROTECTED] with
> "unsubscribe" as the Subject
> archives at http://www.lazarus.freepascal.org/mailarchives
>
--
Met vriendelijke groeten,
Joost van der Sluis
CNOC Informatiesystemen en Netwerken
http://www.cnoc.nl
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
