[sqlite] pls dont send so many message - once a month is enough

. For systems/accounts which are setup to handle that protocol, clicking the link in most modern browsers will invoke the setup email client, with the correct addressee to reach the list. (I have used that mailto: link for this message, in fact.) Best regards, -- Larry Brasfield

Re: [sqlite] pls dont send so many message - once a month is enough

Ketil Froyn writes: Clicking the mailto works, but it's not a proper reply-to. These two messages have appeared as a separate thread in my mailbox, probably because Larry's message didn't add the proper message-id reference. So if you reply like this on a high volume list, people following

Re: [sqlite] Is there a way to load a blob from the shell?

About my shell extension implementing .blobextract and .blobreplace commands, Richard Hipp writes: apparently uses the incremental BLOB I/O interface to avoid the need to load entire images into memory. and That is nice, but on a modern workstation with many GB of RAM, is it really necessary?

Re: [sqlite] Is there a way to load a blob from the shell?

. (zeroblob(filesize)) -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a way to load a blob from the shell?

to be transferred without creating large, in-memory objects. So my shell enhancement exploits the streaming API, using only a few pages of memory. I sort of like your approach, and maybe there is a way to get the best of your's and mine. Any ideas? -- Larry Brasfield

Re: [sqlite] Noticed crash on windows

durga.disc wrote: We have an application on unix platform with sqlite database which is running from last 2 years. pretty well. We recently ported on Windows too. Crashed at inserting record in a small database(less than 20 records, record has 10 columns). It's not reproducible. call

Re: [sqlite] extension search [was ... release schedule]

*Jan Nijtmans wrote:* But not in dlopen(): See: http://man7.org/linux/man-pages/man3/dlopen.3.html Quoting: If filename contains a slash (/), then it is interpreted as a (relative or absolute) pathname. Otherwise, the dynamic linker searches for the library as follows

Re: [sqlite] SQLite version 3.8.4 release schedule

Jan Nijtmans wrote, in part, re Cygwin : * *bare filenames are NOT expected to be found in the current directory This makes Cygwin unique among all operating systems with which I am familiar having support for hierarchical filesystems. Most importantly, if true, it would differ from Unixen. I

Re: [sqlite] WAL files and PERL question

whether that is so is a worthwhile experiment, and if it is so, will allow you to focus on your schema and query rather than details of SQLite implementation that should be opaque to you as a user. Best regards, -- Larry Brasfield ___ sqlite-users

Re: [sqlite] SQLite, .Net and Datareader: Close method is too slow.

. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3DbMallocRaw is crashing

cure your bug is unrealistic. You have some work to do, and use of valgrind or a similar tool is the best advice you are likely to get that will help you do that work. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users

Re: [sqlite] how to use sqlite in excel vba?

with more modern tools than VisualC++ 6.0. That would not be an issue for the OP. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to use sqlite in excel vba?

of its documentation, 'litex.pdf', is at https://www.assembla.com/spaces/litex/documents/c-5hiSb6ar3y3sab7jnrAJ/download/c-5hiSb6ar3y3sab7jnrAJ . -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] how to use sqlite in excel vba?

such issues.) Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to interrupt a long running update without roll back?

might want to write a query for that view which selects the rows in the first table which require no updating and unions that with another select which gets the ones in need of updating and also substitutes the computed values which would be made durable by the update. Cheers, -- Larry Brasfield

Re: [sqlite] numeric string quotation

literal in your insert statement. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Import skip first line

thing, which I take to be interpreting them as column names. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Import skip first line

the current release (v3.7.17) changes. The file doall.btm is understood by JPSoft's TCC and the free light version, TCC/LE. The makefile may not be current. The modified shell is shell_3r7r17_mod.c . Best regards, -- Larry Brasfield ___ sqlite-users

Re: [sqlite] Order of columns in group by statement affects query performance

*Daniel Winter wrote:0* I discovered that the order of columns in a group by affects the performance of a query. Is this expected? Yes. For example: Table: Column A int, Column B int, Column C int One Index: A,B (combined) Query 1: SELECT A,B,count(*) from tableTest group by A,B

