Re: [sqlite] WPF, VS 2010 and System.Data.SQLite 1007200

I thought support was missing for design time for now (I'm new around here, so I could well be wrong). Are there nightly builds or betas with these features? - Anthony On Tue, Jun 28, 2011 at 1:55 AM, Wamiduku wrote: > On May 23, 5:52 pm, "Christoph P.U. Kukulies"

[sqlite] Compile sqlite3 with g++? Do I need a wrapper?

Hello everybody, I am trying to use g++ to compile my C++ application, which uses sqlite3. After googling for several hours this is what I tried: g++ -g /home/phongcao/main.cc -o -lsqlite3 /home/phongcao/main `pkg-config --cflags --libs gtkmm-2.4` However, the program was not compiled. I also

Re: [sqlite] WPF, VS 2010 and System.Data.SQLite 1007200

On May 23, 5:52 pm, "Christoph P.U. Kukulies" wrote: > Am 23.05.2011 17:02, schrieb Drew Hohmann: > > > Hello, > > What steps do I need to take to get SQLite to appear in the list of Data > > Providers in Visual Studio 2010?  I've installed the latest > > System.Data.SQLite

Re: [sqlite] Best solution to import big DBF file?

On Mon, 27 Jun 2011 18:05:41 +0200, Dominique Pellé wrote: >Spatialite (extension of SQLite) implements VirtualDbf and VirtualShp. Thanks for the info. I'm not sure I understand what Spatialite is ("The SpatiaLite extension enables SQLite to support spatial data too

Re: [sqlite] Breaking a string into two

> BareFeetWare wrote: >> I have some source data that includes a "Silo And Region" column of two >> words appended together, such as 'NorthPlains', >> 'SouthPlains', 'NorthSlopes', 'SouthSlopes' etc. I want to split them into >> two columns. >> >> How can I do this

Re: [sqlite] How to check foreign keys

On Mon, 27 Jun 2011 07:13:14 +0200, Cecil Westerhof wrote: >2011/6/26 Kees Nuyt > >> I think Cecil was referring to the fact that some program can >> forget to switch foreign_keys to on, and delete rows that are >> referenced, or change primary keys. >>

Re: [sqlite] ISNULL in sqlite

Yes, I'm checking for empty string, but it wasn't working for null. The suggestions by kind people here helped resolve it. Thank you! On Mon, Jun 27, 2011 at 11:16 AM, Gerry Snyder wrote: > On 6/25/2011 12:33 PM, logan...@gmail.com wrote: > > Hello, > > > > How do I

[sqlite] System.TypeInitializationException in SQLiteFactory constructor...

Has anybody seen this before? I use System.Data.SQLite for a project and the program will not run on a client's computer. This is the exception listed in the event viewer. Thanks, John ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] ISNULL in sqlite

On 6/25/2011 12:33 PM, logan...@gmail.com wrote: > Hello, > > How do I check for a null or empty string in SQLite. In addition to the other replies you have received, you need to be made aware that an empty string and a NULL are very different, and (perhaps) both have to be checked for,

Re: [sqlite] ISNULL in sqlite

Thank you everyone!! On Sat, Jun 25, 2011 at 9:27 PM, Jay A. Kreibich wrote: > On Sat, Jun 25, 2011 at 04:55:13PM -0400, Igor Tandetnik scratched on the > wall: > > logan...@gmail.com wrote: > > > How do I check for a null or empty string in SQLite. SQL server has > ISNULL > > >

Re: [sqlite] PRAGMA bug in 3.7.7 (but fine in 3.7.6.3)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/26/2011 03:52 PM, Richard Hipp wrote: > The bug is that it is returning > SQLITE_SCHEMA instead of SQLITE_OK. If you wanted to, you could just ignore > the error and keep going and everything would work. Will there be a point release soon

Re: [sqlite] Best solution to import big DBF file?

Gilles Ganault wrote: > Hello > > I have a 87MB file in DBF format that I'd like to import into SQLite. > > What is the best tool for this, free or affordable? > > Thank you. Spatialite (extension of SQLite) implements VirtualDbf and VirtualShp. To create a virtual

Re: [sqlite] sqlite-users Digest, Vol 42, Issue 27

Thanks Michael, that solves the problem. Pete Message: 1 > Date: Sun, 26 Jun 2011 12:01:43 + > From: "Black, Michael (IS)" > Subject: Re: [sqlite] Substring question > To: General Discussion of SQLite Database > Message-ID:

Re: [sqlite] Selecting indexes to use & NOT INDEXED

On 6/27/2011 11:18 AM, Mohit Sindhwani wrote: > We felt that the query was a bit slow: > > select * FROM Objects, Objects_Index > WHERE Objects.id = Objects_Index.id > AND minx<= 668632 + 250 AND maxx>= 668632 - 250 > AND miny<= 1518661 + 250 AND maxy>= 1518661 - 250 > AND

Re: [sqlite] How to recover the SQLITE_CORRUPT error in C programming ?

On Mon, Jun 27, 2011 at 16:15:16 +0800, baiydavid wrote: > Thanks for you help. > > when an SQLITE_CORRUPT error is returned, we can use ".dump" command to > exports the data into a sql script, and then exec this sql in a new database, > But how to dump the data into a sql script with C

Re: [sqlite] Functions and index

On 27 June 2011 16:16, hilaner wrote: > I have hundred thousands of records in this table: > > CREATE TABLE days ( >        day_id INTEGER NOT NULL PRIMARY KEY, >        day_date DATE > ); > > CREATE INDEX day_i ON days (day_date ASC); > > And then if I run such query: > >

Re: [sqlite] Selecting indexes to use & NOT INDEXED

On Jun 27, 2011, at 11:18 AM, Mohit Sindhwani wrote: > select * FROM Objects, Objects_Index > WHERE Objects.id = Objects_Index.id > AND minx <= 668632 + 250 AND maxx >= 668632 - 250 > AND miny <= 1518661 + 250 AND maxy >= 1518661 - 250 > AND CAT=25; > > Doing an explain query plan

[sqlite] Selecting indexes to use & NOT INDEXED

Hi All, Sorry for the long email, but the background is probably needed :) 1. We have a geographical query that is supported by an R-Tree index. A join is required to filter by category while restricting by the bounding box. On the main table (objects), we have an index IDX_OBJ_CAT on

