Re: [sqlite] SQLite and SumTotal ToolBook

On 12/5/06, Felix Hoffmann <[EMAIL PROTECTED]> wrote: Questions: (1) Is it correct procedure to use sqlite_open() as the first step, or do I need to perform some sort of memory allocation first? sqlite_open() is the first step, so that is correct. Documentation is found here:

Re: [sqlite] Database protected

On 12/5/06, made hendra <[EMAIL PROTECTED]> wrote: Are there a way to protected sqlite database? with password maybe. I believe Dr. H has a commercial version that provides low level encryption. If you are using .Net (Windows) then modified version of SQLite that has password

Re: [sqlite] "bad" SQL runs on CREATE

On 2/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > SQLite, by design, accepts any data type. Even those you > might not have heard of before. This is a feature, not a > bug. It seems odd that a data type could be multiple words, but hey, that's just me. hmm, ok. Well no complaints if

[sqlite] "bad" SQL runs on CREATE

In version: 3.3.1 The following SQL runs fine without any errors: CREATE TABLE lnk_assoc_person ( assoc TEXT, person TEXT, active BOOL joined DATE, left DATE ); Notice the lack of a comma behind 'active BOOl'. Is this considered a bug or expected behavior? It is

[sqlite] empty file name / checkin 1085

SQLite Version: 3.2.5 Platform: Windows XP I happen to have a bug in my wrapper that allowed an empty filename to be passed on to sqlite3. I noticed from check-in 1085 that it opens a temporary database, and seems to be acceptable behavior to go on with life. I'm guessing this is an in

Re: [sqlite] Problems with threadsafe opt correction #2623

Ian Monroe wrote: I see your just ignorant of how open source software gets released. Ian, You are right, I hope you will forgive my ignorance. Beyond that, it wasn't my place to criticize those projects even if I had fully understood the situation. --kiel

Re: [sqlite] Problems with threadsafe opt correction #2623

Ian Monroe wrote: I do not see how such a major change can be justified in a minor point release. For instance, currently amaroK does not work when using a sqlite database on Debian Sid since they package it with sqlite 3.2.5. Just my two cents, but if this change is breaking things in

Re: [sqlite] Linking to SQLite with Cygwin / CMake [SOLVED]

Reid, Thanks for the help! 1) I didn't realize the catch that the .lib directory was a hidden folder 2) I wasn't using the --enable-debug and --disable-tcl flags 3) CMake is not generating a valid Makefile that links correctly =(

Re: [sqlite] Linking to SQLite with Cygwin / CMake

Ok, I'm definately thinking this is just a problem with my understanding of the build process in *nix's and the quirks of Cygwin. I am getting the following warning with the default Makefile that is generated. "libtool: link: warning: undefined symbols not allowed in i686-pc-cygwin shared

Re: [sqlite] C/C++ interpreter Ch bindings to sqlite

not your product. There are _a lot_ of third party extensions, add-ins, etc for Sqlite. In my mind, it wouldn't be practical for the Sqlite devs to support all the wrappers, etc out there. -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

Re: [sqlite] sqlite3_step() question

your application, this seems to me it would be a solution.. Make the general selection (or a set of 1000 queries) and "step" through those in memory. When you need more, get the next set.. Will that work for you? -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

Re: [sqlite] INTEGER data type

ately plenty of space now. -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

Re: [sqlite] My first post, a few wishes..

May i suggest a better (easier) forum for sqlite? > I can setup a forum independant of my own sites. > No commercials etc.. > > > -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

Re: [sqlite] INTEGER data type

On 7/4/05, Ajay <[EMAIL PROTECTED]> wrote: > > Hello All, > > What is the maximum number that can be stored using INTEGER data type? My > table uses INTEGER to store primary key, I store lot of records in table. > I > suspect that primary key will run out of limit. How can I use long instead >

Re: [sqlite] Syntax Help

iliar with Tcl/Tk but I /think/ your code would be fine as long as you end each statement (including what I mentioned above). I could be entirely off base, but its something to try until someone else gives some input. -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

Re: [sqlite] Problem with "installing"

with #pragma > comment(lib, "file.lib"); into my C++ program. > > Can anyone help me? > > Thanks in advance :) > > -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

Re: [sqlite] Basic Text Bind Question

Thanks Dan! Works like a charm now. On 6/7/05, Kiel W. <[EMAIL PROTECTED]> wrote: > > Ok, thanks for the responses. > > --Ulrik > >I think it stops right here, because you've got fname twice. That > >induces an error. > > You are correct, I'm not sure when

Re: [sqlite] Basic Text Bind Question

; sqlite3_bind_text(statement, 1, "Fullman", 7, SQLITE_STATIC ); rc = sqlite3_step(statement); std::cout << rc << " " << SQLITE_DONE; I would expect rc to be SQLITE_ROW, but it is SQLITE_DONE. I undertand with getting multiple row back I w

[sqlite] Re: Basic Text Bind Question

Added note... rc = sqlite3_prepare( database, buf, -1, , 0 ); > I also tried this with rc = sqlite3_prepare( database, buf, strlen(buf), , 0); -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

[sqlite] Basic Text Bind Question

HERE lname = '?'" ); rc = sqlite3_prepare( database, buf, -1, , 0 ); sqlite3_bind_text(statement, 1, "Fullman", 7, SQLITE_STATIC ); rc = sqlite3_step(statement); std::cout << rc << " " << SQLITE_DONE; // rc == SQLITE_DONE at this point --- end code --- -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

Re: [sqlite] Re: 'int n' parameter in sqlite3_bind_*() functions

Thanks Kurt. After reading the archive you posted I remembered reading it a few days ago when it came across! So much for my memory :-) On 6/4/05, Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > > http://www.mail-archive.com/sqlite-users@sqlite.org/msg08319.html> > > >

[sqlite] Re: 'int n' parameter in sqlite3_bind_*() functions

to it in the documentation at: http://www.sqlite.org/capi3ref.html#sqlite3_prepare -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

[sqlite] 'int n' parameter in sqlite3_bind_*() functions

What is the 'int n' parameter used for in the sqlite3_bind_*() functions. The one I am speciffically looking at is: -- Kiel W. [EMAIL PROTECTED] -- >> time is swift <<

[sqlite] Create Table Programatically

I've been trying to create a table programatically though C++ without luck. Here is what I have: /* * The function that acts as a wrapper around sqlite3_exec */ inline int SqliteGatekeeper::ExecuteSql( const string sql, sqlite3_callback CallBack = 0, void* callbackParam = 0) { int rc =

Re: [sqlite] Do source updates effect DB file compatiblity?

>If your application works fine with the version that you've embedded, why change? Ng, the application is not written yet, I'm still in the research stage. I'm looking towards the future and any problems I may possibly encounter. >The policy so far has been that file formats within a major

[sqlite] Do source updates effect DB file compatiblity?

List, I'm new to the concept of embedded databases, but it seems to be the ideal solution for a project I'm developing for school/ my church. Along with any resources you might recommend one question has been on my mind for awhile. As SQLite progresses and I update my source with new releases,