Re: [sqlite] Critical issue

2011-06-18 Thread Michael Stephenson
If the IE folder is not on the path, yes, you have to either copy it somewhere on the path, copy it to your application folder, or add the IE folder to the path. I believe that not having the IE folder on the path is a mistake in the installer for the newer versions of IE. Back in the day, I

Re: [sqlite] Critical issue

2011-06-18 Thread Cyrille
It seems that I have been too quickly enthusiastic. Indeed, I have already received a feedback from a user who has the same issue running a 32-bit Windows. Thus, I tried to follow your advices Michael. Concerning the first link which advice putting the DLL in the environment path. I am not

Re: [sqlite] Critical issue

2011-06-18 Thread Cyrille
Dear Beell and Michael, Thank you very much for your respective answers. I am checking but I am pretty sure that users who experience this issue are using my application with windows 64 bits and I made my project only with... 32 bits DLLs of SQLite.NET. Thus, now my next question is: each

Re: [sqlite] Critical issue

2011-06-18 Thread Black, Michael (IS)
Also...try dependency walker to ensure you have all the DLLs you need deployed with your package that aren't "standard". http://www.dependencywalker.com/ Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From:

Re: [sqlite] Critical issue

2011-06-18 Thread Black, Michael (IS)
See if this thread helps you -- a couple of different solutions. Both of which you should be able to solve for your users. http://forums.asp.net/t/939729.aspx/1 Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate

Re: [sqlite] Critical issue

2011-06-18 Thread beell
Am 18.06.2011 14:47, schrieb Cyrille: > Dear all, > > Since I am using the new version of SQLite.NET, some of my users have > the following error when launching my application: > > System.DllNotFoundException: Impossible de charger la DLL > 'SQLite.Interop.DLL': Le module spécifié est introuvable.

[sqlite] Critical issue

2011-06-18 Thread Cyrille
Dear all, Since I am using the new version of SQLite.NET, some of my users have the following error when launching my application: System.DllNotFoundException: Impossible de charger la DLL 'SQLite.Interop.DLL': Le module spécifié est introuvable. (Exception de HRESULT : 0x8007007E) à

Re: [sqlite] How to use LIKE wildcards and bound parameters?

2011-06-18 Thread Igor Tandetnik
Zettai Muri wrote: > Just out of interest would there be a way to use a variable here with > the % wildcards as in: > char* myvar = "teststr"; > > sqlite3_bind_text( stmt, >sqlite3_bind_parameter_index(stmt, ":bp"), >

Re: [sqlite] OSX path

2011-06-18 Thread Sven Utcke
Hello John, > As for "top-posting," In the corporate culture I come from, it is > considered the only way to do things (or at least one faction who > has the ear of the ops boss, believes this). Yes, I noticed that too. I can think of two reasons for doing things in this terribly inefficient

Re: [sqlite] How to use LIKE wildcards and bound parameters?

2011-06-18 Thread Zettai Muri
> Have the C program include the % in the text parameter: > > sqlite3_bind_text( stmt, >        sqlite3_bind_parameter_index(stmt, "%:bp%"), >               "%bar%", .. Just out of interest would there be a way to use a variable here with the % wildcards as in: char* myvar = "teststr";

Re: [sqlite] How to use LIKE wildcards and bound parameters?

2011-06-18 Thread Kees Nuyt
On Sat, 18 Jun 2011 17:01:41 +1000, Zettai Muri wrote: >Hi All, > >Could someone tell me how to use bound parameters with LIKE and where >the % wildcards should be placed? > >I currently have the following code extract: >char *sql = "SELECT * FROM foo WHERE name LIKE :bp";

[sqlite] How to use LIKE wildcards and bound parameters?

2011-06-18 Thread Zettai Muri
Hi All, Could someone tell me how to use bound parameters with LIKE and where the % wildcards should be placed? I currently have the following code extract: char *sql = "SELECT * FROM foo WHERE name LIKE :bp"; rc = sqlite3_prepare_v2(db, sql, strlen(sql), , ); sqlite3_bind_text( stmt,