On Wed, 6 Sep 2006 18:05:36 +0100, you wrote:
Hello Mark
I think, either Access or ODBC is not a real good idea.
SQLite is a real good idea, if you need a small embedded database.
So far as I know, its even not a good idea, to compare MySQL and
Postgres to SQLite, because MySQL is a
Hello all
If I look at the "Locking And Concurrency"-Description from my
current Viewpoint, as a Viewpoint with present understandig, the
Description is ok.
If I remember to my Viewpoint in the past, without this present
understandig, before some very pleasant helppostings explain the
Original-Nachricht
Datum: Wed, 05 Jul 2006 17:24:54 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello John
> Ann don't cry into your beer, there is always next time! My team also
> got knocked out by Italy.
Original-Nachricht
Datum: Wed, 05 Jul 2006 19:30:04 +0100
Von: Nikki Locke <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> We seem to have a misunderstanding over the definition of "optomistic
> locking".
Yes, maybe... ;-)
> To me,
Original-Nachricht
Datum: Wed, 05 Jul 2006 13:01:12 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> First, sad about the football, but someone has to win.
Its only football... and so hard it is... the italian
Original-Nachricht
Datum: Wed, 05 Jul 2006 07:32:47 -0600
Von: Dennis Cote <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
> Anne,
>
> Yes, ...
A simple "Yes" :-)))
>...your description is correct
Hi Dennis
Many thanks to you too.
Hi Nikki
Many thanks for your answer. Its really helpful.
First time it seems to me, that I understand the problem.
In the past it happens, that the message in some Postings sometimes
lives behind a Fog :-))) Thinks dont will be get clearly.
Its sometimes not so easy, to put it on the same
Original-Nachricht
Datum: Wed, 5 Jul 2006 13:19:30 +0200
Von: "Olaf Beckman Lapré" <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hi Olaf
> Why not use optimistic locking (timestamp based pseudo locking)? It's
> ussually sufficient.
Thats
Original-Nachricht
Datum: Tue, 04 Jul 2006 19:13:56 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hi John
I think, I understand what you will to say
> Sqlite is a single file shared between users just like a
Original-Nachricht
Datum: Tue, 04 Jul 2006 12:01:25 -0500
Von: John Stanton <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Multiple Users
Hello Gerrry, Aristotle and John
Many thanks for your answers. I'm very glad about your help.
Yes, I found this
Hi to all
... any questions... ;-)
How many Users can operate with one SQLite-DB at the same time?
That means (for example) max 5 users can work with a MDB (MS Access)
connected via OLEDB. If more then 5 Users (writer) connect, the MDB
getting often instable or corrupt. Is the a recommended
> I am confused what are you trying to acheive by building a Unicode
> DLL?
I'm really confused to... ;-)
OK. The Facts:
I create SQLite-Release-DLL's, one Unicode, one MCBS
I create SQLite-Debug-Libs with symbolic informations, also
Unicode and MCBS. For all this I use the Source-Version
Hi to all
I have created my own 2 SQLite-DLL's, one as a Unicode-DLL and the
other one as Multibyte-DLL.
If I create a Test-App with Unicode selected and import the
Unicode-DLL it works fine. If I do the same, but have Multibyte
select und import the MBCS-DLL, some crazy things happens:
Some in
Hi John
> Anne, you don't say that you make your 100 inserts a transaction.
Yes, I don't make the inserts in a transaction... because in that
moment don't know how to use it.
Now I have read in the Docu and after it seems to me, that I understand,
I insert a Test-Function in my App. I start
Hi to all
Today I inserted as a Test 100 Records in my DB. I repeat therefor
100 times the same "Insert into...". The Job starts and I wait,
and wait, and wait.
I say, Programm hangs or died, because I do a Mistake in Code.
But it isn't.
The Job needs really so much time. Trace-Message
Hi Dennis
Thanks for your answer. You have see my problem and its solution.
I look sometimes at SQLite with my "OLE-DB"-Eyes. In OLE-DB is
the Recordset Reader and Writer allways at the same time.
Now I consider this... and it works fine.
Greetings, Anne
> I think you are saying you have
Hi to all
...meet another problem... ;-)
Is it possible to open more than one active Recordset connect
to a single-opened Database? This means, that I want to open
the Database one times in a initial Function of the App. And
then followed, i want to open more as one Recordset connected to
this
Hi Derrel
> --- Ursprüngliche Nachricht ---
> Von: [EMAIL PROTECTED]
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] Proposal: sqlite3_column_rowid
> Datum: Tue, 16 May 2006 09:12:37 -0400
> What does it do with queries that are pulling data from multiple tables?
> How about computed
Hi Ralf
> --- Ursprüngliche Nachricht ---
> Von: Ralf Junker <[EMAIL PROTECTED]>
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] Charset-Confusions
> Datum: Tue, 16 May 2006 11:10:28 +0200
> You have asked "How is it so complicated? *hmmm*" Well, because SQLite
> does not have an interface
Hi Dennis
> --- Ursprüngliche Nachricht ---
> Von: Dennis Cote <[EMAIL PROTECTED]>
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] Charset-Confusions
> Datum: Mon, 15 May 2006 14:55:19 -0600
>
> You should try Ralf Junker's SQLiteSpy (see
>
Hi
I have some confusion again. I have create the same Database 4 times
and after that perform Insert some records. I dont change the
SQL-Commands.
1. Compiler-Option Unicode and run "sqlite3_exec()"
2. Compiler-Option Multibyte and run "sqlite3_exec()"
3. Compiler-Option Unicode and run
> --- Ursprüngliche Nachricht ---
> Von: John Stanton <[EMAIL PROTECTED]>
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] BLOB
> Datum: Sat, 13 May 2006 08:17:29 -0700
>People with English as a first language can have difficulty
>understanding the description of manifest typing in the
Hi
sqlite saya: (sorry... dont know, how to answer in thread)
>Re: [sqlite] How can I get the type of a column?
>sqlite
>Thu, 11 May 2006 16:50:34 -0700
>
>
>Most SQL implementations use fixed-size records
>so it makes more sense for them to enforce each
>column's data type exactly - inserting
Hi John
> The current API is complete regarding types. It returns both the
> declared type and the type actually stored. There is nothing else.
>
> Note that the actual storage type can vary between rows according to the
> data format, which is why the actual type is returned row by row.
Hi John
Thanks for your answer... :-)
> You could use CSV to go to Excel, SQL to Oracle etc. ..*snip*
I do that all very succesful with ADO and OLE-DB... very rarely
got problems.
> If you don't want to use the Sqlite API then you have probably
>chosen
i want to use SQLite, because it's a
Hi (...at the first time... ;-)
My App (up to 1500 Users, up to 15 Million Records in
some tables in a SQL-Server-DB) offers as a specially
feature Data-Export. The Export-Functionally is one of
the most-used feature by Users. Exports are controlled
and done by a Report, controlled and done
26 matches
Mail list logo
