Re: [sqlite] Is there way to modify table structure after initial definition ?

2012-02-20 Thread Larry Brasfield
Huang Chen Min wrote: Dear all: Forgive for asking such stupid question. I use Xbase way to understand SQLite. It is allowed to modify dat type of column in clipper. In my personal thoughts, Creating a brandnew table and copy those data from older version might be an alternative way. Is

Re: [sqlite] Relative path to sqlite database

2012-02-20 Thread Igor Tandetnik
Agrawal, Manish wrote: > All the sqlite examples I see use absolute paths to the sqlite database in > Visual Studio projects, e.g. > "C:\users\test\apps\db\test.db3". > > How can I specify the path to the sqlite database relative to the application > root folder, e.g.

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-20 Thread Joe Mistachkin
As of System.Data.SQLite version 1.0.79.0, design-time installer support is included in the appropriate setup packages. The instructions on the blog post you linked to should now be considered obsolete. NOTE #1: Since Visual Studio itself is a 32-bit process, you will need to install the 32-bit

Re: [sqlite] Relative path to sqlite database

2012-02-20 Thread Agrawal, Manish
Ah, I should have thought of that. When I run the application (Ctrl+F5), the path is created in bin/debug. This is also the folder where the .exe file is created. Just a quick note though, when I move the .exe file to the desktop and double-click on it, it crashes, which suggests that the

Re: [sqlite] Relative path to sqlite database

2012-02-20 Thread Simon Slavin
On 21 Feb 2012, at 2:49am, "Agrawal, Manish" wrote: > All the sqlite examples I see use absolute paths to the sqlite database in > Visual Studio projects, e.g. "C:\users\test\apps\db\test.db3". > > How can I specify the path to the sqlite database relative to the application

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-20 Thread Brady Kelly
On 21 February 2012 04:45, Agrawal, Manish wrote: > I am still playing with the sqlite setup in Visual Studio. Previously I > found success following the instructions at: > > > http://www.tsjensen.com/blog/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions.aspx > > But

[sqlite] Relative path to sqlite database

2012-02-20 Thread Agrawal, Manish
All the sqlite examples I see use absolute paths to the sqlite database in Visual Studio projects, e.g. "C:\users\test\apps\db\test.db3". How can I specify the path to the sqlite database relative to the application root folder, e.g. "db\test.db3"? This is helpful when I am developing the app

[sqlite] SQLite data source in Visual Studio 2010

2012-02-20 Thread Agrawal, Manish
I am still playing with the sqlite setup in Visual Studio. Previously I found success following the instructions at: http://www.tsjensen.com/blog/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions.aspx But this requires the sqlite packages to be "installed" on the local computer.

[sqlite] Is there way to modify table structure after initial definition ?

2012-02-20 Thread 黃楨民
Dear all: Forgive for asking such stupid question. I use Xbase way to understand SQLite. It is allowed to modify dat type of column in clipper. In my personal thoughts, Creating a brandnew table and copy those data from older version might be an alternative way. Is there any instrument to

Re: [sqlite] Reference error

2012-02-20 Thread Joe Mistachkin
David Horne wrote: > > Thanks for the help. If you've any other ideas then please let me know. > I'm confused, do you actually mean the "System.Data.SQLite.dll" file (not sqlite.dll)? Judging from the error message, it seems you may have an extraneous install of System.Data.SQLite somewhere.

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Joe Mistachkin
Electric Eddy wrote: > > This then popped up an error message dialogue box stating: > > Invalid core file image runtime version. > You'll want to copy the "Installer.exe" file to your installation directory first (where the "SQLite.Designer.dll" file resides). -- Joe Mistachkin

Re: [sqlite] why is count of rows in LEFT JOIN more than the rowsinthe left table

2012-02-20 Thread Igor Tandetnik
Puneet Kishor wrote: > is there are way to force the query to return only the "first" match so the > resulting query has only as many rows as the left > table? SELECT COUNT(*) FROM ( SELECT 1 FROM a LEFT JOIN b ON a.col = b.col GROUP BY a.rowid); -- Igor Tandetnik

