Change the Link type between datasets in code
Hi all,
I would like to be able to change the properties of a link between 2 data
sets in code. An example:
In Dade I have 2 ds's, Clients and People
People is the child ds and links to the master, Clients, on
Clients.Id>People.ClientId
Now I can choose to only select data where matching records are found or
select everything from the master. I need to be able to override this in
code. Can anyone point me at the right place in the code. I've looked at
'MasterFieldLinks' and 'Links' but cant make out how what I am trying to do
fits in with that.
Thanks in advance
Andrew Flannery
WIN2k, RB7
I would like to be able to change the properties of a link between 2 data
sets in code. An example:
In Dade I have 2 ds's, Clients and People
People is the child ds and links to the master, Clients, on
Clients.Id>People.ClientId
Now I can choose to only select data where matching records are found or
select everything from the master. I need to be able to override this in
code. Can anyone point me at the right place in the code. I've looked at
'MasterFieldLinks' and 'Links' but cant make out how what I am trying to do
fits in with that.
Thanks in advance
Andrew Flannery
WIN2k, RB7
This discussion has been closed.
Comments
Try extracting the TdaSQL object for the detail dataview and setting the
SkipWhenNoRecords property to False if you want all master records to print,
and True if not.
An example of extracting the SQL object can be downloaded from
http://www.digital-metaphors.com/Tips/ExtractSQLObject.zip
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com