Re: [sqlite] Timeline for full ALTER TABLE support?

was intended or that the statement was known to be false when made is unsupported by the evidence and indicates either ignorance of what the word lie means or bad faith. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Newbie unable to get started with sqlite on Visual Studio 2012

documented, allowing me to take code which works with the SQL Server Compact Edition and use it nearly unchanged with SQLite. The developers anticipate and well support such scenarios. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users

Re: [sqlite] How do I write a query

' entries other than the primary key. I see no is_a versus has_a confusion here. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite .NET 4.0 provider available?

because you post redundantly. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3 Bug Report: The shell accepts some dot commands ending in semicolons while rejecting others.

, if modified to meet your expectations, would be less suited to its purpose, harder to maintain and understand, and would divert effort from SQLite itself. I say this as one who has found reason to modify that code and who is glad that part of the task consumed little time. -- Larry Brasfield

Re: [sqlite] SQLite3 Bug Report: The shell accepts some dot commands ending in semicolons while rejecting others.

a diagnostic instead of simply following the above logic, I would say that adherence to the GIGO principle is perfectly adequate. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

. Could you please try the latest trunk code and let us know if that clears the issue you are seeing? I do not see such a change anywhere in recent check-ins listed at http://www.sqlite.org/src/timeline?r=trunk . Is there a build somewhere? I would be happy to try it. Cheers, -- Larry

Re: [sqlite] useful Perl modules for working with SQLite databases?

. That said, and without pretending it answers the question, I can say that I have found these modules handy for DB work in Perl, much of it using SQLite: use DateTime; use DBI; use DateTime::Format::DBI; use DateTime::Format::ISO8601; Cheers, -- Larry Brasfield

Re: [sqlite] Multiple network connections

to avoid deploying such a solution. You might be interested in this Code Project article, and perhaps its code: http://www.codeproject.com/Articles/22416/A-SQLite-Server-Client-Implementation Thank you, You're welcome, -- Larry Brasfield ___ sqlite

[sqlite] System.Data.SQLite .CHM [was: PRAGMA foreign_keys ...]

a link, labelled Documentation, leading to a page that says something like: Online help is a work-in-progress, but the distribution has a comprehensive Windows help file that is placed in the installation directory. -- Larry Brasfield ___ sqlite-users

Re: [sqlite] insert return -1

, you will need to show more. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multiple network connections

and others warn about is that SQLite is not designed for concurrent DB operations. Also, have its file store be accessed over a network from SQLite code running remotely is a formula for database corruption. But it looks like you are not doing that. Thank you You're welcome. -- Larry

Re: [sqlite] sqlite3.c:134542: warning: assignment from incompatible pointer type

, apparently.) 2. What patch? (Attachments are lost when posting here.) 3. What has this got to do with the referenced post Sqllite3 dll crash on ...? -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] parameters in a view, disallowed? (docs issue)

expressions, they may appear in a create view xxx as select ..., and there is no *documentation* to the contrary. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] strange behavior with integer with where clause

|repeat|integer|1|1|0 6|valid|integer|1|0|0 7|sound|integer|1|0|0 What do you get with query select * from repetition where cast(interval as integer)==0 and interval0 ? -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] strange behavior with integer with where clause

money is on #1. You might to a table dump using the SQLite shell to see which case it is. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] strange behavior with integer with where clause

are being inserted, and get the inserted types to be closer to what is supposed to be represented. (number, string, etc.) The BLOB is really for raw data that is not to be further interpreted as anything else. Cheers, -- Larry Brasfield ___ sqlite

[sqlite] PRAGMA foreign_keys = ?, feature request

this more easily than suggested above, I would appreciate your input. Thanks, -- Larry Brasfield * * ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA foreign_keys = ?, feature request

Larry Brasfield wrote: ... The framework opens and closes the database, presumably like it treats other DB connections. The schema that it sets up for objects related to each other relies on foreign keys. Unfortunately, foreign key enforcement in SQLite, as now specified and implemented, only

Re: [sqlite] PRAGMA foreign_keys = ?, feature request

