[sqlite] Sqlite subqueries

A Google search for "USS Yorktown" turned up the following: "On September 21, 1997, a division by zero error on board the USS Yorktown (CG-48) Remote Data Base Manager brought down all the machines on the network, causing the ship's propulsion system to fail." RobR -Original Message-

[sqlite] Did A Recent Windows & Update Affect SQLite???

I have to challenge one of your statements. Adobe Camera Raw is not nearly identical to Lightroom. ACR is Lightroom's editing engine. When you are editing an image in Lightroom, you are using ACR. ACR has no need for a database of any kind, unless the XMP file contains a very tiny database.

[sqlite] Colons (was: RE: Groups and members)

In Igor's post below, what is the meaning of the colon in front of mypid? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Wednesday, November 06, 2013 8:45 AM To: sqlite-users@sqlite.org Subject:

Re: [sqlite] Bug in division?

I don't know if it's in the SQL standard or not, but the C, C++ and C# languages all act this way. The result of mathematical operations on integers is always an integer. If you want the result to be a floating-point number, you have to force at least one of the operands to be a

Re: [sqlite] how to write this commands?

Igor, It took me a bit of looking, but I think I understand your query. One question remains: why did you use the max() function? Thanks! RobR -Original Message- update adla1 set PFLOPF=( select case count(*)=1 then max(adl.pflopf) else adla1.pflopf end from adl where

Re: [sqlite] Sqlite querie delete bug

This doesn't sound like an SQLite problem to me. Instead it sounds like a problem with whatever visualization tool you are using. What tool are you using? If you can find a user's group for that tool, you may get more helpful answers there. RobR -Original Message- From:

[sqlite] How can I get my query to run as fast as SQLiteSpy?

e the same trick? Also, my version of the sqlite library code only has an sqlite3_get_table() method that uses single-byte characters. Does the latest code have a Unicode version of this method? Thank you very much. Rob Richardson -Original Message- From: Will Leshner [mailto:[EMAIL

[sqlite] Why does "SELECT julianday('some_date') AS dateNumber" get me a string via ODBC?

Greetings! I am trying to talk to a small SQLite database through ADO and an ODBC driver. I want to convert a date to a Julian day before using the date in a query of a table that could have over a million records. In SQliteSpy, the query "SELECT julianday('2007-06-05 12:34:56', 'localtime')

[sqlite] DSN-less connection string

river was specified. I downloaded and installed the ADO.Net provider, but I did not see anywhere anything telling me what provider name to use with it. I can't use a DSN because the database to be opened must be selected by the user at run time. How d

[sqlite] Why is there no sqlite3_exec16() method?

API that does have that method? Thank you very much. Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Re: Why is there no sqlite3_exec16() method?

n clean up by calling sqlite_finalize? Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] What happens when a table with an active statement is changed?

? Will the repeated sqlite3_step() calls on the first statement eventually get the new record? Or do I just need to be careful that I never have two active sqlite statements referencing the same table? Rob Richardson

RE: [sqlite] What happens when a table with an active statement is changed?

It seems this was discussed just a few days ago. A recent upgrade to SQLite allows inserts, updates and deletes on tables that are also open for selection. The changes may or may not appear as I call sqlite3_step(), but I can live with that. RobR

[sqlite] How can I convert from Julian time to a tm structure?

oing to do? Thank you very much. Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] How can I convert from Julian time to a tm structure?

All right. Smack me upside the head again. I deserve it. SQLite is open source, so I just had to look in the source code. RobR - To unsubscribe, send email to [EMAIL PROTECTED]

RE: [sqlite] How can I convert from Julian time to a tm structure?

-prone to me. While I am quite confident that you and your collaborators checked this code carefully, I would like to see an explanation of this algorithm to understand it more fully. Maybe I'll see if I can get the book through an inter-library loan someplace. Rob Richardson

[sqlite] Sharing an in-memory database between applications

the idea) statements. Thank you very much. Rob Richardson RAD-CON INC. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Wrong column type being returned

