Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

Use the one included in this archive: http://www.sqlite.org/sqlitedll-3_6_6_2.zip Mike > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Ti Ny > Gesendet: Freitag, 28. November 2008 11:26 > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite]

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

If you haven't specified the DEF file during linking, no symbol is exported. There's no way for the .NET runtime to find the entry point without an export table. Mike > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Ti Ny > Gesendet:

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

Have you given the DEF file to the linker? Are the exports visible in dependency walker? Is your DLL and the executable process type compatible (e.g. both 32 or 64-bits?) Mike > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Ti Ny >

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

Have you set ExactSpelling? EntryPointNotFound doesn't have to do with CallingConvention. Are you sure that your sqlite.dll exports its API? Like I said in my previous mail, I'd suggest using one of the already available and well-tested .NET wrappers. Mike > -Ursprüngliche Nachricht- >

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

The given code is correct. The lower-case string is a C# alias for the System.String class. System.Int64 is an opaque 64-bit pointer value. The code so far is correct. What is missing though is the calling convention, which by default is cdecl, but .NET doesn't use that one by default for

Re: [sqlite] rtree cast warnings on 64bit OS - strange parameter use

:28 PM, Michael Ruck wrote: > >> The problem with these types of C tricks is that they only work >> right if the >> platform they're used on has the property of sizeof(void*) == >> sizeof(int). >> Unfortunately this is not always the case and not mandated

Re: [sqlite] rtree cast warnings on 64bit OS - strange parameter use

The problem with these types of C tricks is that they only work right if the platform they're used on has the property of sizeof(void*) == sizeof(int). Unfortunately this is not always the case and not mandated by the C standard. That's the reason for these warnings. Its also a reason not to turn

Re: [sqlite] SQLite vs. quad-cores

I would suggest you force your software to use only one processor on both dual- and quad-core machines and check the timings again. If the timings are in the range of expectancy (due to hardware speed/processor frequency) then your software has a bug related to NUMA. The non-uniform memory

Re: [sqlite] GCC -ffast-math safe version of sqlite3IsNaN

Have you tried to compile the util.c/amalgamation file without -ffast-math and use it with your other sources (compiled with -ffast-math)? Mike > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Brown, Daniel > Gesendet: Mittwoch, 27. August

Re: [sqlite] Proposed removal of (mis-)feature

Remove it. Better now than never. Mike > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von D. > Richard Hipp > Gesendet: Donnerstag, 7. August 2008 19:26 > An: General Discussion of SQLite Database > Betreff: [sqlite] Proposed removal of

Re: [sqlite] SQLite in DotNet environment and virtual tables

Hi Sylko, sqlite3_load_extension is unfortunately not directly usable from .NET. No .NET language (except MC++) exposes the ability to export functions from a DLL. In order to use extensions you need to create at least a small helper DLL, which can then be used as an adapter or proxy to an

Re: [sqlite] SQLite>=3.5.6 does not open database file

Is there a previous version, which is able to open this database file? Which version of SQLite was the database file created with? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Steve Topov Gesendet: Montag, 14. April 2008 22:31 An:

Re: [sqlite] reading MS Access 97 files

Even though I haven't done anything with this stuff for almost 6 years, I haven't forgotten this stuff. But I intentionally left out a couple of short lived technologies... :( Mike -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Fred J. Stephens

Re: [sqlite] reading MS Access 97 files

/ms714562(VS.85).aspx Thanks, -John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Ruck Sent: Thursday, April 10, 2008 5:58 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] reading MS Access 97 files John, Access comes with an ODBC

Re: [sqlite] Inserting data containing apostrope

I don't know Liberty Basic, but the sqlite3 library allows you to prepare statements and bind variables to them before executing them. This will solve your problem. The APIs in question are sqlite3_prepare(_v2), sqlite3_bind_*, sqlite3_step, sqlite3_reset and sqlite3_finalize. Use these functions

Re: [sqlite] reading MS Access 97 files