there was such an option. That event is a nice feature, and I look forward to seeing 1.0.83.0 . I really appreciate the fine work that has been done on System.Data.SQLite. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] parameters in a view, disallowed?

With recent versions of SQLite, a prepare call fails when there are parameters in the SQL for a 'create view' statement. I stumbled into this for two reasons: The documentation for parameters and ..._prepare does not contra-indicate such usage; it seemed perfectly sensible; and it was useful

Re: [sqlite] parameters in a view, disallowed?

Igor Tandetnik wrote: On 12/20/2012 1:27 PM, Larry Brasfield wrote: With recent versions of SQLite, a prepare call fails when there are parameters in the SQL for a 'create view' statement. Did it ever work with any version of SQLite? Parameters in DDL statements don't make sense. Agreed

Re: [sqlite] parameters in a view, disallowed? (docs issue)

(as a semantic exception to the syntax), I went ahead and tried to use them in a view. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] parameters in a view, disallowed? (docs issue)

On 12/20/2012 4:10 PM, Larry Brasfield wrote: Igor Tandetnik wrote: [regarding where parameters allowed, where literals are] How did you discern this? I know from experience where parameters work (SELECT, INSERT and similar; also ATTACH as one of my projects happens to use it this way

Re: [sqlite] how to move around records in sqlite as the way as in CDaoRecordset of MFC??

-topic), but I doubt any sane developer could regret making that transition. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Suggested Improvement of Date Time Function

) have apparently already created this much more accurate set of conversions, perhaps you could offer them as a plug-in replacement for the readily omitted functions. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] multiple outstanding sqlite3_stmt objects

sqlite3_stmt #1 Is there any reason not to do this? (I would not be asking if I could see any hint in the API docs that sqlite3_stmt objects can be used independently, in arbitrary order, during their lifetimes.) Thanks, -- Larry Brasfield ___ sqlite

Re: [sqlite] How to manage Table inside Table scenarios

to defining sets. If you wish to retain the order of the Notice object in the database, there will need to be a column in the Notices table giving its sequence number within the set which can be used to recreate the ordering in a query. Regards, -- Larry Brasfield

[sqlite] Denormalized view, clumping into length-limited groups

have found it to be. Thanks for any tips, (even Give up.) -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Denormalized view, clumping into length-limited groups

is their numerical part so predictable, but those issues can be met in the source table design.) Thanks, too, for helping me see that I should look at 'group by' clauses more fundamentally. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite

Re: [sqlite] .dump ... [was: Please test the latest SQLite snapshot]

table dumping suspected to not work for some reason? If so, the .help output should lose the '...'. If not, perhaps the shell.c source should lose that nArg3 clause. Thanks, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Bug: Segmentation fault in libsqlite3.so.0.8.6[b69a4000+ac000]

you to start using a debug heap or sophisticated tools such as Purify to discover where your code has a stray memory write occurring. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] light weight write barriers

evidence ;-) Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How do you load a .csv and skip the first line?

executable, or both. It has a few other changes that do not interfere with conventional use of the shell which show up in the .help response. Cheers, -- Larry Brasfield (Examples of problem cut.) This does not work? -- .separator , .import test.csv

Re: [sqlite] How to use SQLite on VxWorks5.5

is likely to have done most of the work already. (Berkeley DB is layered over SQLite.) Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EXT :Re: Multi-Thread Reads to SQLite Database

. The database could be read-only (such as when no writers are busy), but the cache certainly will be in flux when readers alone are busy. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] C++ programming - sqlite3_column() question (doc flaw?)

for the sqlite3_column_count function says This routine returns 0 if pStmt is an SQL statement that does not return data. If this includes a pStmt for which data will no longer be returned, (as appears to be the case from the OP's report), this more stringent requirement should be mentioned. -- Larry Brasfield

Re: [sqlite] Quoting id versus 'id' in query

, and hence is not generally regarded as a nasty feature. Good luck. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Quoting id versus 'id' in query

set specification or by the character set specification. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Use with asp.net

exposed by System.Data.SQLite, you will not have many SQLite-specific issues. For those that do arise, you are likely to find willing help here. Regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] What does The use of the amalgamation is recommended for all applications. mean, precisely?

