Thanks very much Rob you have saved me! (Lucky I mentioned what I was doing with it! :-)) ----- Re: [WiX-users] Record ordering not retained when records added via View.ModifyFrom: Rob Mensching <[EMAIL PROTECTED]> - 2008-10-31 17:49 Table order is not guaranteed. If you need ordering, the table needs to have a sequencecolumn and the code that reads it needs to group by it. The SqlScripts table happens tohave just such a column -----Original Message-----From: Nic Barden [mailto:[EMAIL PROTECTED]: Friday, October 31, 2008 10:43To: WiX User GroupSubject: [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 therecords when I add them via View.Modify(ViewModifyMode.InsertTemporary). I have performed afull 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 tableThe 1st temp record I add is the LAST record in the table (i.e. AFTER all permanentrecords)The 2nd temp record I add somehow "leapfrogs" the 1st temp record just added, and islocated in between the permanent records and the first temp record I addedAll 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 SqlScriptsto execute in the wrong order and fail! Thanks_________________________________________________________________ -------------------------------------------------------------------------This SF.Net email is sponsored by the Moblin Your Move Developer's challengeBuild the coolest Linux based applications with Moblin SDK & win great prizesGrand prize is a trip for two to an Open Source event anywhere in the worldhttp://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________WiX-users mailing [EMAIL PROTECTED]://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
