I was just looking at the source for the SqlString Element and I think I have spotted a bug but would appreciate any comments before raising it. The line in question is this:
LPCWSTR vcsSqlStringQuery = L"SELECT `String`, `SqlDb_`, `Component_`,`SQL`,`User_`,`Attributes`,`Sequence` " L"FROM `SqlString` ORDER BY `SqlDb_`,`Sequence`"; I think the "ORDER BY" is wrong, if I set the Sequence I would expect the strings to be run in the sequence I specified but I think it runs them in sequence per database which may not be correct. For example, if I create a table in db2 and then later on I have stored procedure in db1 that references it I would prefer that they were created in the order I specified, but this "ORDER BY" would create them in the reverse order. In this case it shouldn't matter as SQL Server will take care of it but if I wanted to create a function in one database that is called as part of my install from other databases it would fail. I would suggestion this should be: L"FROM `SqlString` ORDER BY `Sequence`"; or L"FROM `SqlString` ORDER BY ` Sequence `,` SqlDb_ `"; If you wanted to resolve duplicate sequence numbers. Neil Neil Sleightholm X2 Systems Limited [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