that it addresses only how SQLite source is presented to the compiler. Whether the compiler's output is embedded in its own object file, a DLL, or directly into a calling program is not addressed. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users

Re: [sqlite] What does The use of the amalgamation is recommended for all applications. mean, precisely?

On May 24, Dan Kennedy wrote: On 05/24/2012 10:53 PM, Larry Brasfield wrote: On the support page http://www.sqlite.org/howtocompile.html, it says: The use of the amalgamation is recommended for all applications. Is this a general recommendation, to use the amalgamated source file

Re: [sqlite] store db from sqlite to online mysql or online sqlite

.dump | sqlite3 mydb.sldb mkdb.sql sqlite3 dupe.sldb mkdb.sql With suitable DDL or a simple transformation of the DDL generated by .dump, that SQL can be used to export it into online mysql or some such. Cheers, -- Larry Brasfield ___ sqlite-users

Re: [sqlite] System.Data.SQLite and pooling problem

On 27 April, Greg Carter wrote: On 27 April 2012 11:39, Larry Brasfield larry_brasfield at iinet.com wrote: [snip] You works as it should is only assured (inasmuch as any software can) when you use the .Net framework's assured disposition mechanism (using ... and properly implemented

Re: [sqlite] System.Data.SQLite and pooling problem

up with a test case that reproduces this if needed. It's not really intended behavior but intent cannot cure this problem unless SQLite's finalizing API is used. Thanks Greg. ... Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite

[sqlite] Replying to posts here, threaded [was: SQLITE3 64-bit version]

in. The latter is what allows the replies to be usefully arranged in the threaded view. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Update problem with Sqlite (one PC one single operation) Vb.net

? Too little information to guess. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] In-memory and temporary database

in a table very quickly. might mean only I need the thread which accepts the data for storage to be quickly available for other work.) Regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Using SQL or C for data analysis?

. The aggregate functions might produce some output other than what is returned to SQLite. What I think will be unreasonable or unduly limiting is making it happen in bare SQLite. You will need more. Thanks, Simon Have fun! -- Larry Brasfield

Re: [sqlite] how to export to html file with table

study of HTML instances that have tables in them, and figure out how to put a sqlite shell generated table into one which otherwise says what you want. (For example, tables usually have a title, or something explaining what they are.) -- Larry Brasfield

Re: [sqlite] Could/should Windows build of SQLite use #define

On March 24, Roger Binns wrote: [I am the author of APSW] Thanks for that, BTW. On 24/03/12 14:22, Larry Brasfield wrote: Except for its clever hiding of SQLite's C API names (via #define SQLITE_API static), There is nothing clever about it - SQLite exposes various things like that so

Re: [sqlite] question about zipvfs performance

Good luck. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handle multiple results using sqlite3_step

? At this point, I doubt anybody can help without better information as to what the objective is. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Could/should Windows build of SQLite use #define

help head off such issues to #include no more than is necessary, and a #define WINDOWS_LEAN_AND_MEAN would get partway there. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Could/should Windows build of SQLite use #define WIN32_LEAN_AND_MEAN?

was more cantankerous, I would be tempted to say there is no real reason to complicate a build script for this 110mS time saving. Of course, if you are building on some ancient machine, you might save more time. Cheers, -- Larry Brasfield ___ sqlite

Re: [sqlite] select null values in python

was just having some gentle fun.) I just wanted to chime in with appreciation for Igor's contributions, especially that he often *does* answer the question not asked when that is more germane than simply answering the OP's question. I often find his replies instructive. -- Larry Brasfield

Re: [sqlite] VIsual Studio 2005. slow and high CPU in debug

will be slower, and assertions are in much of its code. Thank you very much in advance. You're welcome -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] import a text to sqlite

, unlike cmd.exe which is one of the sorriest excuses for a shell ever allowed to live so long. Good luck, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] import a txt into sqlite

;55;55;111;55;55;514 when I import the txt to my sqlite table, could I import the the first row contains columnnames, not data. like odbc HDR=Yes You posted this 8 days ago, and got a useful reply then. Do you expect more? -- Larry Brasfield ___ sqlite-users

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