John, Access comes with an ODBC driver itself. An alternative would be to access the MS-Jet-Engine directly. (Jet is the database engine used by Microsoft Access.) IMHO you have three/four data access APIs possibilities: - ODBC - Jet Engine - DAO - ADO (not ADO.NET) Choose one depending on

Re: [sqlite] WinCE Memory Problem

E, TAGTYPE, PRINTDATA ) > VALUES( %s, %d, ? );", chrBarCode, tagtype ); rc = sqlite3_prepare( > db, sqlcmd, -1, , 0 ); > > to update the contents of the each records inside the loop. Am I > right? > > Any suggestion? Thanks. > > WenYuan > > > > &

Re: [sqlite] WinCE Memory Problem

e the loop. Am I right? Any suggestion? Thanks. WenYuan --- Michael Ruck <[EMAIL PROTECTED]> wrote: > You should only prepare the statement once before the loop. The only > thing you should do in the loop itself is bind varying data and call > sqlite_step. > There's no

Re: [sqlite] WinCE Memory Problem

You should only prepare the statement once before the loop. The only thing you should do in the loop itself is bind varying data and call sqlite_step. There's no need to call prepare, reset, finalize inside the loop. If chrPrintData doesn't change you can also move bind_blob in front of the loop.

Re: [sqlite] Clear screen in command line interface

Imho the shell should rather implement the ! command to ask the bash (or other shell) to execute a command in its preferred format. This way any executable could be launched from sqlites command prompt. A clear screen would be available as !clear or !cls. Michael -Ursprüngliche

Re: [sqlite] insert on windows server 2003 very slow

Hi Angela, for every iteration of your while loop a new transaction is opened and commited. You need to wrap the loop in manual transactions using BEGIN and COMMIT statements. Creating transaction logs is an expensive operation, when compared to the insert itself. Regards, Michael

Re: [sqlite] Given sqlite3_enable_load_extension(), why omit loadable extensions?

Database Betreff: Re: [sqlite] Given sqlite3_enable_load_extension(),why omit loadable extensions? On Wed, Feb 20, 2008 at 12:09:16AM +0100, Michael Ruck wrote: > This is most likely done to reduce compiled code size. For a lot of > systems this code probably is wasted space, as the feature is no

Re: [sqlite] Given sqlite3_enable_load_extension(), why omit loadable extensions?

This is most likely done to reduce compiled code size. For a lot of systems this code probably is wasted space, as the feature is not used everywhere. For embedded systems the ability to simply cut features at compile time to reduce code size is very important. Mike -Ursprüngliche

AW: [sqlite] Does SQLite support modifying date through views?

