Not sure what you mean by "refer one column to another". The data in a column is expected to conform to the type of data that one would find in such a column. Normal database rules of normalization don't provide a way to have one column either contain data or contain a reference (pointer/index-as-it-were?) to another column, especially when that other column is in the same row of the same table.
Also, custom tables are always processed by custom actions (they are unknown by any standard action), so ultimately it is up to your custom action what each column really means (which I hope answers your RegPath question as well). The column types are used by tools that manipulate MSIs (localization, build, validation) but not much beyond that (from the point-of-view of the APIs, they are whatever Type says they are, not what Category says). -Blair -----Original Message----- From: Sean Farrow [mailto:sean.far...@seanfarrow.co.uk] Sent: Sunday, January 16, 2011 9:00 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] referencing one column from another in a custom table and refering to registry locations Hi: I have the following custom table definition: <CustomTable Id="JawsTable"> <Column Id="MajorVersion" Category="Integer" Type="int" Width="2"/> <Column Id="MinorVersion" Category="Integer" Type="int" Width="2"/> <Column Id="Build" Category="Integer" Type="int" Width="2"/> <Column Id="Path" Category="RegPath" Type="string" PrimaryKey="yes"/> <Column Id="AllUsersPath" Category="Path" Type="string"/> <Column Id="CurrentUserPath" Category="Path" Type="string"/> <Column Id="RoamingPath" Category="Path" Type="string" Nullable="yes"/> <Row> <Data Column="MajorVersion">12</Data> <Data Column="MinorVersion">0</Data> <Data Column="Build">522</Data> <Data Column="Path">"HKLM\Software\Freedom Scientific\JAWS\12.0\Target</Data> <Data Column="RoamingPath"></Data> </Row> </CustomTable> As can be seen, a first row is partially filled in. My queries are: Firstly, can I refer to one column from another, for example in the snippet above, I need to refer to the <Path> column in the <RoamingPath> column. Do I need a custom action to do this? Secondly, can the Regpath datatype refer to a value name, in this example "Target", this isn't clear from the docs. Any help appreciated. Regards Sean. ---------------------------------------------------------------------------- -- Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
