I went for a long time without knowing that also. A lot of the msi direct editors ( such as InstallShield and ORCA) have such a horrible UI that you can't even see the _ character in the grid view of the table data. You have to do an adjust schema for it to become obvious.
It's not until you get to the point of writing data driven custom actions that this convention becomes more obvious. 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, Thomas S. Trias <tomtr...@artizan.com> wrote: > From: Thomas S. Trias <tomtr...@artizan.com> > Subject: Re: Re: [WiX-users] DTF - install, rollback and uninstall > To: chr...@deploymentengineering.com, "General discussion for Windows > Installer XML toolset." <wix-users@lists.sourceforge.net> > Date: Sunday, February 22, 2009, 9:37 AM > 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