imal point is getting truncated when I read it. Can anyone tell me why SQLite suddenly thinks this column of floating-point data holds only integers? Thanks very much! Rob Richardson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.or

[sqlite] sqlite3_interrupt() and threads

the sqlite3_step() that I want to interrupt, or is there some other mechanism I can use, or is there no way to do this? Thanks very much! Rob Richardson Rad-Con, Inc.

RE: [sqlite] sqlite3_interrupt() and threads

to be used for? OK, three questions: Is there a way to run sqlite3 queries asynchronously? Thanks again! Rob Richardson Rad-Con, Inc.

RE: [sqlite] sqlite3_interrupt() and threads

Great! That looks like exactly what I need. Thanks very much! Rob Richardson RAD-CON INC. -Original Message- From: Michael Scharf [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 10:45 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3_interrupt() and threads Hi

RE: [sqlite] sqlite3_interrupt() and threads

Michael, I notice in the documentation that the sqlite3_progress_handler() method is marked "experimental". Is that significant? Rob

[sqlite] Reading the same table from two threads

in the previous 24 hours. The second thread is probably started only a few milliseconds after the first one. I am getting an access violation inside sqlite3.dll when the second thread calls sqlite3_prepare(). Am I trying to do something I shouldn't? Thanks very much! Rob Richardson Rad

RE: [sqlite] Reading the same table from two threads

: Re: [sqlite] Reading the same table from two threads On 7/26/06, Rob Richardson <[EMAIL PROTECTED]> wrote: > few milliseconds after the first one. I am getting an access violation > inside sqlite3.dll when the second thread calls sqlite3_prepare(). Am I > trying to do someth

RE: [sqlite] Reading the same table from two threads

I found the spot where I was telling the two threads to use the same database pointer instead of running on separate ones. Once I fixed that, it works. Thanks for your help. Rob Richardson Rad-Con, Inc. -Original Message- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Wednesday

[sqlite] Can I use internal variables in SQL scripts?

much! Rob Richardson RAD-CON, Incv.

RE: [sqlite] Can I use internal variables in SQL scripts?

Christian, Thank you for your reply. I will be happy to develop stored procedure capability for SQLite in my copious spare time. :-) Don't hold your breath. RobR -Original Message- From: Christian Smith [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 10:10 AM To:

[sqlite] The meaning of times in julianday()

ose conclusions correct? And I presume the datetime() method operates the same way? Thanks again! Rob Richardson RAD-CON INC.

RE: [sqlite] starting with unicode

No, you don't need sqlite3_reset() inside the loop. The pseudocode should be: open prepare loop while not at end of file step read repeat finalize close For the "read" portion, use the sqlite_column_xxx() methods. And wrap every single string in your

[sqlite] How can I tell what version of SQLite a database was created with?

Greetings! I have an SqLite database file that cannot be opened in my application or with SQLiteExplorer. Both of them report "Unsupported file format". However, it can be opened with SQLiteSpy. If I open it in Visual Studio's hex editor, I see that the first few bytes of the database file

[sqlite] sqlite3_interrupt()

I have a thread that executes a query that takes about 30 seconds on my test setup. In the field, the query could take several minutes. The user needs to be able to stop this query if it was started by accident. I have a pointer to the sqlite3 object that is running the query inside my thread.

RE: [sqlite] sqlite3_interrupt()

Dr. Hipp, Thanks for your reply. The question of which version I'm using is up in the air right now. I threw a call to sqlite3_libversion() into my application, and it returned "3.2.1". I asked our lead developer (who's in Indiana while the rest of us are just west of Cleveland, OH) what

RE: [sqlite] sqlite3_interrupt()

:05:07 2006 Rob Richardson RAD-CON INC. - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] sqlite3_interrupt()

use in the interrupt call, I'll let you know how it works. Rob Richardson RAD-CON INC. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] sqlite3_interrupt() works

Greetings! After installing SQLite 3.3.7 and making sure I was passing the correct pointer to sqlite3_interrupt(), I got it to work. Rob Richardson RAD-CON INC.

