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]
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:
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
>
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-
>
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
: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
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
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
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
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
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
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:
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
/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
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
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
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
>
>
>
>
&
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
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.
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
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
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
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
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
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
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
> > > #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
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
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
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
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
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
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
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
]
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
: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
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
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:
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
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
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
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
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",
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
-
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
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
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
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
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
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
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,
>>
>&
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
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]
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
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
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]
, 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:
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]
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
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
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.
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 =
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
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
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
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
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
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:
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
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:
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
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
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
[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
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
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
-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
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
>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
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
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:
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
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
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:
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.
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
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
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
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.
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:
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
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
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.
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
94 matches
Mail list logo