Re: [sqlite] newbie question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Listman wrote: > anyone see a problem with us piggy backing on the svn sqlite > client install? You should be asking the Subversion folks. I'd assume they would want you to ensure your tables have their own namespace prefix. You will also want to

Re: [sqlite] SQLITE_STATIC and bind*()

> > Sqlite3_bind_text(Statement, S.c_str(), S.size() + 1, > > SQLITE_[TRANSIENT | STATIC?]); > > Drop +1. It's unlikely that you actually want terminating NUL to be > part > of the string in the database. > Sorry, mixed that one with the nByte parameter of prepare_v2. It's "-1" in code though,

Re: [sqlite] SQLITE_STATIC and bind*()

"Sherief N. Farouk" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Does the bind text family attempt to access the data pointed to by the > passed parameter after the lifetime of the function call? Yes, unless you pass SQLITE_TRANSIENT flag. > Sqlite3_bind_text(Statement,

[sqlite] newbie question

hi, the SCM tool Subversion is going to start using sqlite in the upcoming 1.6 release to manage client metadata. would it be possible for us to also that sqlite install as part of some custom code we write around subversion? we'd like to be able to cache the list of managed object in the

[sqlite] SQLITE_STATIC and bind*()

Does the bind text family attempt to access the data pointed to by the passed parameter after the lifetime of the function call? I have a situation similar to the following: Std::string S("Blah"); foo(S); Rest_of_program(); Where foo() is: Void foo(string& S) { //prepare a statement

Re: [sqlite] Joining 2 views

Hi P, well I tried to put all the business logic out of my program and into views. Basically all my program does is feed data into tables that are created for dynamic data and are cleaned before each import. Once the import is finished my app then selects from those views. Those views use

Re: [sqlite] Joining 2 views

On 10/13/08, Guenther Schmidt <[EMAIL PROTECTED]> wrote: > > Hi P, > > thanks, I had considered that. > > Hope there is another solution though. possibly, but how about enlightening others as to why you considered creating temp tables and then decided not to do so? In fact, how about

Re: [sqlite] Joining 2 views

Hi P, thanks, I had considered that. Hope there is another solution though. Günther P Kishor schrieb: > On 10/13/08, Guenther Schmidt <[EMAIL PROTECTED]> wrote: > >> Hi, >> >> unfortunately I've hit a point where I run a query where one VIEW joins >> another VIEW. >> >> Both views are

Re: [sqlite] Joining 2 views

On 10/13/08, Guenther Schmidt <[EMAIL PROTECTED]> wrote: > Hi, > > unfortunately I've hit a point where I run a query where one VIEW joins > another VIEW. > > Both views are rather large and since there is no index on the fields > where they join the query takes very very long. (About 15 min).

[sqlite] Joining 2 views

Hi, unfortunately I've hit a point where I run a query where one VIEW joins another VIEW. Both views are rather large and since there is no index on the fields where they join the query takes very very long. (About 15 min). Does anybody here know a solution to this problem? Best regards

Re: [sqlite] sqlite3_open() problem

Leandro dos Santos Ribeiro wrote: > D. Richard Hipp wrote: > >> On Oct 10, 2008, at 4:59 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED] >> > wrote: >> >> >> >>> Hello Team. >>> >>> I have a problem with running SQLite. >>> I am running linux 2.6.17 on *ARM* and basically problem is that

Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows

Stephen Oberholtzer wrote: On Mon, Oct 13, 2008 at 12:52 PM, Doug <[EMAIL PROTECTED]> wrote: I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN when doing an insert. When that fails, I can use the debugger to go back up and step through the same lines again (using the

Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows

On Mon, Oct 13, 2008 at 12:52 PM, Doug <[EMAIL PROTECTED]> wrote: > I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN > when doing an insert. When that fails, I can use the debugger to go back > up > and step through the same lines again (using the same database handle - >

[sqlite] Intermittent SQLITE_CANTOPEN on Windows

I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN when doing an insert. When that fails, I can use the debugger to go back up and step through the same lines again (using the same database handle - nothing opened or closed in between) and it will work. I am using

Re: [sqlite] sqlite3_open() problem

D. Richard Hipp wrote: > On Oct 10, 2008, at 4:59 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED] > > wrote: > > >> Hello Team. >> >> I have a problem with running SQLite. >> I am running linux 2.6.17 on *ARM* and basically problem is that my >> application >> is crushing on *sqlite3_open*()

[sqlite] Testing for existence of extension

Hi, I am a happy user of FTS3 and want to rely on this functionality in my program which hopefully will be used on a variety of systems. Now I found out that it wouldn't even run on a up to date Ubuntu, at least two bug reports are pending. Now that FTS3 will only be optionally available,

Re: [sqlite] from access to sqlite

"Fabio Stranieri" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > "'11/10/2008 00:00:00'" As I see it, there's no need, to hardcode your Dates this way. You can use an appropriate Format-String to retrieve that directly from VB-DateVariables: Format(now,"'dd\/mm\/

Re: [sqlite] from access to sqlite

"Toby Bascom" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Olaf is, in a word, a genius! Heh, don't make me blush here, especially in this group, where the real DB-experts hang around... Without the sqlite-engine my wrapper wouldn't exist. I'd suggest the groups on the