[sqlite] "Invalid or corrupt file" when building .lib file for version 3.3.7 dll

Greetings! I am using MS Visual Studio 6 under the Windows XP pro operating system. I downloaded the dll for version 3.3.7. I tried to run Lib to build the .lib file for the dll. Here's the command line: lib /machine:i386 sqlite3.def This was run with the folder containing

[sqlite] Stripping a newline character

should I do this? Thanks very much! Rob Richardson RAD-CON INC.

RE: [sqlite] Stripping a newline character

Please forgive my idiocy. I was more tired than I thought. First, I posted this message to the wrong mailing list (I wanted a Python list), and second, I made a dumb, silly assumption about how the method worked. RobR

RE: [sqlite] Bug in SQlite ?

What assertion failure are you seeing? What is the exact message? Can you use a debugger to step into the code where the assertion failure happens? RobR - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Can primary key columns be altered to use autoincrement?

not possible to alter a column at all. There's no ALTER COLUMN clause available for the ALTER TABLE statement. Is that correct? Thank you. Rob Richardson RAD-CON INC. - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Creating a database from inside a program

won't work from a DOS prompt, I'm sure it won't work from my program. So, what is the recommended way to create a new database and its schema from inside a program? In case it matters, I'll be using Visual C# 2005 and the SQLite.net.dll file from SourceForge. Thank you very much! Rob Ric

[sqlite] SQlite3.exe .dump doesn't do anything for me

bles in my database? Thank you very much. Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

somebody please point me to one or the other? Thank you very much. Rob Richardson - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

I can't get SQLiteExplorer to work with my databases. It always gives me an "unknown file format" error. I believe it's been quite a while since it was updated. RobR -Original Message- From: Griggs, Donald [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 3:14 PM To:

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

For the life of me, I can't figure out how to open a database in DBManager. I looked at it before, tried for an hour, and erased it. I just tried again, with the same result. If I can't figure out how to do such an easy thing, I can't trust the program. RobR -Original Message- From:

[sqlite] Major memory leak

Greetings! I must be doing something wrong. I've got a simple table with three columns, a key column, a value column and a timestamp column. There are 357,000 rows. The timestamps are stored as floating-point numbers (Julian dates), and the other two fields contain integers. I open the table,

[sqlite] Major memory leak

Greetings! I must be doing something wrong. I've got a simple table with three columns, a key column, a value column and a timestamp column. There are 357,000 rows. The timestamps are stored as floating-point numbers (Julian dates), and the other two fields contain integers. I open the table,

Re: [sqlite] Major memory leak

My SQLite library is built from the single translation unit sqlite.c/sqlite.h. That file contains the version number 3.3.17. I do not have valgrind, but circumstantial evidence that this is a SQLite problem is strong. When stepping through my code, I see that my application's memory jumps by

Re: [sqlite] Major memory leak

. RobR On 3/23/08, Christian Smith <[EMAIL PROTECTED]> wrote: > On Fri, Mar 21, 2008 at 10:41:10AM -0400, Rob Richardson wrote: > > My SQLite library is built from the single translation unit > > sqlite.c/sqlite.h. That file contains the version number 3.3.17. > >

Re: [sqlite] newest 3 entries

Select id, eventdate, eventtype, FROM eventlog WHERE eventtype in ('special') order by eventdate desc limit 3 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of deltagam...@gmx.net Sent: Thursday, November 08, 2012 3:10 PM To:

Re: [sqlite] VC++ and SQLite

I always turn pre-compiled headers off for every VC++ project. In my opinion, they are artifacts from a time when processors were a few hundred times slower than they are now. The benefit in time saved now is far less than the confusion they cause when something goes wrong. RobR

Re: [sqlite] memory leak in transactions

Do you have your inserts wrapped in a single transaction? It used to be that I wasn't worrying about transactions in my projects, but I noticed things were very slow. I realized that it was creating and committing one transaction for each insert I was doing. When I wrapped all inserts into a

Re: [sqlite] Simple SQLite-based spreadsheet?

There's several GUI-based SQLite tools available now. Maestro was already mentioned. My favorite is SQLiteSpy because it's fast, even though you can't insert or update data in its grid view (you have to write insert or update queries to do that, which I admit is a pain, but most of the time

Re: [sqlite] Mapping Sqlite INTEGER field to C# Nullable

Seems like a strange thing for VS Designer to do. NULL is not 0. RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Quanren Xiong Sent: Thursday, January 03, 2013 12:30 PM To: General Discussion of SQLite Database

Re: [sqlite] looking up records with terms in a table

I think you need wildcards: SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE %T2.Terms% RobR, not guaranteeing correct syntax -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assche Sent: Tuesday, March 26,

Re: [sqlite] (no subject)

First idea: include a subject line. I'm not 100% clear on your message. You said: " For those entries in table1 where there is a null in t2..." I'm guessing you wanted to say: " For those entries in table1 where there is a null in t1..." Is that right? RobR

Re: [sqlite] SQLite NULL or 0-Length

Simon, Is there a danger here if firstname is NULL and the LENGTH() function is called first? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, May 23, 2013 2:54 PM To: General Discussion

Re: [sqlite] GUI for SQLite

Not all of us. Thanks for the list. RobR, SQLiteSpy user and about to find Navicat. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] updating using a value from another table

