Hi Roger,
I don't have any clue. Two databases are corrupted. First one, while
inserting 20,000 records suddenly sqlite thrown disk io error at 4,000
record. No clue.
Second database corrupted when my application crashed. But that time,
second database was not opened.
So, I am planning to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/12/12 19:01, dcharno wrote:
> What ever happened to Unql and is there any chance it will be revived?
> It seemed like it would have been incredible useful.
Warning: My opinion only
Unql seemed to be especially pointless. Being somewhat compati
What ever happened to Unql and is there any chance it will be revived?
It seemed like it would have been incredible useful.
:(
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Kristine Peters wrote:
> Does sqlite3 support foreign key constraints with m:n relations?
In your logical model, you have a M:N relation.
In the phyiscal database, however, you implement this as a separate
table which can be seen as having two 1:N relations, so what you have
are two separate forei
Does sqlite3 support foreign key constraints with m:n relations?
I can get cascade update/delete to work with 1:n relations, but not m:n.
Example, this schema works: (yes, it¹s from the Elmasri text; it shows a 1:n
relationship between EMPLOYEE and DEPARTMENT; also the 1:N relationship to
the wea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/12/12 21:44, dd wrote:
> Sometimes, sqlite databse corrupts.
That is the problem you need to fix. If you have a system that is
unreliable then it will also corrupt your backups.
http://www.sqlite.org/lockingv3.html#how_to_corrupt
http://www.sq
Hallo,
vielen Dank für Ihre Nachricht.
Ich bin in der Zeit vom 10.12. bis 11.12.2012 im Urlaub und werde mich nach
meiner Rückkehr bei Ihnen melden.
Ihre Nachricht wird nicht weitergeleitet.
Mit freundlichen Grüßen
Carl Slowinski
oxando GmbH
Konrad-Zuse-Ring 12
D-68163 Mannheim
Germany
On Mon, Dec 10, 2012 at 11:04 AM, Bruno Kim Medeiros Cesar <
brunokim...@gmail.com> wrote:
> Thanks for your answer.
>
> Is it explicit somewhere in the site, or should it be? I guessed to be the
> case, but there's no notice as we see on NASA images, for example.
>
There is no notice on the webs
Thanks for your answer.
Is it explicit somewhere in the site, or should it be? I guessed to be the
case, but there's no notice as we see on NASA images, for example.
Bruno Kim Medeiros Cesar
Eng. de Computação 2008 - EESC - USP
brunokim...@gmail.com
Skype: bkim.cesar
2012/12/10 Richard Hipp
>
On Mon, Dec 10, 2012 at 9:40 AM, Simon Slavin wrote:
>
> On 10 Dec 2012, at 2:38pm, Richard Hipp wrote:
>
> > The "SQLite" name and the new SQLite Logo are registered trademarks.
>
> Let's ask it a different way. If I write something and want to list
> SQLite as one of the technologies in it, h
On 10 Dec 2012 at 14:40, Simon Slavin wrote:
> On 10 Dec 2012, at 2:38pm, Richard Hipp wrote:
>
>> The "SQLite" name and the new SQLite Logo are registered trademarks.
>
> Let's ask it a different way. If I write something and want to list SQLite as
> one of the technologies in it, how would y
On 10 Dec 2012 at 14:05, William Drago wrote:
> I am using SQLite with C# and am having trouble with SQLite
> DATETIME types. The following error occurs when trying to
> read rows from a table that contains dates (e.g. "12/09/2012
> 22:51:24"). (I am using a SQLiteDataReader to put query
> result
On 10 Dec 2012, at 2:38pm, Richard Hipp wrote:
> The "SQLite" name and the new SQLite Logo are registered trademarks.
Let's ask it a different way. If I write something and want to list SQLite as
one of the technologies in it, how would you like me to list SQLite ? Is there
any small image
Lets agree to disagree, sqlite is completely cross-plaform. You could
develop a cross plate-form solution in the same time (Qt or Tcl/tk). The
95% market does not hold if you think smart-phone and tablet (a good target
for a simple data entry application). If you only want windows, why not
uuse Ac
On Mon, Dec 10, 2012 at 8:57 AM, Bruno Kim Medeiros Cesar <
brunokim...@gmail.com> wrote:
> Hello.
>
> Is there a policy on how to use the SQLite logo? Is it copyrighted or in
> public domain? I found it as an SVG in a non-official site, and was
> wondering if it is free to edit and modify.
>
Th
On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet
wrote:
>It's probably a good way to get something working, but you loose the
>cross-platform
I know, but Windows is 95% of the market for end-users, cross-platform
is a pain to write, they take longer to load and always look/act funny
anyway :-)
Gmail users: You can set a Filter to ensure the Igor's messages are
delivered to your in-box. I did this last week and since then his
messages do not end up in my SPAM folder.
If you search
"This message may not have been sent by..." warning in Gmail help,
there are instructions.
Adam
On Mon,
William Drago wrote:
> I am using SQLite with C# and am having trouble with SQLite DATETIME
> types.
In SQLite, the DATETIME type is interpreted in the same way as the
FLUFFY_BUNNIES type, i.e., it is not recognized at all. Due to
SQLite's dynamic typing, values in that column have the same type
William Drago wrote:
> I am using SQLite with C# and am having trouble with SQLite
> DATETIME types. The following error occurs when trying to
> read rows from a table that contains dates (e.g. "12/09/2012
> 22:51:24"). (I am using a SQLiteDataReader to put query
> results into a C# DataTable.)
C
It's probably a good way to get something working, but you loose the
cross-platform
On 10 December 2012 14:47, Gilles Ganault wrote:
> On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin
> wrote:
> >There are lots of people who manipulate data that way, but they tend to
> export
> > their data fr
All,
I am using SQLite with C# and am having trouble with SQLite
DATETIME types. The following error occurs when trying to
read rows from a table that contains dates (e.g. "12/09/2012
22:51:24"). (I am using a SQLiteDataReader to put query
results into a C# DataTable.)
"String was not recog
Hello.
Is there a policy on how to use the SQLite logo? Is it copyrighted or in
public domain? I found it as an SVG in a non-official site, and was
wondering if it is free to edit and modify.
I would like to do a little homage to SQLite, and have inserted the
blessing within the blue box as in th
On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin
wrote:
>There are lots of people who manipulate data that way, but they tend to export
> their data from the SQLite database into their favourite spreadsheet app,
> do the manipulation there, then reimport to SQLite.
> This prevents them from having
Clearly, Igor is too helpful and responds to too many messages... *rolls
eyes*
I'm not on gmail, so I didn't know this was even a problem, but
hopefully it gets sorted out soon.
Ryan
On 09/12/2012 2:01 AM, dd wrote:
Yes. Igor Tandetnik mails marked as a spam nowadays. I marked it as a NOT
S
On 10 Dec 2012, at 11:00am, Gilles Ganault wrote:
> That's why I thought there could be a need for a datagrid that would
> save data in SQLite and provide basic sort/search functions.
There are lots of people who manipulate data that way, but they tend to export
their data from the SQLite data
On Sun, 09 Dec 2012 14:15:30 +0100, Olaf Schmidt
wrote:
>The only thing remaining for a decent workflow, which in
>the end is based on SQLite-storage, would then be a small
>batch-program or -script, which ensures the SQLite-To-CSV
>conversion (the sqlite-commandline-tool could do that) -
>accompa
On Sun, 9 Dec 2012 07:42:08 -0600, "Michael Black"
wrote:
>Generally speaking database and spreadsheet functionality are not similar
>enough to combine.
Thanks for the input. Indee, maybe the two concepts are just too
different.
___
sqlite-users mailin
In the list of PRAGMAs in
pragma.html
the "PRAGMA user_version" documentation link to
http://www.sqlite.org/pragma.html#pragma_user_version
is invalid. It should point to
http://www.sqlite.org/pragma.html#pragma_schema_version
instead.
This is also present in today's documentation draf
28 matches
Mail list logo