that arises from pointer aliasing might be counted as a compiler bug, it is generally better for code to not create the opportunity. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] SELECT COUNT (DISTINCT column_name FROM table)

On March 5, Richard Hipp wrote: On Mon, Mar 5, 2012 at 1:39 PM, Larry Brasfield larry_brasfield at iinet.comwrote: On March 5, Richard Hipp wrote: On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP sreekumar.tp at gmail.com wrote: The crash is a result of -O3 flag used during compiling

Re: [sqlite] Elegant printout of table (with header) via TCL (solved)

(that would have sufficed to trigger header emission with the original code). Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DISTINCT bug with 3.7.10

want to review docs for the preprocessor settings if this was my problem. Good luck, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DISTINCT bug with 3.7.10

On 3 Mar 2012, at 12:29am, Larry Brasfield larry_brasfield at iinet.com wrote: That's approaching a pretty good bug report. However, I would suggest a little more to promote a resolution of this problem. You do not state the compilation options. Optimization settings and preprocessor

Re: [sqlite] DISTINCT bug with 3.7.10

them up front will help resolve this if that is the case. To Simon: I do not claim here that these settings *are* the problem, just that if they are, they will need to be made evident to enable progress to be made toward a solution. -- Larry Brasfield

Re: [sqlite] import a txt into sqlite

at: https://docs.google.com/viewer?a=vpid=explorerchrome=truesrcid=0BzRwojdN0G2UMWY2MTg2NzgtNDU3YS00Y2RiLWI5MTktMDZiMDYxZGU5MGExhl=en_USpli=1 (Watch line wrap -- that's a one line URL.) Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite

Re: [sqlite] Reference error

. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there way to modify table structure after initial definition ?

. Is there any instrument to meet my need directly. Best Regards -- tom You need to study the ALTER TABLE statement and its limitations. See http://www.sqlite.org/lang_altertable.html . Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Lifetime of an sqlite_value object

until a type conversion occurs as described above, or until sqlite3_step() or sqlite3_reset() or sqlite3_finalize() is called. Your assumption is therefor not safe. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] undefined reference to `sqlite3_db_release_memory'

is making the unsatisfied reference and to see where it might be satisfied. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3 windows command line: writing the sql errors to a file (and not to the screen)

Gert, Why do you post the exact same question on Feb 14 and Feb 16, 46 hours apart? You got several worthy answers before. Were they somehow inadequate? -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] Error 21 on Open (C#)

you need to reduce your program to something more than you've shown, that gets the DB file to some state that is different the 2nd time through. I see nothing wrong with the code you did show. (Well, swallowing exceptions so mutely is a bit lame!) -- Larry Brasfield

Re: [sqlite] Segmentation fault on sqlite3_create_module

its declarations, guarded by #ifdef __cplusplus, so this is not an issue. It is perfectly reasonable to call into the SQLite code from C++. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Segmentation fault on sqlite3_create_module

, that's a good point. (To the O.P.:) It would be a good idea to wrap the same 'extern C { }' around forward declarations for your functions that are going into that v-table (as pointers), and be sure that they are seen during compilation of those functions. -- Larry Brasfield

Re: [sqlite] Segmentation fault on sqlite3_create_module

become a reinterpret_cast when that is going to produce problems. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA journal_mode=WAL;

opportunity, but I think I speak for more than just myself by revealing that I have other work, and a life, and consider time a scarce resource. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] PRAGMA journal_mode=WAL;

as if it was SQL. It is not C. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA journal_mode=WAL;

revert. Since the database is a file, you can keep a copy of it, as another file. Or you could put your update in a transaction. However, for a single-record update, there is no point. SQLite is pretty robust once you've set journal_mode=WAL. Best regards, -- Larry Brasfield

Re: [sqlite] sqlite3 question

programs are silly enough to insist on seeing '\' rather than the '/' the rest of the world has settled upon. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I'm sure I'm missing something.

done. Good luck. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite DBaaS

naivety. Regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   >