[sqlite] Ultimate noob question: What do I do to reference another table?

Hi everyone, Yes, this is quite the noob question: I want to have one fields reference another table, how do I do that? Here's what I am trying to do. I have a bunch of fields(or columns) Item, UPC, Manufacturer, MSRP for example. I want to be able to choose the Manufacturer from a

Re: [sqlite] how can i get values from sqlite db?

more clearly in my c++ program: int value = sql.exe("select counter form tbl1 where name = 'accept'"); in this sql.exe is my function which invokes the "sqlite3_exec" function i want that counter value into the "value" variable . kriscbe wrote: > > hi everyone, > > i am using linux. > i

Re: [sqlite] Does changing the db change result sets?

"Stephen Woodbridge" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Igor Tandetnik wrote: >> "Nikolaus Rath" <[EMAIL PROTECTED]> wrote in >> message news:[EMAIL PROTECTED] >>> What happens if >>> >>> 1. I prepare and execute a select statement >>> 2. I retrieve a couple of rows >>>

Re: [sqlite] Does changing the db change result sets?

Igor Tandetnik wrote: > "Nikolaus Rath" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> What happens if >> >> 1. I prepare and execute a select statement >> 2. I retrieve a couple of rows >> 3. I execute a new query that would change the result of the >>query in 1 > > On the

Re: [sqlite] Does changing the db change result sets?

"Nikolaus Rath" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What happens if > > 1. I prepare and execute a select statement > 2. I retrieve a couple of rows > 3. I execute a new query that would change the result of the >query in 1 On the same connection, I assume. > 4. I

Re: [sqlite] SQLite3.exe preprocessed source?

Never mind, I managed to figure out the file I need from the make file in the source repository. For reference the file seems to be shell.c -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brown, Daniel Sent: Thursday, July 17, 2008 3:26 PM To:

[sqlite] SQLite3.exe preprocessed source?

Hello List, Is there anywhere I can get the pre-processed C source for the SQLite3.exe console application? I don't have tcl/make set-up here meaning I can't generate the source myself so I've just been working with the pre-processed source files available on the website but these don't seem to

[sqlite] Returning a boolean

How does one return a boolean value from a custom function, so that expressions like 'select * from table where foo()' operate as expected? There's no sqlite_result function for boolean...which I understand is actually not a native type. I tried returning 'True' and 'False' but that seemed to

Re: [sqlite] Inconsistent error: "temporary storage cannot be changed from within a transaction"

On Thu, Jul 17, 2008 at 12:53 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > The error only occurs if the temp_store value really is trying to > change. If the new temp_store value is the same as the old, no error > is generated. Are you sure you had not already issued the PRAGMA once >

[sqlite] Download 3.5.9 version - how to build the library

Hi All, Currently we are using 3.5.2 version and I would like to use SQLite 3.5.9 for our product. Would you please direct me where to find out the release note for 3.5.9 and the instruction how to build the library after downloading the source code of 3.5.9. Thanks JP

Re: [sqlite] Inconsistent error: "temporary storage cannot be changed from within a transaction"

On Jul 17, 2008, at 12:11 PM, Samuel Neff wrote: > We're inconsistently getting this error: > >PRAGMA temp_store = MEMORY > ---> System.Data.SQLite.SQLiteException: SQLite error > temporary storage cannot be changed from within a transaction > > We now realize that we are in fact issuing the

Re: [sqlite] Scour.com invite from harish

> -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of harish > Sent: Thursday, July 17, 2008 1:17 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Scour.com invite from harish > > Hey, > > Did you hear about Scour? It is the next gen

Re: [sqlite] ANN: SQLite .NET provider updated

I have to say SQLite.NET, like SQLite itself is an incredible piece of software. - Original Message > From: Harold Wood <[EMAIL PROTECTED]> > To: General Discussion of SQLite Database > Sent: Wednesday, July 16, 2008 11:46:29 PM > Subject: Re: [sqlite] ANN:

[sqlite] Inconsistent error: "temporary storage cannot be changed from within a transaction"

We're inconsistently getting this error: PRAGMA temp_store = MEMORY ---> System.Data.SQLite.SQLiteException: SQLite error temporary storage cannot be changed from within a transaction We now realize that we are in fact issuing the PRAGMA inside a transaction, but the weird thing is it works

Re: [sqlite] Help with BLOBs

Dan wrote: > It's a hexadecimal representation of a blob of data. The literal X'ABCD' > is a blob of length 2 bytes. The first byte is 0xAB, the second is 0xCD. > > OK, that makes sense, but I'm still having issues. Let me explain exactly what I'm doing so hopefully it can help you help me.

Re: [sqlite] help

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Can I set username and > password to SQLite db file? http://www.hwaci.com/sw/sqlite/prosupport.html#crypto http://sqlite-crypt.com/ http://sqlcrypt.com/ Not an endorsement, I haven't personally used any of these products. Igor

[sqlite] help

Hello, I'm developing a small java security application. In this application, I need a small database to store email address and password. SQLite is prefect to my application. Can I set username and password to SQLite db file? If I can, tell me the lines of code to set Thanks & Regards

[sqlite] Does changing the db change result sets?

Hello, What happens if 1. I prepare and execute a select statement 2. I retrieve a couple of rows 3. I execute a new query that would change the result of the query in 1 4. I continue to retrieve the results of 1) Will I get the results as if step 3 hasn't happened, is the result