[sqlite] Functions and index

I have hundred thousands of records in this table: CREATE TABLE days ( day_id INTEGER NOT NULL PRIMARY KEY, day_date DATE ); CREATE INDEX day_i ON days (day_date ASC); And then if I run such query: EXPLAIN QUERY PLAN SELECT JULIANDAY(MAX(day_date)) FROM days; 0|0|0|SCAN TABLE

Re: [sqlite] Basebase Locked Error

On 27 Jun 2011, at 3:36pm, Jason Gray wrote: > Hello, I found the problem. The > "[Transactional(TransactionalTypes.TransactionScope)]" decoation was keeping > a lock on the database. So that prompts another question.. What is the best > way to implement Transactions? Can you just execute

Re: [sqlite] Basebase Locked Error

Hello, I found the problem.  The "[Transactional(TransactionalTypes.TransactionScope)]" decoation was keeping a lock on the database. So that prompts another question.. What is the best way to implement Transactions?   thanks,   Jason From: Jason Gray To:

Re: [sqlite] Best solution to import big DBF file?

On Mon, 27 Jun 2011 17:14:52 +0400, Alexey Pechnikov wrote: >1. sqlite3-dbf - converter of XBase / FoxPro tables to SQLite >http://sqlite.mobigroup.ru/wiki?name=sqlite3-dbf Thanks Alexey, worked the first time: # dpkg -i sqlite3-dbf_2010.08.16_i386.deb # sqlite3-dbf

Re: [sqlite] Best solution to import big DBF file?

On Mon, 27 Jun 2011 14:22:43 +0100, Carlos Rocha wrote: >I think you'll find what you need here >http://www.vlsoftware.net/ Thanks for the link. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How to recover the SQLITE_CORRUPT error in C programming ?

Perhaps you could look at the code in shell.c and see how it does the .dump, then copy paste or something similar into your own app. I'm not sure if there might be issues with functions declared SQLITE_API vs SQLITE_INTERNAL, which may require some additional working around, but hopefully not.

Re: [sqlite] Best solution to import big DBF file?

Hi I think you'll find what you need here http://www.vlsoftware.net/ > Hello > > I have a 87MB file in DBF format that I'd like to import into SQLite. > > What is the best tool for this, free or affordable? > > Thank you. > > ___ > sqlite-users mailing

Re: [sqlite] Best solution to import big DBF file?

On 27 Jun 2011, at 2:12pm, Gilles Ganault wrote: >> As Simon said, the sqlite3 shell can import structured text files. > > But I need to first convert the DBF file into CSV, right? Your problem seems to be with opening the DBF file without the original app. So perhaps there's a general DBF

Re: [sqlite] Best solution to import big DBF file?

1. sqlite3-dbf - converter of XBase / FoxPro tables to SQLite http://sqlite.mobigroup.ru/wiki?name=sqlite3-dbf 2. Or see the VirtualText extension from Spatialite project. This extension can be builded with SQLite http://sqlite.mobigroup.ru/dir?name=ext/virtualtext

