Re: [sqlite] FTS malformed MATCH expression: [( "a*" OR b*)]
Stefan Rogin wrote: > > I've seen that it's set on .Net 4 > The VS 2010 project uses .NET 4, the VS 2008 project uses .NET 3.5. > > How can I set it to 3.5 and are there any drawbacks? > Depends on what environment(s) you are going to use your application in. There are trade-offs; however, that is why we provide support for both. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] FTS malformed MATCH expression: [( "a*" OR b*)]
Forget the last question. I've managed to get passed it :), I didn't open the whole solution file, just the SQLite.Interop.2010 project, I've seen that it's set on .Net 4 How can I set it to 3.5 and are there any drawbacks? Anyway, thanks for the quick reply. +1 for the support On Fri, Feb 3, 2012 at 9:41 PM, Stefan Rogin wrote: > Hi, > > I tried to build with all default and it gave me this: > > Error 5 error LNK1181: cannot open input file > '\SQLite.Interop\..\bin\2010\ReleaseModule\bin\System.Data.SQLite.netmodule' > \SQLite.Interop\LINK SQLite.Interop.2010 > > On Fri, Feb 3, 2012 at 5:32 PM, Stefan Rogin > wrote: > >> Thank you, >> >> I'll try to recompile. >> I looked in the Navicat folder and it had 2 sqlite dlls(sqlite and >> sqlite3), could those be of any good? >> În data de 03.02.2012 16:52, "Joe Mistachkin" a >> scris: >> >> >>> The native SQLite code bundled with System.Data.SQLite is not compiled >>> with the SQLITE_ENABLE_FTS3_PARENTHESIS option, which is required for >>> the expression you are asking about to work properly. >>> >>> Of course, it can always be recompiled if you have access to Visual C++, >>> by editing one of the following files and recompiling the SQLite.Interop >>> project: >>> >>>/SQLite.Interop/props/sqlite3.vsprops (for VC++ 2008) >>>/SQLite.Interop/props/sqlite3.props (for VC++ 2010) >>> >>> Where is the root of the source tree for System.Data.SQLite. >>> >>> -- >>> Joe Mistachkin >>> >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> > > > -- > > *Stefan Rogin* > Webdesigner > Tel: +40.769.622.178 > > -- *Stefan Rogin* Webdesigner Tel: +40.769.622.178 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] FTS malformed MATCH expression: [( "a*" OR b*)]
Hi, I tried to build with all default and it gave me this: Error 5 error LNK1181: cannot open input file '\SQLite.Interop\..\bin\2010\ReleaseModule\bin\System.Data.SQLite.netmodule' \SQLite.Interop\LINK SQLite.Interop.2010 On Fri, Feb 3, 2012 at 5:32 PM, Stefan Rogin wrote: > Thank you, > > I'll try to recompile. > I looked in the Navicat folder and it had 2 sqlite dlls(sqlite and > sqlite3), could those be of any good? > În data de 03.02.2012 16:52, "Joe Mistachkin" a > scris: > > >> The native SQLite code bundled with System.Data.SQLite is not compiled >> with the SQLITE_ENABLE_FTS3_PARENTHESIS option, which is required for >> the expression you are asking about to work properly. >> >> Of course, it can always be recompiled if you have access to Visual C++, >> by editing one of the following files and recompiling the SQLite.Interop >> project: >> >>/SQLite.Interop/props/sqlite3.vsprops (for VC++ 2008) >>/SQLite.Interop/props/sqlite3.props (for VC++ 2010) >> >> Where is the root of the source tree for System.Data.SQLite. >> >> -- >> Joe Mistachkin >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > -- *Stefan Rogin* Webdesigner Tel: +40.769.622.178 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] FTS malformed MATCH expression: [( "a*" OR b*)]
Thank you, I'll try to recompile. I looked in the Navicat folder and it had 2 sqlite dlls(sqlite and sqlite3), could those be of any good? În data de 03.02.2012 16:52, "Joe Mistachkin" a scris: > > The native SQLite code bundled with System.Data.SQLite is not compiled > with the SQLITE_ENABLE_FTS3_PARENTHESIS option, which is required for > the expression you are asking about to work properly. > > Of course, it can always be recompiled if you have access to Visual C++, > by editing one of the following files and recompiling the SQLite.Interop > project: > >/SQLite.Interop/props/sqlite3.vsprops (for VC++ 2008) >/SQLite.Interop/props/sqlite3.props (for VC++ 2010) > > Where is the root of the source tree for System.Data.SQLite. > > -- > Joe Mistachkin > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] FTS malformed MATCH expression: [( "a*" OR b*)]
The native SQLite code bundled with System.Data.SQLite is not compiled with the SQLITE_ENABLE_FTS3_PARENTHESIS option, which is required for the expression you are asking about to work properly. Of course, it can always be recompiled if you have access to Visual C++, by editing one of the following files and recompiling the SQLite.Interop project: /SQLite.Interop/props/sqlite3.vsprops (for VC++ 2008) /SQLite.Interop/props/sqlite3.props (for VC++ 2010) Where is the root of the source tree for System.Data.SQLite. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users