Re: [sqlite] disk image malformed

One thing I haven't seen anyone ask yet - are you putting this on a network drive? On 12/6/2012 10:52 AM, Durga D wrote: > Hi, > > Is it possible to corrupt a single table among 10 tables in a database? > > Is it possible to corrupt some records among millions of records in a > table? > > Best

Re: [sqlite] SQLITE in a Win7 Service Application

If you're using impersonation, you'll run into problems doing any updates during the impersonation when sqlite tries to create any temporary files or reopen any it has closed. You can use Process Monitor from Sysinternals (now Microsoft) to see exactly what the failure is with what file. On

Re: [sqlite] C++ - Installer

On 8/2/2012 8:40 AM, Arbol One wrote: I was wondering if there is an 'Installer' for Windows 7 that you would recommend. I want my user to have all the necessary SQLite3 files needed for my application as well as all the gtkmm files. You can create installers with WiX

Re: [sqlite] how to process password

Encryption is very hard to do right, so in general, let someone else do it. We use SEE (http://www.hwaci.com/sw/sqlite/see.html) with the key generated from a password by PBKDF2 and a high number of iterations. Previously, columns were encrypted with OS functions that made it impossible to move

Re: [sqlite] C++ - All the data in ONE row

On 7/25/2012 10:02 AM, Arbol One wrote: OK, continuing with the writing to the database, here is the driver method for the class rapper for SQLite3. The problem I have is that I have no control as to the exact location where I want the data to be stored, look the table below to have a better

Re: [sqlite] C++ - Creating Table

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of Robert Myers Sent: Monday, 23 July, 2012 21:44 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ - Creating Table On 7/23/2012 7:43 PM, Arbol One wrote: Thank you Michael for your

Re: [sqlite] C++ - Creating Table

On 7/23/2012 7:43 PM, Arbol One wrote: Thank you Michael for your prompt response. I have been able to duplicate the error message. I think this could be a bug in SQLite3. void jme::mySQLite3::createTable(const std::string& s) throw (std::exception) { rc = sqlite3_prepare_v2( db, s.c_str(),

Re: [sqlite] Bug in sqlite3_step

On 7/3/2012 3:26 PM, Richard Hipp wrote: Igor is correct. Actually, you can bind on a DDL statement, but bindings are only valid for the lifetime of the statement itself, not for the whole lifetime of the object created by the CREATE statement. So doing such bindings are pointless. And you

Re: [sqlite] size_t printf standard

On 6/29/2012 1:56 PM, Kyle McKay wrote: On June 28, 2012 09:46:06 PDT, Stephan Beal wrote: - There are no standard printf()/scanf() specifiers for it, which means those funcs cannot be used with size_t or ifdefs or casts are needed to handle them portably. Perhaps you should actually check

Re: [sqlite] SQLite4 (don't scream)

Aghhh (just kidding) One request for a change - make bind and column start with the same index. I always have to look up which one is zero based and which one is one based. Rob On 6/28/2012 10:57 AM, Simon Slavin wrote: First, the important bit: "SQLite4 is an alternative, not a

Re: [sqlite] C++ - ISERT from a data object

On 6/25/2012 5:58 PM, Simon Slavin wrote: On 25 Jun 2012, at 11:36pm, Arbol One wrote: In my GUI application the user enters a information that will go in a SQLite database table, so statements like: string dbdata = "INSERT INTO friend (name, address, age) VALUES

Re: [sqlite] error compilation with Sqlite in C program

On 4/12/2012 11:07 AM, Sako Youssouf wrote: Here my step and the result. # gcc -c sqlite3.c # ar -rvs libsqlite3.a sqlite3.o ar: creating libsqlite3.a a - sqlite3.o # gcc -L. -lsqlite -L/usr/lib/ -ldl -lpthread -o compil compil.c Here's your problem. You want -lsqlite3 /tmp/ccfdSnPR.o: In

Re: [sqlite] How to : encrypt the data of database table.

I added some functions to do that. I have ENCCOL, DECCOL, SIGCOL (signature creation), CHECKSIG Inserts and selects look something like this: INSERT INTO TABLE x(col1) VALUES(ENCCOL(1)) SELECT DECCOL(col1) FROM x; Nothing I want in an index can be encrypted, which is where SIGCOL comes in, I can

Re: [sqlite] SQLite3.dll for Win 64

Check your compiler documentation. You should be able to link C .obj files and call C functions without too much hassle. The biggest issue will be getting all the functions declared in a Pascal readable format. On 7/25/2011 3:10 PM, Everton Vieira wrote: > The software that uses this dll is made

Re: [sqlite] How to search column ascii containing chr(0)

On 6/5/2011 8:47 AM, Igor Tandetnik wrote: > iip wrote: >> As subject, I want to know how search column that contain ascii chr(0) > select * from MyTable where hex(MyField) like '%00%'; That query doesn't work. If the field contains 0\n, that would match (300A)

Re: [sqlite] TRANSACTIONs

On 6/1/2011 1:47 PM, Pavel Ivanov wrote: >> Actually, you do know what SQLite does without knowing the internals. It >> claims to be serializable and ACID >> (http://www.sqlite.org/transactional.html), therefore it's fine. > "Serializable" there means that once transaction is started statements >

Re: [sqlite] TRANSACTIONs

On 6/1/2011 1:23 PM, Simon Slavin wrote: > On 1 Jun 2011, at 7:12pm, Jan Hudec wrote: > >> On Wed, Jun 01, 2011 at 10:17:02 -0400, Pavel Ivanov wrote: From within a BEGIN TRANSACTION and END TRANSACTION block, should I not update the same row in a table more than once? >>> You can

[sqlite] sqlite and impersonation on Windows (Bug / feature request)

When running in Windows under SYSTEM context, such as in a service, there are issues when using impersonation and trying to update a sqlite database. How to reproduce: 1. In SYSTEM context, create a directory that only SYSTEM as access to. 2. Open/ create a database in this directory. All