Re: [sqlite] Best solution to import big DBF file?

On Mon, 27 Jun 2011 14:57:31 +0200, Stephan Beal wrote: >Google suggests several: Yes, but I'd like to save time by not having to evaluate them if someone's done this recently. There are only two converters listed on the site, and they seem to require FoxPro for DOS

Re: [sqlite] Best solution to import big DBF file?

On Mon, Jun 27, 2011 at 2:51 PM, Gilles Ganault wrote: > Is there a way to open a DBF file and get a text dump? > Google suggests several: http://www.google.de/search?sourceid=chrome=UTF-8=export+dbf+file+to+text As Simon said, the sqlite3 shell can import structured

Re: [sqlite] Best solution to import big DBF file?

On Mon, 27 Jun 2011 13:42:33 +0100, Simon Slavin wrote: >Dump the contents as text and use the SQLite command-line shell to import it. Thanks for the tip, but I don't have the DBase application, just the file (it's actually three files: Two small ones with the column

Re: [sqlite] Best solution to import big DBF file?

On 27 Jun 2011, at 1:38pm, Gilles Ganault wrote: > I have a 87MB file in DBF format that I'd like to import into SQLite. > > What is the best tool for this, free or affordable? Dump the contents as text and use the SQLite command-line shell to import it.

[sqlite] Best solution to import big DBF file?

Hello I have a 87MB file in DBF format that I'd like to import into SQLite. What is the best tool for this, free or affordable? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How to recover the SQLITE_CORRUPT error in C programming ?

On 27 Jun 2011, at 9:15am, baiydavid wrote: >when an SQLITE_CORRUPT error is returned, we can use ".dump" command to > exports the data into a sql script, and then exec this sql in a new database, >But how to dump the data into a sql script with C programming Interface? > Is there any

[sqlite] Basebase Locked Error

Hello, I hope you can help me with a problem I'm having. I'm using CLSA business objects and SQLite as the datastore. Essentially this is what I'm trying to do, shouldn't this work?   [Transactional(TransactionalTypes.TransactionScope)]     protected override void DataPortal_Insert()     {   

Re: [sqlite] Meaning of values in sqlite_stat1

On Mon, Jun 27, 2011 at 2:49 AM, Cecil Westerhof wrote: > When giving: >select * from sqlite_stat1; > I get: >tbl|idx|stat >utilities|sqlite_autoindex_utilities_2|67 1 >utilities|sqlite_autoindex_utilities_1|67 1 >

Re: [sqlite] randomness issues on windows

On Sat, Jun 25, 2011 at 11:20 PM, bob wrote: > i'm getting an issue relating to the use of the random() function in a > SQL query. > > i run 2 PHP scripts very quickly (less than 1 second apart). > > they use an SQL query like    SELECT * FROM table ORDER BY random() LIMIT 5; >

[sqlite] How to recover the SQLITE_CORRUPT error in C programming ?

Thanks for you help. when an SQLITE_CORRUPT error is returned, we can use ".dump" command to exports the data into a sql script, and then exec this sql in a new database, But how to dump the data into a sql script with C programming Interface? Is there any other better method to solve

Re: [sqlite] PRAGMA bug in 3.7.7 (but fine in 3.7.6.3)

Greg Stein wrote on Sun, Jun 26, 2011 at 19:20:30 -0400: > On Sun, Jun 26, 2011 at 18:52, Richard Hipp wrote: > > On Sun, Jun 26, 2011 at 3:59 PM, Greg Stein wrote: > > > >> Hey all, > >> > >> There is a bug in 3.7.7 that affects Apache Subversion. We've

Re: [sqlite] Should i upgrade SQLITE for my system?

Hi, you can look at the changes doumented here http://www.sqlite.org/changes.html and determine if they are beneficial for your application. Also, my own application runs faster with the newest version (I upgraded from version 3.2.5) Martin Am 27.06.2011 09:48, schrieb Hoang Linh Duong: >

[sqlite] Should i upgrade SQLITE for my system?

Hi all, Currently i'm using SQLite 3.6.22 for my system. I know the latest SQLite is version 3.7.7; im just wondering if i should update SQLite in my system. Is there any significant change in the this latest SQLite? Please advise. Thanks. Linh ___

[sqlite] Meaning of values in sqlite_stat1

When giving: select * from sqlite_stat1; I get: tbl|idx|stat utilities|sqlite_autoindex_utilities_2|67 1 utilities|sqlite_autoindex_utilities_1|67 1 categories|sqlite_autoindex_categories_1|4 1 weights|sqlite_autoindex_weights_1|228 57 1 I am curious about the stat field.