On Thu, 30 Mar 2006, Joost van der Sluis wrote:
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:
I'll try to implement it, it's rather easy to do. I've done it before in
Delphi too...
Michael.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