Your query looks good to me, which probably means I'm missing the same thing you are. What happens when you run this query? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dean gwilliam Sent: Monday, October 07, 2013

Re: [sqlite] updating using a value from another table

Thank you. Now, can you show us sample data from your tables before this query is run? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dean gwilliam Sent: Monday, October 07, 2013 10:45 AM To: sqlite-users@sqlite.org

[sqlite] How complicated can trigger statements be?

The example of a CREATE TRIGGER statement from the help page is: CREATE TRIGGER update_customer_address UPDATE OF address ON customers BEGIN UPDATE orders SET address = new.address WHERE customer_name = old.name; END; The use of BEGIN and END to wrap the statement leads me to believe

[sqlite] Can I check the auto-vacuum setting on an SQLite database?

My deepest apologies for forgetting to change the subject line in my last post, and thus accidentally hijacking a thread. Here is the message again, this time with the correct subject. On Wed, Feb 8, 2012 at 8:44 AM, Rob Richardson <cedriccic...@gmail.com> wrote: > Greetings! > >

Re: [sqlite] Database locked in multi process scenario

Isn't it almost a requirement of a transaction that only one be open at a time in a database? If there could be more than one transaction, then transaction 1 might start, transaction 2 starts, transaction 1 fails, transaction 1 is rolled back, and what happens to transaction 2? One could

Re: [sqlite] Able to differentiate between No query and empty results?

-Original Message Also, Stephan is quite right: it's not the columns but the values which have datatypes, and if you're looking at some random SQLite database that wasn't carefully created the value in r1c1 may be an integer but the value in r2c1 may be text. Simon.

[sqlite] A faster way to insert into a keyless table?

Greetings! I am working on updating an application that has been around for years, originally written by someone who knew SQLite exists but had very little idea of how to use it. The application monitors OPC information for 124 bases, with 7-10 tags per base. (Don't worry about what a base

Re: [sqlite] A faster way to insert into a keyless table?

PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A faster way to insert into a keyless table? On Feb 14, 2012, at 8:01 PM, Rob Richardson wrote: > What would be the best way to speed this up? wrap all your inserts in one transaction. commit at the

Re: [sqlite] SQLiteDataAdaptor Missing

In another library, I had to specify "x86" processor because it wasn't designed for 64-bit machines. Might you need to do that? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Electric Eddy Sent: Monday, February 20,

Re: [sqlite] accessing multiple databases

IIRC, there's a connection string option that will choose between creating an empty database and throwing an exception if you try opening a database that doesn't exist. Perhaps if that option is set to throw an exception, then the ATTACH command would fail. Or not. RobR

Re: [sqlite] Views and Performance

What kind of JOIN is used when it a type (INNER, OUTER, etc.) is not specified? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Duquette, William H (318K) Sent: Friday, March 02, 2012 11:23 AM To: Discussion of

[sqlite] What do people think of SQLite Root?

Our company typically uses SQLite Spy for managing SQLite databases. I keep hoping to find something better, because SQLite Spy does not offer the ability to edit a table inside a grid. The only way to update data is to use an SQL UPDATE statement. But nothing else offers the speed of

Re: [sqlite] What do people think of SQLite Root?

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ralf Junker Sent: Monday, March 05, 2012 9:48 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] What do people think of SQLite Root? On 05.03.2012 14:50, Rob Richardson wrote: > I keep hoping to find something better, beca

