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 = OPT.Options.sStock
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 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 mi
/Javascript will also generate
PostScript to deliver PDF and no doubt other formats which may show up in
the future.
Michael Ruck wrote:
> 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
>
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
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] Ma
ers for INSERTs, 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:
Sent: Saturday, April 07, 2007 8:35 AM
Subject: AW: [sqlite
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] [mailto:[EM
IMHO it depends on your needs. Usually the 4th will try some sort of error
recovery and if that fails, rollback itself. This bubbles up until it
reaches the top.
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 9. April 2007 19:50
An: sqlite-us
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 PR
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 exp
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] Stil
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
-Urs
dmit I am not very knowledgeable
> about 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:
&
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
nd the tester
> out
> > with another 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 wi
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 th
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'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 subroutine
Nachricht-
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 trig
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
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", NUL
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
--
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 Perfor
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 r
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 le
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: sqlite-
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 cate
07 23: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:
>
>
lto:[EMAIL PROTECTED]
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 spe
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
e.org
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 sqlite
a
problem with the function 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()
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:
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 sqlite3_last_insert_rowid
RT 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 inser
en do not trust the
sqlite3_last_insert_rowid since (I guess) it will return 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-
> Vo
> > > #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
>
nce 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
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 2
Don't use sqlite3_get_table. Use sqlite3_prepare_v2, sqlite3_step,
sqlite3_finalize and related APIs instead.
Mike
> -Ursprüngliche Nachricht-
> Von: Jonathan Hendler [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 2. Dezember 2007 14:10
> An: sqlite-users@sqlite.org
> Betreff: [sqlite] H
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 throug
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 Nachricht--
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
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
-Ursprüngl
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 Nachricht
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.
records inside 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.
Regards,
WenYuan
--- Michael Ruck <[EMAIL PROTECTED]> wrote:
> No, you only need to create the statement once. And bind all variables
> inside the loop. This at least saves computation time. Additionally
> you should use sqlite3_mprintf instead of sprintf to protect against
> sql inj
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 your
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 (
crosoft.com/en-us/library/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 file
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
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: sqlite-users@
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 extensi
My experience differs on this one. When processing large amounts of data
with a processing function, which takes longer than the I/O using a mapped
file is faster than sequential I/O, as the Windows memory manager and
caching system will pull in the I/O pages asynchronously. At least on
Windows I'd
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 functionalit
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 subscribers
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. You'll
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: s
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 t
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
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: Donnerst
class
as suggested earlier in the thread, but I could not understand it. I would
think a count of the rows would be needed in order to know how many times
the while loop would need to be executed to add the name of each field.
On 13/07/06, Michael Ruck <[EMAIL PROTECTED]> wrote:
>
> If
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
=?iso-8859-1?Q?Jon_Garc=EDa_de_Salazar_Bilbao?=
>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 l
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 i
Use the function sqlite3_expired to determine, when you need to
recompile a prepared statement. That's the approach I use.
Mike
Am 24.09.2006 um 20:48 schrieb Kervin L. Pierre:
Hello,
I have a few queries that are executed very
often. I would like to keep them around as
much as possible.
to find this
bug.
Mike
-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 T
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 s
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 changes
t-
>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 TA
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 sqli
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 n
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 thre
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: [EMA
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 b
ised before
the static instance 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 &l
le faster and i could do 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 t
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 f
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
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
-
Thanks, looks good!
Michael
>Michael Ruck wrote:
>>
>> 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
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
an
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 (mis
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 2
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 architec
Dan,
While I do understand the position chosen by SQLite, these warnings do try
to prevent human error. In case of Visual C++, Microsoft has added lots of
tests in order to make porting code from 32-bits to 64-bits easier. And
those
problems Mark wrote about were certainly reported as warnings si
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 o
at 1: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 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 P/Inv
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-
>
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
> Gesendet
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: Freita
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 cal
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
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.
avent 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: Mi
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 th
1 - 100 of 102 matches
Mail list logo