Re: [sqlite] Ultimate noob question: What do I do to reference another table?
you need several tables, then you can refernce them thru a view to show what is related to what. --- On Fri, 7/18/08, LMcLain <[EMAIL PROTECTED]> wrote: From: LMcLain <[EMAIL PROTECTED]> Subject: [sqlite] Ultimate noob question: What do I do to reference another table? To: sqlite-users@sqlite.org Date: Friday, July 18, 2008, 1:33 AM 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 different table's list of manufacturers and then have that field address that record. I hope that I am making sense, but I wouldn't be surprised if I'm not! :/ I can't figure out how to do it or even what the terminology for this process is so that I can look it up myself! Please help! Thanks, Lee -- View this message in context: http://www.nabble.com/Ultimate-noob-question%3A-What-do-I-do-to-reference-another-table--tp18522905p18522905.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] how can i get values from sqlite db?
kriscbe wrote:
> 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 .
>
>
If you use sqlite3_exec, you must specify a pointer to a callback
function (which must use the same calling convention as sqlite3_exec,
typically cdecl on Unix-ish operating systems) as the 3rd argument in
the call to sqlite3_exec. That function is called once for each row of
the result set and receives pointers to where the retrieved data is
stored. The function must have this signature:
int my_exec_callback(void* pUserData, int numCols, char** pzValues,
char** pzColNames)
pUserData gets passed through unmodified from the 4th argument of the
sqlite3_exec invocation.
numCols holds the number of columns in the result set (i.e., the length
of the pzValues and pzColNames arrays.)
pzValues points to an array of NUL-terminated UTF-8 strings holding the
results, in order.
pzColNames points to an array of NUL-terminated UTF-8 strings holding
the names of each column from the result set, in order.
For more details, see http://sqlite.org/c3ref/exec.html
In your case, you will need to place "value" outside of the function
scope, to where your callback can safely access it.
HTH
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Download 3.5.9 version - how to build the library
Joanne Pham wrote: > Hi All, > Hi there. > 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 http://www.sqlite.org/changes.html http://www.sqlite.org/cvstrac/rlog?f=sqlite%2Fsrc%2Fos.c&sms=1 > and the instruction how to build the library after downloading the source > code of 3.5.9. > http://www.sqlite.org/cvstrac/fileview?f=sqlite/README&v=1.9 http://www.sqlite.org/compile.html http://www.sqlite.org/cvstrac/wiki and look at the third section, Notes On Compiling SQLite. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 different table's list of manufacturers and then have that field address that record. I hope that I am making sense, but I wouldn't be surprised if I'm not! :/ I can't figure out how to do it or even what the terminology for this process is so that I can look it up myself! Please help! Thanks, Lee -- View this message in context: http://www.nabble.com/Ultimate-noob-question%3A-What-do-I-do-to-reference-another-table--tp18522905p18522905.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 want return the value from sqlite database to a variable in my c++
> application.
> how can i achieve this ??
>
> thanks
> krish
>
--
View this message in context:
http://www.nabble.com/how-can-i-get-values-from-sqlite-db--tp18522381p18522423.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] how can i get values from sqlite db?
hi everyone, i am using linux. i want return the value from sqlite database to a variable in my c++ application. how can i achieve this ?? thanks krish -- View this message in context: http://www.nabble.com/how-can-i-get-values-from-sqlite-db--tp18522381p18522381.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 >>> 3. I execute a new query that would change the result of the >>>query in 1 >> >> On the same connection, I assume. >> >>> 4. I continue to retrieve the results of 1) >>> >>> Will I get the results as if step 3 hasn't happened, is the result >>> undefined, or will my result set somehow be updated? >> >> You may or may not see the changes introduced by step 3. E.g. if >> step 3 updates a record that you've already visited, you naturally >> won't visit it again and thus won't see the changes. But if it >> updates a record you haven't visited yet, when you get to it you >> will see the new data. > > Hmmm, that does not seem right, but what do I know. The reason I say > this is because if the update change a column value on a record the > would cause it to ne not selected or it changes some other that had > not been selected before but would be after the change I'm not sure > how these would magically get included or excluded. SQLite doesn't prepare the whole resultset up front, but retrieves records on demand - one record for every sqlite3_step call. If the record matches the conditions by the time the statement gets to it, it will be returned. If not, it will be skipped. > I assume the when you make a query your results on in a set of data > the is private to your session/connection and that other transactions > on the database can not change you private data. ... but the same connection within the same transaction can. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 same connection, I assume. > >> 4. I continue to retrieve the results of 1) >> >> Will I get the results as if step 3 hasn't happened, is the result >> undefined, or will my result set somehow be updated? > > You may or may not see the changes introduced by step 3. E.g. if step 3 > updates a record that you've already visited, you naturally won't visit > it again and thus won't see the changes. But if it updates a record you > haven't visited yet, when you get to it you will see the new data. Hmmm, that does not seem right, but what do I know. The reason I say this is because if the update change a column value on a record the would cause it to ne not selected or it changes some other that had not been selected before but would be after the change I'm not sure how these would magically get included or excluded. I assume the when you make a query your results on in a set of data the is private to your session/connection and that other transactions on the database can not change you private data. But I'm not an expert on this stuff. -Steve ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 continue to retrieve the results of 1) > > Will I get the results as if step 3 hasn't happened, is the result > undefined, or will my result set somehow be updated? You may or may not see the changes introduced by step 3. E.g. if step 3 updates a record that you've already visited, you naturally won't visit it again and thus won't see the changes. But if it updates a record you haven't visited yet, when you get to it you will see the new data. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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-users@sqlite.org Subject: [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 include the sqlite3 application which I'd really like to have. I'm specifically interested in the source of the application for SQLite 3.5.1 and 3.6.0. Cheers, Daniel Brown "The best laid schemes o' mice an' men, gang aft agley" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 include the sqlite3 application which I'd really like to have. I'm specifically interested in the source of the application for SQLite 3.5.1 and 3.6.0. Cheers, Daniel Brown "The best laid schemes o' mice an' men, gang aft agley" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Returning a boolean
Never mind, returning integer 1 or 0 works. Should have tried that before asking. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 wind up being typed as text. Dan Winslow ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 > before, prior to starting the transaction? > > > D. Richard Hipp > [EMAIL PROTECTED] > > We searched our entire codebase and that is only set in one place and always within a transaction (yes, bad, we'll fix it for future builds). Even in our unit testing we queried the value before our call and it was 0, we confirmed we were in a transaction, then we issued the pragma without error, and requeried the value and got back 2. I don't know if that is considered a change though--if 0 (default) results in being memory and then explicitly changing it to memory. We're on Windows XP and 2003 using sqlite 3.5.9 built from amalgamation and sqlite.net 1.0.48.0. Thanks, Sam - We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer in the Washington D.C. Contact [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 PRAGMA inside a > transaction, > but the weird thing is it works without error on a half dozen > development > boxes, half dozen test boxes, and a few dozen or so client computers > that > have this version. Only one client computer fails with this error. 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 before, prior to starting the transaction? D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 search engine with > Google/Yahoo/MSN results and user comments all on one page. Best of all > we get paid for using it by earning points with every search, comment > and vote. The points are redeemable for Visa gift cards! It's like > earning credit card or airline points just for searching! Hit the link > below to join for free and we will both get points! > > http://scour.com/invite/harishdixit1/ > > I know you'll like it! > > - harish [Sherief N. Farouk] Are you, seriously: spamming a development mailing list, using your @corp.scour.com email to do so, with a link that ends in /invite/? If I couldn't get funding for my stab/IP system before, I think I will now. - Sherief ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 .NET provider updated > > wow, can i nominate you for sainthood? i mean really! i was trying to use > esql > and its a mess...ug! > > thanks! > > Woody > > > --- On Wed, 7/16/08, Robert Simpson wrote: > > From: Robert Simpson > Subject: Re: [sqlite] ANN: SQLite .NET provider updated > To: "'General Discussion of SQLite Database'" > Date: Wednesday, July 16, 2008, 10:27 PM > > Sure does! > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Harold Wood > Sent: Wednesday, July 16, 2008 7:20 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] ANN: SQLite .NET provider updated > > very very cool! now does it work with teh compact framework? > > --- On Wed, 7/16/08, Robert Simpson wrote: > > From: Robert Simpson > Subject: [sqlite] ANN: SQLite .NET provider updated > To: "'General Discussion of SQLite Database'" > > Date: Wednesday, July 16, 2008, 8:22 PM > > I don't normally announce releases here, but this one's got some great > stuff > in it. Those of you using the SQLite ADO.NET provider will want to check > out. > > Some highlights in the 52 release: > 3.6.0 code merge > Table and View designers - you can now create and design tables and views, > indexes and foreign keys from the Visual Studio Server Explorer with a nice > interactive GUI. This is still in beta, but it's looking really good. > Trigger designer is coming up soon. > Entity Framework support much improved from the 51 release. Still in beta > while Visual Studio 2008 SP1 is in beta. > > It's public domain, it's open source, and 3.5 years stable. Why buy a > SQLite ADO.NET provider from someone else? > > http://sqlite.phxsoftware.com > > Robert > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 without error on a half dozen development boxes, half dozen test boxes, and a few dozen or so client computers that have this version. Only one client computer fails with this error. We issue the hardware and image the machines so all computers are the same, only the data on them is different. We're not sure why this error doesn't occur on all boxes. We stepped through our unit test that covers this code and confirmed that in fact even in development there is a transaction already in place prior to this statement and that the value is changing (from 0 to 2). So besides having a transaction in place, what exatly triggers this message? We'll move the code for future versions but are trying to identify why it fails only for this one client machine and if we can get them working without waiting for the next version of our software. Thanks, Sam - We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer in the Washington D.C. Contact [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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. :) I'm using DataMapper which, at the moment, has no BLOB support or any significant SQLite-specific functionality. I'm trying to add support for binary data to DM. Internally I'm representing binary data as strings, and DM's custom types mechanism lets me define serialize/deserialize methods for the new type. At the moment I have binary data correctly serializing/deserializing to hex that works fine in ruby. My current project uses spatialite and georuby, manipulating geometry objects in binary form. The geom binary is being correctly serialized/deserialized such that georuby can manipulate the object fine when it is pulled back out of the database, so my hex is fime, but sqlite just isn't storing it as binary. When I drop to the sqlite console, spatialite doesn't recognize the binary data as valid. Similarly, when I select from the tables, I get an actual string of the hex rather than nothing at all for the binary column, the latter being what I see in the spatial test database. I tried some experiments from the command line, basically attempting to set the geometry column to: "0x010x020x00", '0x000x010x020x00', "X00X01X02X00", 'x00x01x02x03' Basically any variation of quoting and hex notation I could think of. No dice. > If possible, it is easier to use sqlite3_bind_blob() (or whatever the > ruby equivalent is) to insert binary data. > > Unfortunately I think this may be a bit too low-level for DM. There isn't much database-specific functionality, so I'm looking at using strings and serializing/deserializing my binary data via ruby. Is this possible? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 Satish B Software Engineer Prodigy Systems & Services ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 undefined, or will my result set somehow be updated? Thanks in advance, -Nikolaus -- »It is not worth an intelligent man's time to be in the majority. By definition, there are already enough people to do that.« -J.H. Hardy PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
