Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite database as resource in project?

2008-08-24 Thread CAVALO SCHMIDT
salutations, I don't understand exactly what you mean by "library project". is it a "Win32 Static Library"? do I create the library project and include "sqlite3.c" in it? in this way, will sqlite be integrated in the application, instead of located in an external DLL file? note: I'm using Visual

Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite database as resource in project?

2008-08-24 Thread CAVALO SCHMIDT
2008/8/10 D. Richard Hipp <[EMAIL PROTECTED]>: > > On Aug 10, 2008, at 2:12 PM, CAVALO SCHMIDT wrote: > >> salutations, using VC++ in WinXP. >> >> I would like to know if it's possible to import and use the >> sqlite3.dll file and/or the sqlite da

Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite database asresource in project?

2008-08-10 Thread CAVALO SCHMIDT
thank you for your quick response. do you mean extracting the file temporarily (both the database and the DLL) to the program's folder? but how would I do this (if this question is relevant to this list)? thank you in advance. 2008/8/10, Igor Tandetnik <[EMAIL PROTECTED]>: > "

[sqlite] [C++] Import sqlite3.dll and/or sqlite database as resource in project?

2008-08-10 Thread CAVALO SCHMIDT
salutations, using VC++ in WinXP. I would like to know if it's possible to import and use the sqlite3.dll file and/or the sqlite database file as a resource in a C++ project, so that it will be integrated to the final Win32 executable. how would it be possible to use sqlite3_open with a database

Re: [sqlite] sqite wildcard search with indexing

2008-07-26 Thread CAVALO SCHMIDT
CAVALO SCHMIDT <[EMAIL PROTECTED]> writes: > > Salutations, > > Is it possible to do a simple wildcard/regexp-type search in sqlite > databases, but with indexing? For example, if I want to search for the > string "aCa", we would do only one SELECT * FROM

[sqlite] sqite wildcard search with indexing

2008-07-21 Thread CAVALO SCHMIDT
Salutations, Is it possible to do a simple wildcard/regexp-type search in sqlite databases, but with indexing? For example, if I want to search for the string "aCa", we would do only one SELECT * FROM a WHERE a = "aCa", and it would interpret "C" as any letter in "bdgjklmnpqrstv". So, one SELECT

Re: [sqlite] sqlite3_prepare / sqlite3_step not working

2007-12-13 Thread CAVALO SCHMIDT
Thank you, it now works. 2007/12/13, Dennis Cote <[EMAIL PROTECTED]>: > > CAVALO SCHMIDT wrote: > > In the following simple C code (in Console program): > > > > sqlite3 *db; > > int ret = sqlite3_open("dict.db", ); > > sqlite3_st

[sqlite] sqlite3_prepare / sqlite3_step not working

2007-12-13 Thread CAVALO SCHMIDT
Salutations, In the following simple C code (in Console program): sqlite3 *db; int ret = sqlite3_open("dict.db", ); sqlite3_stmt *stmt; char sql[256]; sprintf(sql, "%s", "select * from a where a = 'key1'"); int rc = sqlite3_prepare(db, sql, 0, , 0);

Re: [sqlite] SQLite gives Access Violation in Windows

2007-12-12 Thread CAVALO SCHMIDT
Thank you, it worked. 2007/12/12, Uwe Sander <[EMAIL PROTECTED]>: > > Hi, > Am Mittwoch, 12. Dezember 2007 schrieb CAVALO SCHMIDT: > > Ok, I'm sending to you a zip file with the Pelles C project, together > > with the database (a small test database, with a key1 with

Re: [sqlite] SQLite gives Access Violation in Windows

2007-12-12 Thread CAVALO SCHMIDT
Thank you for the response. So, how can I fix it? Can it have anything to do with sqlite3.lib? Is it a bug? Thank you in advance. 2007/12/12, Trevor Talbot <[EMAIL PROTECTED]>: > > On 12/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > "Trevor Talbot" <[EMAIL PROTECTED]> wrote: > > > > >

Re: [sqlite] SQLite gives Access Violation in Windows

2007-12-12 Thread CAVALO SCHMIDT
te3.def. Thank you in advance. 2007/12/12, Trevor Talbot <[EMAIL PROTECTED]>: > > On 12/12/07, CAVALO SCHMIDT <[EMAIL PROTECTED]> wrote: > > > For example, in a database where searching for text "key1" (column a) > > returns "value1", &quo

Re: [sqlite] SQLite gives Access Violation in Windows

2007-12-12 Thread CAVALO SCHMIDT
t.exe: WinMain( ) + 71 sqlite3.dll: sqlite3_exec( ) + 154 sqlite3.dll: sqlite3_column_text( ) + 1A sqlite3.dll: sqlite3_data_count( ) + AC ntdll.dll: RtlEnterCriticalSection( ) + B I'm not very sure if it is all the information that you need. Thank you in advance. 2007/12/12, Trevor Talbot <[EMA

[sqlite] SQLite gives Access Violation in Windows

2007-12-12 Thread CAVALO SCHMIDT
Salutations, I'm programing in C, new to SQLite, in Windows, with the Pelles C Compiler for Windows. When I create a Console project and put, for example, the following commands (an SQLite connection with callback function): static int callback(void *NotUsed, int argc, char **argv, char