Re: [sqlite] What do people think of SQLite Root?

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ralf Junker Sent: Monday, March 05, 2012 10:37 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] What do people think of SQLite Root? On 05.03.2012 16:11, Rob Richardson wrote: > With the latest version, I think you can. SQLiteSpy g

[sqlite] Best LINQ provider for SQLite?

Greetings! What is the best LINQ provider for SQLite? I'm sorry for posting a question that must have been asked several times in the past, but the archives of this group do not appear to be searchable. If there is a way to search the archives, could someone please show me? RobR

[sqlite] No error message generated by sqlite_exec()

Hello! I am sending a badly formed query string to sqlite_exec(). It is giving me error 21 (misuse of library), but it is not giving me an error message. The value of the pointer sent as the fifth argument of sqlite_exec() is not changed. Is this expected behavior? Is there something I

Re: [sqlite] No error message generated by sqlite_exec()

: [sqlite] No error message generated by sqlite_exec() On Tue, Mar 13, 2012 at 6:43 PM, Rob Richardson <rdrichard...@rad-con.com>wrote: > Hello! > > I am sending a badly formed query string to sqlite_exec(). It is > giving me error 21 (misuse of library), but it is not

Re: [sqlite] No error message generated by sqlite_exec()

Thank you, Dr. Hipp. I understand. RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, March 13, 2012 7:07 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] No error message

Re: [sqlite] Sqlite error message

You may want to add "FailIfMissing=true" to your connection string. It always surprises me when I successfully connect to a database and then an attempt to read from a table that I know durn well is there fails. RobR -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Visual Studio 2008 Express and sqlite3.c

This leads me to agree with the person who suggested that a #define someplace is telling the precompiler to change "not" to something else. There is a compiler setting that will generate a file with an extension of ".i" that is the output of the precompiler. You could try doing that and

Re: [sqlite] table names

In SQLite Expert, I created table "12-345" with no problem, but I noted that when the new table was displayed, its name was wrapped in square brackets: "[12-345]". Perhaps you could wrap numeric names in brackets similarly. Good luck! RobR ___

Re: [sqlite] Integer Truncation Issue

Disclaimer: I am not in any way an expert! As I understand things, in SQLite, any value can be stored in any column, regardless of type. But in C#, the System.Data.SQLite library isn't that flexible. If the table definition says the column contains integers, then all data in the table is

Re: [sqlite] auto-incrementing integer in composite primary key

If you deleted record on New Year's Day, you want a query for data on New Year's Eve to find the record but you don't want a query for data on January 2nd to find it. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel

Re: [sqlite] Details on New Features

Gabor Grothendieck mentioned a new feature of SQLite in 3.7.11: Queries of the form: "SELECT max(x), y FROM table" returns the value of y on the same row that contains the maximum x value. Is that standard SQL behavior? I'd have expected that to return one row for every row in the

Re: [sqlite] How do you access a specific row of a resultset?

The other thing you are not thinking about is that you never know the order of data in a set. You may think that you want the 5th record that was ever inserted into the table, but you have no guarantee that a select statement will return records in the order in which they were inserted. The

Re: [sqlite] ADO.NET Provider, targeting any cpu

-Original Message- The System.Data.SQLite managed-only assembly, when the native library pre-loading code is enabled (which it is by default starting with release 1.0.80.0), will now attempt to detect the processor architecture of the process it is being loaded into and then it will

