While I knew that the Component_ column was a reference, I never realized that the trailing underscore was a naming convention that indicates a reference to another table. That is really good to know.
Thanks! Thomas S. Trias Senior Developer Artizan Internet Services http://www.artizan.com/ -------- Original Message -------- Subject: Re: [WiX-users] DTF - install, rollback and uninstall From: Christopher Painter <chr...@deploymentengineering.com> To: General discussion for Windows Installer XML toolset. <wix-users@lists.sourceforge.net> Date: 2/22/2009 8:26 AM > The SSRS data driven CA prototype I sent you back in November has a custom > table with a Component_ column. The _ signifies it's a FK back to the PK of > the Component table. > > MSI is only loosely a relational database. There aren't any real foreign key > constraint capabilities. > > Christopher Painter, Author of Deployment Engineering Blog > Have a hot tip, know a secret or read a really good thread that deserves > attention? E-Mail Me > > > --- On Sun, 2/22/09, Neil Sleightholm <n...@x2systems.com> wrote: > > >> From: Neil Sleightholm <n...@x2systems.com> >> Subject: Re: [WiX-users] DTF - install, rollback and uninstall >> To: "General discussion for Windows Installer XML toolset." >> <wix-users@lists.sourceforge.net> >> Date: Sunday, February 22, 2009, 6:15 AM >> Do you have an example of creating a custom table with the >> component reference? >> >> Neil >> >> Neil Sleightholm >> X2 Systems Limited >> n...@x2systems.com <mailto:n...@x2systems.com> >> >> >> ________________________________ >> >> From: Bob Arnson [mailto:b...@joyofsetup.com] >> Sent: Sat 21/02/2009 22:27 >> To: General discussion for Windows Installer XML toolset. >> Subject: Re: [WiX-users] DTF - install, rollback and >> uninstall >> >> >> >> Neil Sleightholm wrote: >> >>> I think I understand the component state approach but >>> >> I am not sure this is possible with the current >> implementation of custom tables as I can't see how they >> can be associated with a component. >> >>> >>> >> WiX's custom tables have a foreign key into the >> Component table (or an >> indirect reference, as in a File id that works off the >> file's component >> parent). >> >> -- >> sig://boB >> http://joyofsetup.com/ >> >> >> >> ------------------------------------------------------------------------------ >> Open Source Business Conference (OSBC), March 24-25, 2009, >> San Francisco, CA >> -OSBC tackles the biggest issue in open source: Open >> Sourcing the Enterprise >> -Strategies to boost innovation and cut costs with open >> source participation >> -Receive a $600 discount off the registration fee with the >> source code: SFAD >> http://p.sf.net/sfu/XcvMzF8H >> _______________________________________________ >> WiX-users mailing list >> WiX-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/wix-users >> >> >> ------------------------------------------------------------------------------ >> Open Source Business Conference (OSBC), March 24-25, 2009, >> San Francisco, CA >> -OSBC tackles the biggest issue in open source: Open >> Sourcing the Enterprise >> -Strategies to boost innovation and cut costs with open >> source participation >> -Receive a $600 discount off the registration fee with the >> source code: SFAD >> http://p.sf.net/sfu/XcvMzF8H_______________________________________________ >> WiX-users mailing list >> WiX-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/wix-users >> > > > > > > ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
