To get *version* comparisons the quotes from around the version numbers (that makes them strings) and put a "v" in front. So the following should evaluate to true: "v4.0.0.0 < v14.0.0.0"
On Fri, Jun 21, 2013 at 12:21 AM, Michael Stoll <unwicht...@mistoll.de>wrote: > Here're the SQL CE 3.5 and 4.0 packages. > > There's a significiant difference in the behavior of those two! > > The SQL CE 4.0 packages detect SQL CE 4.0 of ANY language. While 3.5 > detects only a specific language. > The SQL CE 4.0 package could be altered to look for a specific language, > but I like the behavior as it is. > > Furthermore the SQL CE 4.0 package only detects a specific version. It > does not detect any future updates. > This is because AFAIK the < and > operators in the conditions do a > alphanumerical comparision, which would lead to wrong detections. (like > '4.0.0.0' < '14.0.0.0', which is false) And I don't know how to handle > that correctly. > One option would be to detect ANY 4.0 version. (SqlCe40Version << "4.0." > (Starts with operator)) > > > > <Fragment> > <util:RegistrySearch Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft > SQL Server Compact Edition\v4.0" > Value="Version" Win64="no" > Result="value" Variable="SqlCe40Version"/> > <PackageGroup Id="SQLServerCompact_4.0"> > <ExePackage Id="SQLServerCompact_4.0_x86" > Cache="no" Compressed="no" Vital="no" Permanent="yes" > SourceFile="$(var.TargetDir)SSCERuntime_x86-DEU.msi" > DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=253117"; > DetectCondition='NOT VersionNT64 AND SqlCe40Version = > "4.0.8876.1"' > InstallCommand="/i /q" > InstallCondition="NOT VersionNT64"/> > <ExePackage Id="SQLServerCompact_4.0_x64" > Cache="no" Compressed="no" Vital="no" Permanent="yes" > SourceFile="$(var.TargetDir)SSCERuntime_x64-DEU.msi" > DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=253118"; > InstallCommand="/i /q" > InstallCondition="VersionNT64" > DetectCondition='VersionNT64 AND SqlCe40Version = > "4.0.8876.1"'/> > </PackageGroup> > </Fragment> > > <Fragment> > <PackageGroup Id="SQLServerCompact_3.5"> > <MsiPackage Id="SQLServerCompact_3.5_x86" > Cache="no" Compressed="no" Vital="no" Visible="yes" > SourceFile="$(var.TargetDir)SSCERuntime_x86-DEU.msi" > DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=166085&clcid=0x407 > " > Permanent="yes" /> > <MsiPackage Id="SQLServerCompact_3.5_x64" > Cache="no" Compressed="no" Vital="no" Visible="yes" > SourceFile="$(var.TargetDir)SSCERuntime_x64-DEU.msi" > DownloadUrl="http://go.microsoft.com/fwlink/?LinkID=166086&clcid=0x407 > " > Permanent="yes" > InstallCondition="VersionNT64" /> > > </PackageGroup> > </Fragment> > > Am 17.06.2013 16:53, schrieb Michael Stoll: > > I've got a SQL CE 3.5 package, that's working well. It uses MSI files, > > so detect is easy. > > > > Note: There's an issue with the x86 on x64 machines: > > (http://support.microsoft.com/kb/974247) > > > > The links are for german culture installers. > > > > Am 17.06.2013 16:03, schrieb Rob Mensching: > >> If you get it working well, it'd be great if you could help us expand > >> the > >> provided packages and we can get that code in to maybe the SqlExtension. > >> > >> > >> On Mon, Jun 17, 2013 at 6:47 AM, Michael Stoll > >> <unwicht...@mistoll.de>wrote: > >> > >>> I might have been unclear, sorry. > >>> > >>> I don't want to create the msi package, I just want to bootstrap it. > >>> If there's no msi installer, I'd stick to the exe installer. > >>> The exe package should look somewhat like this (not testet yet) > >>> > >>> <?xml version="1.0" encoding="UTF-8"?> > >>> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; > >>> xmlns:util="http://schemas.microsoft.com/wix/UtilExtension";> > >>> <Fragment> > >>> <util:RegistrySearch Root="HKLM" > >>> Key="SOFTWARE\Microsoft\Microsoft > >>> SQL Server Compact Edition\v4.0\DEU" > >>> Value="DesktopRuntimeVersion" Win64="no" > >>> Result="value" Variable="DEU_INST"/> > >>> > >>> <PackageGroup Id="SQLServerCompact_4.0"> > >>> <ExePackage Id="SQLServerCompact_4.0_x86" > >>> Cache="no" Compressed="no" Vital="no" > >>> Permanent="yes" > >>> SourceFile="$(var.TargetDir)SSCERuntime_x86-DEU.msi" > >>> DownloadUrl=" > http://go.microsoft.com/fwlink/?LinkID=253117&clcid=0x407 > >>> > >>> " > >>> DetectCondition='DEU_INST == "4.0.8876.1"' > >>> InstallCommand="/i /q" /> > >>> <ExePackage Id="SQLServerCompact_4.0_x64"Visible="yes" > >>> Permanent="yes" > >>> SourceFile="$(var.TargetDir)SSCERuntime_x64-DEU.msi" > >>> DownloadUrl=" > http://go.microsoft.com/fwlink/?LinkID=253118&clcid=0x407 > >>> > >>> " > >>> InstallCommand="/i /q" > >>> InstallCondition="VersionNT64" > >>> DetectCondition='DEU_INST == "4.0.8876.1"'/> > >>> </PackageGroup> > >>> </Fragment> > >>> </Wix> > >>> > >>> > >>> > >>> Am 16.06.2013 21:19, schrieb Dan Blanchard: > >>>> It's pretty easy to distribute SQL ce DLLS, you can just deploy the > >>> files. Here is a blog that describes this. > >>>> > http://erikej.blogspot.com/2011/02/using-sql-server-compact-40-with.html > >>>> > >>>> > >>>> I made my own merge module > >>>> > >>>> Hope this helps > >>>> > >>>> Dan > >>>> > >>>> Sent from my iPhone > >>>> > >>>> On Jun 16, 2013, at 6:46 AM, Michael Stoll <unwicht...@mistoll.de> > >>> wrote: > >>>>> I'm authoring a burn package for SQL CE 4.0. > >>>>> > >>>>> Are there any preexistend SQL CE packages? > >>>>> > >>>>> The package should use msi files that are downloaded > >>>>> automatically. But > >>>>> the only msi files for download, that i could find where the SP1 CTP > >>>>> version. > >>>>> Is there a msi package out there with a permanent download link or > >>>>> do I > >>>>> have to stick to the exe package? > >>>>> > >>>>> > >>>>> > >>> > ------------------------------------------------------------------------------ > >>> > >>>>> This SF.net email is sponsored by Windows: > >>>>> > >>>>> Build for Windows Store. > >>>>> > >>>>> http://p.sf.net/sfu/windows-dev2dev > >>>>> _______________________________________________ > >>>>> WiX-users mailing list > >>>>> WiX-users@lists.sourceforge.net > >>>>> https://lists.sourceforge.net/lists/listinfo/wix-users > >>> > ------------------------------------------------------------------------------ > >>> > >>>> This SF.net email is sponsored by Windows: > >>>> > >>>> Build for Windows Store. > >>>> > >>>> http://p.sf.net/sfu/windows-dev2dev > >>>> _______________________________________________ > >>>> WiX-users mailing list > >>>> WiX-users@lists.sourceforge.net > >>>> https://lists.sourceforge.net/lists/listinfo/wix-users > >>>> > >>> > >>> > >>> > ------------------------------------------------------------------------------ > >>> > >>> This SF.net email is sponsored by Windows: > >>> > >>> Build for Windows Store. > >>> > >>> http://p.sf.net/sfu/windows-dev2dev > >>> _______________________________________________ > >>> WiX-users mailing list > >>> WiX-users@lists.sourceforge.net > >>> https://lists.sourceforge.net/lists/listinfo/wix-users > >>> > >>> > >> > ------------------------------------------------------------------------------ > >> > >> This SF.net email is sponsored by Windows: > >> > >> Build for Windows Store. > >> > >> http://p.sf.net/sfu/windows-dev2dev > >> _______________________________________________ > >> WiX-users mailing list > >> WiX-users@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/wix-users > >> > > > > > > > > > ------------------------------------------------------------------------------ > > This SF.net email is sponsored by Windows: > > > > Build for Windows Store. > > > > http://p.sf.net/sfu/windows-dev2dev > > > > > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Windows: > > Build for Windows Store. > > http://p.sf.net/sfu/windows-dev2dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