Re: [sqlite] why is count of rows in LEFT JOIN more than the rows inthe left table

2012-02-20 Thread Puneet Kishor
On Feb 20, 2012, at 12:46 PM, Jay A. Kreibich wrote: > On Mon, Feb 20, 2012 at 05:01:17PM +, Simon Slavin scratched on the wall: >> >> On 20 Feb 2012, at 4:11pm, Puneet Kishor wrote: >> >>> is there are way to force the query to return only the "first" match >>> so

Re: [sqlite] why is count of rows in LEFT JOIN more than the rows inthe left table

2012-02-20 Thread Jay A. Kreibich
On Mon, Feb 20, 2012 at 05:01:17PM +, Simon Slavin scratched on the wall: > > On 20 Feb 2012, at 4:11pm, Puneet Kishor wrote: > > > is there are way to force the query to return only the "first" match > > so the resulting query has only as many rows as the left table? >

Re: [sqlite] Reference error

2012-02-20 Thread Larry Brasfield
David Horne wrote: Thanks for the link. I ran the tool on sqlite.dll and got the following error: IESHIMS.DLL Error opening file. The system cannot find the file specified (2). Warning: At least one delay-load dependency module was not found. Warning: At least one module has an unresolved

Re: [sqlite] Reference error

2012-02-20 Thread David Horne
Thanks for the link. I ran the tool on sqlite.dll and got the following error: IESHIMS.DLL Error opening file. The system cannot find the file specified (2). Warning: At least one delay-load dependency module was not found. Warning: At least one module has an unresolved import due to a missing

Re: [sqlite] why is count of rows in LEFT JOIN more than the rows inthe left table

2012-02-20 Thread Simon Slavin
On 20 Feb 2012, at 4:11pm, Puneet Kishor wrote: > is there are way to force the query to return only the "first" match so the > resulting query has only as many rows as the left table? You have two problems: A) You are JOINing two columns which contain some null values.

Re: [sqlite] why is count of rows in LEFT JOIN more than the rows inthe left table

2012-02-20 Thread Puneet Kishor
On Feb 20, 2012, at 9:34 AM, Igor Tandetnik wrote: > Puneet Kishor wrote: >> But, why is #5 329743 and not 329686? Where are the extra 57 rows coming >> from? I thought a LEFT JOIN was supposed to include >> *all* the rows from the left table with NULLs for the columns of

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Electric Eddy
VS is installed on an x64 system so when I build using VS IDE I normally specify x86. I don't normally build using MSBuild however, I inserted the line: x86 in the project file and changed references to Any CPU to x86 and then rebuilt the installer but get the same error when I run the command.

Re: [sqlite] Help request for a query...

2012-02-20 Thread Igor Tandetnik
Igor Tandetnik wrote: > Roger Andersson wrote: >> This seems to work but I do not fully understand why ;-) >> sqlite> .header on >> sqlite> CREATE TABLE IF NOT EXISTS History (Path TEXT UNIQUE NOT NULL, >> Hits INTEGER); >> sqlite> insert or replace into

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Rob Richardson
In another library, I had to specify "x86" processor because it wasn't designed for 64-bit machines. Might you need to do that? RobR -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Electric Eddy Sent: Monday, February 20,

Re: [sqlite] why is count of rows in LEFT JOIN more than the rows inthe left table

2012-02-20 Thread Igor Tandetnik
Puneet Kishor wrote: > But, why is #5 329743 and not 329686? Where are the extra 57 rows coming > from? I thought a LEFT JOIN was supposed to include > *all* the rows from the left table with NULLs for the columns of the right > table where there was no match. So, at most,

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Electric Eddy
I performed the following steps: 1) Checked out the latest local copy using the command 'fossil update' 2) I opened a Visual Studio command prompt, changed into the tools installer folder and executed the command MSBuild Installer.2008.csproj 3) I changed into the root/bin/2008/Debug/bin folder

Re: [sqlite] why is count of rows in LEFT JOIN more than the rows in the left table