Re: [sqlite] cann't work

Does SQLite care about the use of double quotes instead of single quotes? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Davies Sent: Wednesday, July 11, 2012 5:10 AM To: General Discussion of SQLite Database

Re: [sqlite] Syatem.Data.SQLite Exception/Error handling viaTry...Catch

I have some vague memory that exception handling is screwy inside constructors, and it's better to create a naked object and then fill it in in an Init() method. But I have no idea where I read that, if it's correct, or even which language it applies to. Good luck! RobR

Re: [sqlite] MIN() for a timedelta?

See below. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, July 26, 2012 8:47 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] MIN() for a timedelta? On 27 Jul 2012, at

Re: [sqlite] no such function problem

This is a C question, not an SQLite question. But I'll answer it anyway. You included the function call in your quoted string, so your compiler thinks it's just random text. You need: sprint(sql, "insert into student select 3, %s, 22;", ldll("bb")); RobR

Re: [sqlite] sqlite3_stat problem

Return values are your friends. Use them. Store the error code from every sqlite function call, and if the error code is not SQLITE_OK (NOTE: Check that that is the correct name.), then display what the error code is. In particular, what is the return value of your sqlite3_bind_text()

Re: [sqlite] SQLITE_STATIC and temporary data

Is "acceptable" good enough? I admit I haven't played with this function (actually, I never heard of it until today), but from what I read in the documentation, the case described looked dangerous to me. SQLITE_STATIC seemed to me to imply that the contents of the memory used by the sqlite

Re: [sqlite] sqlite3_stat problem (YAN HONG YE)

OK for now, but for how long? I still think that 140 is going to come back and bite you in the rear end sometime when you're not expecting it. As I understand it, you have a short collection of bytes that is the result of encrypting a short string. You have much less than 140 bytes of data

Re: [sqlite] AUTO_INCREMENT error

Don't you have to specify a column type for test_1? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Brandon Pimenta Sent: Friday, August 03, 2012 9:09 AM To: sqlite-users@sqlite.org Subject: [sqlite] AUTO_INCREMENT

Re: [sqlite] Select rows where a column is not unique

Igor, Which of those would be fastest? Or don't you have enough information to tell? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, August 06, 2012 9:14 AM To: sqlite-users@sqlite.org

Re: [sqlite] to table update

Are you certain there exist rows in tb1 and tb2 that satisfy the condition? What happens when you try? Is any error message or number returned? Can you run the same query inside an SQLite management tool like SQLite Spy? Does it work there? Please provide us ALL of the relevant information

Re: [sqlite] why no such column in sqlite3 ?

Put single quotes around Testitem: sprintf( sqlquery, "INSERT INTO tblTest ( CINDEX, CDATE, CDESCR, CAMOUNT ) VALUES ( 5, 2012-08-29, 'Testitem', 300 )"); RobR ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] classic update join question

Well, I think you want a where clause on your main UPDATE query. What you wrote will set the frequency of every record in the alpha table to the value from the beta table, for every record in the beta table that matches an alpha record. (It's late, I'm tired and that's incoherent. I hope you

Re: [sqlite] classic update join question

Many thanks to all of you who took the time to correct my misunderstanding of basic SQL. I ran a little test in PostgreSQL (which is the quickest thing I have to play with), and of course, you are all correct and the query does work as designed. I was trying to figure out how to think about

Re: [sqlite] C++ - WHERE clause - update

What is the value returned from sqlite3_step()? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Arbol One Sent: Thursday, September 06, 2012 12:14 PM To: 'General Discussion of SQLite Database' Subject: [sqlite] C++ -

Re: [sqlite] C++ - WHERE clause - update

Discussion of SQLite Database' Subject: Re: [sqlite] C++ - WHERE clause - update Is this a tricky question? int sqlite3_step(sqlite3_stmt*); -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Richardson Sent: Thursday, September

Re: [sqlite] Reducing size

Why are you concerned about the size of sqlite3.o? RobR ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   >