William Drago wrote:
>
> 1) I'm not really sure how to install SQLite. I downloaded
> sqlite-netFx40-setup-x86-2010-1.0.82.0.exe and ran setup.
Installing System.Data.SQLite is only necessary if you need the
Visual Studio design-time components.
>
> Is that all it takes?
>
That depends on
Regarding:
> >
> > Note that you only need to .dump/.read the table(s) you want to alter.
>
> *Well, I don't think it's true.
> 1. When I execute "CREATE TABLE" with the table name that already exists
> wouldn't I get an error message?
> 2. If I drop this table first I will get an error about the
Donald,
On Sun, Dec 2, 2012 at 7:22 PM, Donald Griggs wrote:
> Regarding:
>
> *How do I do that?
> I thought that simply using ".backup/.restore" will give me what I want,
> but it gives me a file in internal format.
> What I am trying to do is do make a text file which gives
Regarding:
*How do I do that?
I thought that simply using ".backup/.restore" will give me what I want,
but it gives me a file in internal format.
What I am trying to do is do make a text file which gives me all SQL command
that was issued (CREATE TABLE and INSERT) than fix the particular CREATE
e-mail mgbg25171 wrote:
> I've only just discovered that you can get rows for foreign keys doing this
>
> SELECT f.*
>FROM firms f
>inner JOIN calls c
>ON f.id = c.firm_id group by c.firm_id;
I don't quite understand
YAN HONG YE wrote:
> b c
> 854809 868763
> 854808 854809
> 854980 854808
> 854974 854980
> 854973 854974
> 854780 854973
> 854778 854780
> 854769 854778
> 854768 854769
> 854738 854768
> 854691 854738
> 854690 854691
> 853709 854690
> 856707 853709
> 856697 856707
> 856695 856697
> 927681 856695
b c
854809 868763
854808 854809
854980 854808
854974 854980
854973 854974
854780 854973
854778 854780
854769 854778
854768 854769
854738 854768
854691 854738
854690 854691
853709 854690
856707 853709
856697 856707
856695 856697
927681 856695
927696 927681
927695 927696
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/12/12 13:47, Paul Menzel wrote:
> please allow signed messages to be sent to the list.
>
> I got: »The message's content type was not explicitly allowed«
This works.
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Jay,
On Sun, Dec 2, 2012 at 1:31 PM, Jay A. Kreibich wrote:
> On Sun, Dec 02, 2012 at 12:52:33PM -0800, Igor Korot scratched on the wall:
>> Jay,
>>
>> On Sun, Dec 2, 2012 at 12:16 PM, Jay A. Kreibich wrote:
>> > On Sun, Dec 02, 2012 at 11:58:54AM -0800, Igor
Dear SQLite folks,
using Debian Sid/unstable with self-built Evolution 3.4.4 and
libsqlite3-0 3.7.14.1-1, Evolution crashed with a segmentation fault.
pool[15522]: segfault at 5 ip b69bafe3 sp 8acf0850 error 6 in
libsqlite3.so.0.8.6[b69a4000+ac000]
The backtrace from the core dump
Dear list administrators,
please allow signed messages to be sent to the list.
I got: »The message's content type was not explicitly allowed«
Thanks,
Paul
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Sun, Dec 02, 2012 at 09:39:23PM +0100, Henry Huang scratched on the wall:
> Good day everyone,
>
> I had a database file, and I deleted many records (tens of thousands) from
> three tables, then, I did a VACUUM to that database. After I checked the
> size of the database file, I was a bit
On Sun, Dec 02, 2012 at 12:52:33PM -0800, Igor Korot scratched on the wall:
> Jay,
>
> On Sun, Dec 2, 2012 at 12:16 PM, Jay A. Kreibich wrote:
> > On Sun, Dec 02, 2012 at 11:58:54AM -0800, Igor Korot scratched on the wall:
> >> Hi, ALL,
> >> ALTER TABLE command does not support
On 12/2/2012 1:52 PM, Igor Korot wrote:
So, does this mean that I need to drop the DB in the text file, edit
it and then re-create
it from this file?
How to make alterations to a table that can not be done with the ALTER
TABLE command is outlined in topic 11 of the FAQ:
Jay,
On Sun, Dec 2, 2012 at 12:16 PM, Jay A. Kreibich wrote:
> On Sun, Dec 02, 2012 at 11:58:54AM -0800, Igor Korot scratched on the wall:
>> Hi, ALL,
>> ALTER TABLE command does not support changing the field type.
>>
>> What is the easiest and fastest way to change the field
On Sun, Dec 02, 2012 at 11:58:54AM -0800, Igor Korot scratched on the wall:
> Hi, ALL,
> ALTER TABLE command does not support changing the field type.
>
> What is the easiest and fastest way to change the field type from
> integer to double?
The easy, fast, and dangerous method is to edit
Hi, ALL,
ALTER TABLE command does not support changing the field type.
What is the easiest and fastest way to change the field type from
integer to double?
I know it is all saved as text but for me when I look at the db
structure I know what
kind of variable I will use and what calculation
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
The documentation also needs to say asyncvfs is out of favour, in
particular on this page:
http://www.sqlite.org/asyncvfs.html
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
All,
This is my first post to this group... I'm hoping someone
can help me.
I've just wasted nearly 8 hours trying to get SQLite to work
with a C# program in Visual Studio 10 (32bit WinXP, .NET 4.0).
Here are the issues:
1) I'm not really sure how to install SQLite. I downloaded
I've only just discovered that you can get rows for foreign keys doing this
SELECT f.*
FROM firms f
inner JOIN calls c
ON f.id = c.firm_id group by c.firm_id;
that's fine where the foreign keys are from a single field in a single
table
(i.e. firm_id in calls)
but
what
Simon, sensible point about being cautious and I'm sorry my original post
caused a problem. However I can confirm to anyone reading this that
DISQLite3 is a brilliant product. Easy to use, fast, very robust and one
that allows you to communicate directly with SQLite3 databases without
having to
Thank you Simon for a very full and informative reply.
Howard
Date: Sat, 1 Dec 2012 19:37:45 -0800
From: ml-node+s1065341n65817...@n5.nabble.com
To: docshotma...@hotmail.com
Subject: Re: How to restore from backup or alter db in multi-user envionment?
On 1 Dec 2012, at 3:22pm, dochsm
On 2 Dec 2012, at 2:06pm, Ralf Junker wrote:
> On 02.12.2012 04:37, Simon Slavin wrote:
>
>>> I'm using DISQLite and the online api in delphi, not the command
>>> line thing.
>>
>> I have seen some bad drivers which assume that underlying schema will
>> not be changed by
On 02.12.2012 04:37, Simon Slavin wrote:
>> I'm using DISQLite and the online api in delphi, not the command
>> line thing.
>
> I have seen some bad drivers which assume that underlying schema will
> not be changed by another user while they have a database connection
> open. I have no reason to
24 matches
Mail list logo