Thank you.
On Sun, Nov 18, 2012 at 8:18 PM, Yuriy Kaminskiy wrote:
> Durga D wrote:
> >What happens if sqlite3_close() called multiple times but
> > sqlite3_open_v2() called only once.
> >
> > Practically I dint see any malfunction/corruption here. I would like
> to
> > know the behavio
Vladislav Bolkhovitin, on 11/17/2012 12:02 AM wrote:
The easiest way to implement this fsync would involve three things:
1. Schedule writes for all dirty pages in the fs cache that belong to
the affected file, wait for the device to report success, issue a cache
flush to the device (or request or
Thanks for your answer. I'd like to know to what extent I can convert a Sqlite
schema to a Mysql one, but I find the question interesting for itself. What if
we forget about modifying commands and care only about retrieval?
Clemens Ladisch wrote:
I wonder why you want to know this?
Well, a
On 19 Nov 2012 at 01:57, ZikO wrote:
> The script looks like this:
> CREATE TABLE IF NOT EXISTS imiona (
> id INTEGER PRIMARY KEY,
> data TEXT,
> imie1 TEXT,
> imie2 TEXT,
> imie3 TEXT);
>
> INSERT INTO imiona (data,imie1,imie2,imie3) VALUES
> ('01/01/2012','Masława
Hello,
I'm using ADO.NET-Provider for SQLite (System.Data.SQLite, Version 1.0.80).
My database is password-protected. The password is passed in the connection
string.
Sporadically, I get the following exception:
Exception: The database disk image is malformed
malformed database schema (VALUE1) -
On 19 Nov 2012, at 1:57am, ZikO wrote:
> The script was written in Notepad++
> that controls which charset coding is used but I also double checked it in
> Notepad and it indicated UTF-8; it can also be confirmed by reading the
> script text file in Hex editor that shows BOM at the beginning:
>
ZikO wrote:
> INSERT INTO imiona (data,imie1,imie2,imie3) VALUES
> ('01/01/2012','Masława','Mieczysława','Mieszka'),
>
> As you can see, it contains accents. The script was written in Notepad++
> that controls which charset coding is used but I also double checked it in
> Notepad and it indicated U
ZikO wrote:
> I then used the conding UTF-8 without BOM and the command was accepted but
> unfortunately I get the strange result:
> sqlite> select * from imiona;
> 1 01/01/2012 MasławaMieczysława Mieszka
This looks like correct UTF-8, it's just that the console window doesn't k
On Sun, Nov 18, 2012 at 8:57 PM, ZikO wrote:
> Hello,
> thanks for your answers.
>
> I downloaded both precompiled binaries and shell for windows from
> www.sqlite.org.
>
> The script looks like this:
> CREATE TABLE IF NOT EXISTS imiona (
> id INTEGER PRIMARY KEY,
> data TEXT,
>
Hello,
thanks for your answers.
I downloaded both precompiled binaries and shell for windows from
www.sqlite.org.
The script looks like this:
CREATE TABLE IF NOT EXISTS imiona (
id INTEGER PRIMARY KEY,
data TEXT,
imie1 TEXT,
imie2 TEXT,
imie3 TEXT);
INSERT
emilbarton wrote:
> I wonder which classes of nested SQL requests are not expressible as joins?
I wonder why you want to know this?
Well, anything where you cannot use joins in the first place, such as
UPDATE/DELETE commands:
DELETE FROM question
WHERE type_id IN (SELECT id
Hello,
I wonder which classes of nested SQL requests are not expressible as joins?
Could you answer in non-jargon with examples please?
Thank you in advance (and thank you for Sqlite by the way!).
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
12 matches
Mail list logo