Re: [sqlite] Newbie issues with SQLite & C#

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

Re: [sqlite] What is the easiest way of changing the field type?

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

Re: [sqlite] What is the easiest way of changing the field type?

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

Re: [sqlite] What is the easiest way of changing the field type?

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

Re: [sqlite] get records for foreign keys which come from various places

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

Re: [sqlite] get diffrent column C from table

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

[sqlite] get diffrent column C from table

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

Re: [sqlite] list: Please allow signed messages.

-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)

Re: [sqlite] What is the easiest way of changing the field type?

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

[sqlite] Bug: Segmentation fault in libsqlite3.so.0.8.6[b69a4000+ac000]

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

[sqlite] list: Please allow signed messages.

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

Re: [sqlite] Database size bigger than before deleting records

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

Re: [sqlite] What is the easiest way of changing the field type?

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

Re: [sqlite] What is the easiest way of changing the field type?

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:

Re: [sqlite] What is the easiest way of changing the field type?

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

Re: [sqlite] What is the easiest way of changing the field type?

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

[sqlite] What is the easiest way of changing the field type?

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

[sqlite] Deprecation of asyncvfs

-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)

[sqlite] Newbie issues with SQLite & C#

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

[sqlite] get records for foreign keys which come from various places

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

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

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

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

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

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

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

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

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