It does not, but you can attach triggers to a view to achieve the same effect. > -Ursprüngliche Nachricht- > Von: Robert Smith [mailto:[EMAIL PROTECTED] > Gesendet: Sonntag, 9. Dezember 2007 08:31 > An: sqlite-users@sqlite.org > Betreff: [sqlite] Does SQLite support modifying date

AW: [sqlite] Transactional DDL

Are all CREATE ... statements transactional or is only CREATE TABLE transactional? Mike > -Ursprüngliche Nachricht- > Von: Dan [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 27. November 2007 15:59 > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] Transactional DDL > > > On Nov

AW: [sqlite] Re: Performance tuning, and other (silly?) SQLitequestions.

formance tuning, and other > (silly?) SQLitequestions. > > Michael Ruck wrote: > >> > >> Ah. I have been reading a PHP/MySQL book, that I thought > said a MySQL > >> server would see the common column names and automagically > join the 2. > >> Ei

Re: [sqlite] Re: Performance tuning, and other (silly?) SQLitequestions.

> > > #A more complicated query...runs quite slowly. How can > this be sped > > > up? > > > db eval {SELECT position.odo, data.x, data.y from > position, data WHERE > > > position.odo BETWEEN 1 AND 10020;} > > > > First, you want an index on position.odo. Second, you don't > specify any

RE: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

n the last successful insert rowid. Best regards Daniel Michael Ruck wrote: > I'm not blaming anyone. I just think it should be mentioned in the docs. > > Mike > > -Ursprüngliche Nachricht- > Von: John Stanton [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 29. Novembe

AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

OR IGNORE is not logical and to blame others for your oversight is not helpful. Michael Ruck wrote: > I don't get an error code. So how should I decide if I should call > sqlite3_last_insert_rowid() or not? :) That's the problem - I don't have any > indication if an insert > was actual

AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

This does look like a solution indeed. I'll try this one later. Thank you! Mike -Ursprüngliche Nachricht- Von: Simon Davies [mailto:[EMAIL PROTECTED] Gesendet: Montag, 29. Oktober 2007 16:40 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] INSERT OR IGNORE and

RE: [sqlite] Re: INSERT OR IGNORE and sqlite3_last_insert_rowid()

Ok, thanks I haven't seen this function. I'll try it. Mike -Ursprüngliche Nachricht- Von: Igor Tandetnik [mailto:[EMAIL PROTECTED] Gesendet: Montag, 29. Oktober 2007 17:01 An: SQLite Betreff: [sqlite] Re: INSERT OR IGNORE and sqlite3_last_insert_rowid() Michael Ruck wrote: > I do

Re: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

or documentation, and I completely disagree. Shawn -Original Message- From: Michael Ruck [mailto:[EMAIL PROTECTED] Sent: Sunday, October 28, 2007 12:55 PM To: sqlite-users@sqlite.org Subject: AW: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() I'd suggest putting

AW: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

Betreff: Re: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() On Oct 28, 2007, at 10:59 AM, Michael Ruck wrote: > Yes, I am well aware of this possibility as I've written in my > initial mail. > It just doesn't fit with the > description of sqlite3_last_insert_r

AW: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

Good point. Thanks. -Ursprüngliche Nachricht- Von: D. Richard Hipp [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 28. Oktober 2007 17:48 An: sqlite-users@sqlite.org Betreff: Re: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() On Oct 28, 2007, at 10:59 AM, Michael Ruck

AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

] Gesendet: Sonntag, 28. Oktober 2007 15:36 An: sqlite-users@sqlite.org Betreff: Re: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() [Default] On Sun, 28 Oct 2007 10:00:52 +0100, "Michael Ruck" <[EMAIL PROTECTED]> wrote: >Hi, > >I did specify UNIQUE for cate

AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

:45 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid() [Default] On Sat, 27 Oct 2007 16:26:36 +0200, "Michael Ruck" <[EMAIL PROTECTED]> wrote: >Hi, > >I have a table of unique values in the following format: > >CREA

[sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

Hi, I have a table of unique values in the following format: CREATE TABLE categories (id INTEGER PRIMARY KEY, category UNIQUE TEXT) I want inserts into this table to succeed, even though the corresponding entry already exists. So I use inserts in the following format: INSERT OR IGNORE INTO

AW: [sqlite] Index size in file

If you're running under constraints so low, you should take care choosing the right tools for the job. Apparently sqlite isn't the right tool for this job. Mike -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 5. Oktober 2007 00:19 An:

AW: [sqlite] Re: In Mem Query Performance

That's not what I meant. I meant the following: Take the key in the format 'kkk k490' and split it into two(66 characters each) /three (44 characters each) colums of equal

AW: [sqlite] Re: In Mem Query Performance

As has been suggested numerous times, you should split the key. The keys you've shown are very long and only differ in the last characters. You should try yourself to split the key (maybe in two or three columns) and order the key according to the change frequency. This way sqlite doesn't have to

AW: [sqlite] In Mem Query Performance

Don't use sqlite_get_table. Use sqlite3_prepare(_v2), sqlite3_step and sqlite3_finalize/sqlite3_reset. Mike -Ursprüngliche Nachricht- Von: RaghavendraK 70574 [mailto:[EMAIL PROTECTED] Gesendet: Montag, 25. Juni 2007 13:48 An: sqlite-users@sqlite.org Betreff: [sqlite] In Mem Query

[sqlite] SQLite used by Google Gears

This will cause SQLite to spread to even more desktops around the world: Google integrated SQLite into its new Google Gears tool, which allows web applications to work offline. It provides several services, one of which is a local client database. Read more: http://gears.google.com/ Mike

AW: [sqlite] ATTACH and sqlite3_open()

Just call sqlite3_exec with the proper ATTACH as you would on the command line. (Of course you could also do a prepare/step/finalize, but for ATTACH sqlite3_exec is enough.) Example: sqlite3 *db = NULL; /* ... */ sqlite3_exec(db, "ATTACH DATABASE 'filename' AS dbname",

AW: [sqlite] sqlite and borland c++ builder

If I understand him correctly, he's having issues including the original sqlite3.h in his own sources too... He tried to build sqlite again to solve that problem, but it remains there too. I would recommed patching up sqlite3.h to conform to BC++ requirements - changing those structs to something

Re: [sqlite] Recursive triggers

- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 26. April 2007 21:05 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Recursive triggers "Michael Ruck" <[EMAIL PROTECTED]> wrote: > Hello, > > I've been looking into the way triggers are implem

[sqlite] Recursive triggers

Hello, I've been looking into the way triggers are implemented and was thinking about adding support for recursive triggers, as they would simplify my current project dramatically. What was/is the reason to leave them out? My thoughts were adding recursive triggers by calling them like

AW: [sqlite] Re: DB design questions

2007 21:17 An: sqlite-users@sqlite.org Betreff: [sqlite] Re: DB design questions * Michael Ruck <[EMAIL PROTECTED]> [2007-04-20 16:15]: > Is there anyone who has experience with this kind of design, do you > have better ideas on modelling this kind of data? This is actually a

[sqlite] DB design questions

Hello, I'm currently modelling and designing a new database according the following specifications. The general idea is the ability to store arbitrary objects, which have attributes of various kinds. The attributes themselves may be multivalued. The objects being stored need to be versioned, so

AW: [sqlite] Still getting "Insertion failed because database is full." errors

device entirely, but again I expect the same results. > > > > I'm convinced now that the problem is with the application > > architecture, but I have no idea what to look at anymore. I've > > stared and fiddled with > this > > code so much that I'm ready to throw

AW: [sqlite] Still getting "Insertion failed because database is full." errors

Unless things have changed recently, the following should still be valid for Windows Mobile/Windows CE devices: Usually these devices do not power off, but stay in a standby state where the memory is always powered. Check if that's the case with your system and move as much as possible into RAM

Re: [sqlite] Still getting "Insertion failed because database is full." errors

Transactions. I will gladly go and put all the updates into > transactions, but would I do the same for Select statements? > > Thanks for the responses, > > Joel > > On 4/13/07, Michael Ruck <[EMAIL PROTECTED]> wrote: > >> >> Hi, >> >&

AW: [sqlite] Still getting "Insertion failed because database is full." errors

Hi, Is this the only device seeing this error or are *all* devices seeing this error? Have you checked the CF card? May be its just the card, which is corrupt and you're hitting these bugs at points, where the file system is hitting a bad sector. Is this running in a transaction? Mike

AW: [sqlite] Still getting "Insertion failed because database is full." errors

Guessing from his call stack he's doing a select. ExecuteReader executes a statement, which must return a resultset (aka select.) -Ursprüngliche Nachricht- Von: John Stanton [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 13. April 2007 17:57 An: [EMAIL PROTECTED] Betreff: Re: [sqlite]

AW: [sqlite] Exclusive Access

You can only open one connection in exclusive mode - even in one process. -Ursprüngliche Nachricht- Von: John Stanton [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 10. April 2007 20:14 An: sqlite-users@sqlite.org Betreff: [sqlite] Exclusive Access A quick question in case someone has

AW: [sqlite] SQLite and nested transactions

That Sybase and MS SQL match on their behavior is no surprise considering their common heritage ;) I suppose MS (and sybase for that matter) hasn't done anything on the transaction support since they've split their code bases. -Ursprüngliche Nachricht- Von: Griggs, Donald [mailto:[EMAIL

AW: [sqlite] SQLite and nested transactions

Yes, but this violates ACID principles. As Igor pointed out this does not resemble a full implementation of transactions, as nested transactions can be commited and rolled back independently of the outer parent transaction. Mike -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED]

Re: [sqlite] Master table with child FTS table

, but how do you create a trigger when the data to be inserted on the trigger is not part of the 'NEW' reference? -PQ - Original Message - From: "Michael Ruck" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, April 07, 2007 8:35 AM Subject: AW:

AW: [sqlite] Master table with child FTS table

How about managing fts_table using triggers attached to the master table? That should take care of synchronization issues IMHO. Mike -Ursprüngliche Nachricht- Von: Paul Quinn [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 7. April 2007 09:08 An: sqlite-users@sqlite.org Betreff: [sqlite]

AW: AW: AW: [sqlite] Function Language

would not be a good way to implement simple functions in Sqlite, the current custome function interface to native code is far prefereable for that but it is appropriate for implementing larger functions and one which require frequent user alterations. Michael Ruck wrote: > How do you treat obje

AW: [sqlite] Function Language

I am all for it and am very interested in your project as I'm working on something similar. I've been using JS to create dynamic HTML pages in combination with SQLite using a JSON wrapper from this list. The only issue I see here is the treatment of JS objects - there's again the OO and relation

AW: [sqlite] storing funky text in TEXT field

Actually UTF-8 is the better choice compared to UTF-16. I would start turning on UTF-8 as the character set on your web server and ensure that it is also specified as the document character set in all generated HTML pages. This gives browsers a hint about the text encoding to use to render pages.

RE: [sqlite] How To Use ATTACH?

I don't know your Wrapper, but try this: CppSQLite3DB db; db.open("Stocks.db"); db.execDML("ATTACH 'Options.db' AS OPT;"); sSQL = "UPDATE Stocks SET bOption=1 WHERE rowid IN "; sSQL += "(SELECT Stocks.rowid FROM Stocks, OPT.Options "; sSQL += "WHERE Stocks.sStockSymbol =

AW: [sqlite] Obtaining randomness on win32

I'm not sure if this helps, but QueryPerformanceCounter could be a source of semirandom 64-bit integers. It returns the processors running time in nanoseconds. I'm not aware of anything, which returns really random values. On Windows itself you could use the CryptAcquireContext, CryptGenRandom

[sqlite] SQLite JSON interface?

Hi, Is there a JSON interface for SQLite (in C/C++)? Any GPL/LGPL compatible license or public domain would do. Someone must have written something like it. I need to export a set of tables to JSON .js files to serve on a webserver, the files are generated off-line, not on demand. Michael

AW: [sqlite] Of shared cache, table locks and transactions

Yes, I second this opinion. However I believe sqlite is ACID, just not when shared cache mode is enabled... Mike -Ursprüngliche Nachricht- Von: Ken [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 14. Januar 2007 17:00 An: sqlite-users@sqlite.org; [EMAIL PROTECTED] Betreff: Re: [sqlite] Of

AW: [sqlite] Equivalent of OLE object da

An OLE object is persisted into a stream of bytes. You can store OLE objects into SQLite as a BLOB, but you need to make your own (specialized) implementation of one of the IPersistXXX interfaces (most likely IPersistStream), which stores the object into an SQLite column/reads a serialized object

AW: [sqlite] sqlite performance, locking & threading

away with the need for a client/server design. Emerson On 1/3/07, Michael Ruck <[EMAIL PROTECTED]> wrote: > Emerson, > > Now I understand your current implementation. You seemingly only > partially split up the work in your code. I'd schedule the database > operation an

AW: [sqlite] sqlite performance, locking & threading

e which controls the server thread, you have a problem. It can be overcome using the initialise on first use idiom, as long as your careful to protect the initalisation with atomic operations, but its still a bit complicated. Emerson On 1/3/07, Michael Ruck <[EMAIL PROTECTED]> wrote:

AW: [sqlite] sqlite performance, locking & threading

Hi Emerson, Another remark: On Windows using Events synchronization objects involves additional kernel context switches and thus slows you down more than necessary. I'd suggest using a queue, which makes use of the InterlockedXXX operations (I've implemented a number of those, including priority

AW: [sqlite] sqlite performance, locking & threading

Richard, I believe his problem is this: "Each query is allowed to complete before the other one starts, but each thread may have multiple statements or result sets open." The open resultsets/multiple started statements are causing him headaches. Mike -Ursprüngliche Nachricht- Von:

AW: [sqlite] sqlite performance, locking & threading

I want to contribute my 0.02€ to this discussion. Basically I believe your (Emerson) design is flawed. I've been working for years with multithreaded and even multi-core systems. From my experience a design using threads for specific tasks is *always* performing better, than having multiple

AW: [sqlite] SQLite and McAfee Anti-Virus

I would actually remove the default or use the process name instead. Just my $0.02. Mike -Ursprüngliche Nachricht- Von: John Stanton [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. November 2006 01:28 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] SQLite and McAfee Anti-Virus Why

AW: [sqlite] auxiliary threads in sqlite3

I can't answer the question regarding SQLite for you, but Windows does start auxiliary threads in some APIs. -Ursprüngliche Nachricht- Von: Dixon [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 27. September 2006 16:36 An: sqlite-users@sqlite.org Betreff: [sqlite] auxiliary threads in

AW: AW: [sqlite] Re: Queries fail - I can't figure out why

[mailto:[EMAIL PROTECTED] >Gesendet: Sonntag, 24. September 2006 22:45 >An: SQLite >Betreff: [sqlite] Re: Queries fail - I can't figure out why > >Michael Ruck >wrote: >> I have the tables of the following style: >> >> CREATE TABLE Objects (ObjectID TEXT PRIMARY

AW: RE: RE: [sqlite] How long can I keep a prepared statement around?

That's basically the way I do it. I have a factory method for all prepared statements, where I wrap the (optional) recompilation in and aquire a named mutex for every method invocation in the class. I think this should be a safe approach to prevent SQLITE_SCHEMA errors if the only schema

AW: RE: [sqlite] How long can I keep a prepared statement around?

Looking at the implementation of sqlite3_expired, its just a comparison of the expired flag in the statement or if the passed statement is NULL. The cost is an additional if statement before execution, however this does not save you from SQLITE_SCHEMA errors. In theory someone could modify the

AW: [sqlite] Re: Queries fail - I can't figure out why

-Ursprüngliche Nachricht- Von: Igor Tandetnik [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 24. September 2006 22:45 An: SQLite Betreff: [sqlite] Re: Queries fail - I can't figure out why Michael Ruck wrote: > I have the tables of the following style: > > CREATE TABLE Objects (ObjectID TEXT PR

[sqlite] Queries fail - I can't figure out why

Hi, I have the tables of the following style: CREATE TABLE Objects (ObjectID TEXT PRIMARY KEY, Class TEXT) And I'm executing the following statement in the sqlite3 shell: SELECT * FROM Objects WHERE ObjectID = '{08021C17-46DD-4d83-A6FE-DDF0F7EC0AAE}' In the shell this query succeeds. However

AW: [sqlite] what tier architecture?

>From your description I would consider this a one-tier architecture. Ussually the tiers are defined as follows: - Presentation GUI, all user interaction. - Business Logic Logic, which can not be expressed by constraints in the database. Interaction with other (software) systems and some more

AW: [sqlite] Major projects using SQLite

You can add Orb (www.orb.com) to the list. Mike -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 14. Juli 2006 17:04 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Major projects using SQLite

AW: [sqlite] How do you find out the names of the fields within a table?

If you're using VB.NET 2002, then look at the following classes: System.Collections.ArrayList System.Collections.SortedList System.Collections.Hashtable These are all dynamic container classes. Mike -Ursprüngliche Nachricht- Von: John Newby [mailto:[EMAIL PROTECTED] Gesendet:

AW: [sqlite] How do you find out the names of the fields within a table?

If you're using VB6 your choices are VBs native Collection or the Scripting.Dictionary class mentioned by Craig. Look them up in VBs online help, there are examples on using them. I'd suggest get more familiar with VB and its Container classes... Mike -Ursprüngliche Nachricht- Von: John

AW: [sqlite] How do you find out the names of the fields within a table?

VB always had dynamic containers. Starting with Arrays things such as ReDim helped. Later Collection(s) (actually a Dictionary/Hashtable) were introduced. In VB.NET you of course have all containers, which the .NET framework supplies. In fact there are classes for Lists (ArrayList, LinkedList and

AW: [sqlite] Problems with Multi-Threaded Application.

Use a queue for the database operations in this case. You won't suffer from lock or busy errors, if all access is serialized. Queues can scale very well if done right. Mike -Ursprüngliche Nachricht- Von: Gussimulator [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. Juli 2006 20:55 An:

AW: [sqlite] Problems with Multi-Threaded Application.

I would suggest using a queue approach. Its not as bad as it sounds. Have that queue processed by a single thread, which controls the database writes. That way you can save the time for other operations, such as database open/close etc. You can't avoid the "can't read while writing" though.

AW: Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

I second this. I don't mind having to post or refresh my subscription every once in a while. It would however be important for me to receive a notification to refresh my subscription instead of just silently removing my subscription. HTH, Mike >Hi, > >I think many of the 1217 active

AW: Re: [sqlite] Direct use of SQLite btree functions / performance

Maybe I'm missing something here, but there should be an interface to page a blob into memory. Especially for large blobs, this would make sense to me to not load them into memory at once. If sqlite doesn't provide this already, it would probably make a lot of sense to include this

AW: [sqlite] VB6 question

Hi, unfortunately this has to do with the C calling convention used by sqlite3.dll. By default DLLs compiled with C have the cdecl calling convention, but VB only supports the stdcall calling convention. You must recompile sqlite using MS Visual C++ or other compiler and switch the default

[sqlite] Storing XML

Has anyone used SQLite to store XML fragments or documents? Which approach have you taken or what approach would you take? I am currently evaluating the possibilities of storing arbitrary XML fragments using SQLite. The fragments may or may not have schema information.

AW: [sqlite] Plans for SQLite version 3.2

How about adding support to obtain the column type information, when querying views? (I'm refering to the question I posted a couple of days ago.) -Ursprüngliche Nachricht- Von: D. Richard Hipp [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 18. Februar 2005 16:54 An:

[sqlite] Questions regarding sqlite3_column_decltype

Hi, Maybe someone can answer me a couple of questions regarding above function: I've seen that it doesn't return the declaration type for views in 3.0.8. Is this by design? Are there any plans to change this so that queries against views return the column types of the tables? I've looked at

AW: [sqlite] How to unite query results from two databases

worked with multiple databases before, but I would think you could just union two queries together if nothing else. Eg: select ... union select ... order by col Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.279.3780 -Original Message- From: Michael

[sqlite] How to unite query results from two databases

I need to perform a select, which queries two databases (same tables and columns in both databases; both open at the same time in the same SQLite session via ATTACH DATABASE.) I need the query result to appear as a single result with sorting etc. performed on the entire result from both databases.

AW: [sqlite] Version 3.1.0

You could replace the const void* with wchar_t on conforming compilers (such as MCVC 6+) to simplify unicode development: #if defined(wchar_t) typedef const wchar_t* strw; #else // #if defined(wchar_t) typedef const void* strw; #endif // #if defined(wchar_t) I think this would allow easier usage