2012-02-20 Thread Dan Kennedy
On 02/20/2012 10:16 PM, Puneet Kishor wrote: Could someone please shed some light on this mystery for me? 1. SELECT Count(*) FROM a; 329686 2. SELECT Count(*) FROM a WHERE a.col IS NULL; 3 3. SELECT Count(*) FROM b;

[sqlite] why is count of rows in LEFT JOIN more than the rows in the left table

2012-02-20 Thread Puneet Kishor
Could someone please shed some light on this mystery for me? 1. SELECT Count(*) FROM a; 329686 2. SELECT Count(*) FROM a WHERE a.col IS NULL; 3 3. SELECT Count(*) FROM b; 6268 4. SELECT Count(*)

Re: [sqlite] replacing several nested queries and UNION ALLs with one query

2012-02-20 Thread Gerry Snyder
a2 != '' seems redundant when a1 = a2 and a1 != '' ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Joe Mistachkin
Electric Eddy wrote: > > Maybe not going as far as including updates in the installer for support > for 2005 but at least a manual process for getting it working in 2005 would > be very helpful. > I've just checked-in preliminary support to the design-time component installer for Visual Studio

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Electric Eddy
Just the SQLiteDataAdapter component to work in 2005. I've no immediate need to compile SQLite from source as the downloadable Setup for .NET is enabling me build my projects successfully. The problem is I initially used the designer to create a number of SQLiteDataAdapters and related components

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Joe Mistachkin
Electric Eddy wrote: > > Maybe not going as far as including updates in the installer for support > for 2005 but at least a manual process for getting it working in 2005 would > be very helpful. > Out of curiosity, what do you need more, the design-time component installer to work with Visual

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Electric Eddy
I was just going on the basis of what I paid for the professional version the last time. Although 2005 is an old version there are a huge number of developers maintaining legacy systems on this platform, so I would consider it worthwhile keeping them in the loop, and would be willing to setup a

Re: [sqlite] Reference error

2012-02-20 Thread Joe Mistachkin
David Horne wrote: > > I get the following runtime error - > > System.InvalidOperationException was unhandled > Message=An error occurred creating the form. See Exception.InnerException > for details. The error is: > > Could not load file or assembly 'System.Data.SQLite, Version=1.0.79.0, >

Re: [sqlite] Data base locked.

2012-02-20 Thread Simon Slavin
On 20 Feb 2012, at 8:09am, bhaskarReddy wrote: > While running Data base with sqlite, i am getting error as Data > base locked. > > How to resolve from this error. Don't lock the database. Bhaskar, have you ever read any of the documentation or is your first

Re: [sqlite] sqlite3 interactive shell

2012-02-20 Thread Simon Slavin
On 20 Feb 2012, at 7:42am, Kf Lee wrote: > New to sqlite3. Install 3.7.10 with --prefix=/usr/local and source in > /usr/locsl/sqlite3-src. Can run sqlite3 test.db when attached to the > source directory but would get sqlite header and source mismatch if try to > start

[sqlite] Reference error

2012-02-20 Thread David Horne
As a new sqlite user, I've written a simple program in VB (Visual Basic 2010 Express), adding a reference to sqlite.dll in the project file. The following code builds without errors. Imports System.Data.SQLite Public Class Form1 Private dbConn As SQLiteConnection Public Sub New()

Re: [sqlite] BUG REPORT using refreshschema on SQLiteCommandBuilder

2012-02-20 Thread ITS Smoynihan
Joe Here is an MS link that describes using/manipulating the command texts , but I had misinterpreted the instructions . http://msdn.microsoft.com/en-us/library/tf579hcz.aspx so , you are correct , no bug , but the behaviour with SqlCommandBuilder is a bit different which does not null the

[sqlite] Data base locked.

2012-02-20 Thread bhaskarReddy
Hi Friends, While running Data base with sqlite, i am getting error as Data base locked. How to resolve from this error. Regards, Bhaskar. -- View this message in context: http://old.nabble.com/Data-base-locked.-tp33355225p33355225.html Sent from the SQLite mailing list archive at