Table order is not guaranteed. If you need ordering, the table needs to have a sequence column and the code that reads it needs to group by it. The SqlScripts table happens to have just such a column
-----Original Message----- From: Nic Barden [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 10:43 To: WiX User Group Subject: [WiX-users] Record ordering not retained when records added via View.Modify Hi, I have a bug which is being caused by the way the installer database is ordering the records when I add them via View.Modify(ViewModifyMode.InsertTemporary). I have performed a full dump of the table to the log after EVERY record is inserted, and I can see that: There are 2 permanent records already in the table The 1st temp record I add is the LAST record in the table (i.e. AFTER all permanent records) The 2nd temp record I add somehow "leapfrogs" the 1st temp record just added, and is located in between the permanent records and the first temp record I added All subsequent records are added AS EXPECTED. I.e. as the LAST row in the table Does anyone know why this behaviour could be occurring? It is resulting in my SqlScripts to execute in the wrong order and fail! Thanks _________________________________________________________________ ------------------------------------------------------------------------- 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 ------------------------------------------------------------------------- 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
