Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-09 Thread Simon Slavin
On 10 Sep 2014, at 3:45am, Carlos A. Gorricho (HGSAS) wrote: > The problem was a field with a very long blank string, something like 40 > space-characters. Was this value correctly delimited with quotes, or was it just 40 spaces between two commas separating the

[sqlite] Problems uploading CSV into sqlite3 DB

2014-09-09 Thread Carlos A. Gorricho (HGSAS)
Dear all, A brief update on how I managed to solve the problem...thank you all for you remarks and comments, since these were instrumental in the solution. Indeed sqlite versions had to do a lot with the problem, where 3.8 can handle csv imports, not without some glitches. I had to go in circles

Re: [sqlite] GUI INfo

2014-09-09 Thread FarSight Data Systems
Max, I'm rurrently creating an application with sqlite using python and wxpython for the gui. It's a great combo and working out nicely. Mark On Tuesday, September 09, 2014 05:06:53 PM Teg wrote: > Hello Maxine, > > It's totally unrelated to Sqlite though. > > Pick a programming language

Re: [sqlite] GUI INfo

2014-09-09 Thread jose isaias cabrera
"Warren Young" wrote... On 9/10/2014 14:56, Maxine Nietz wrote: I am an experienced Access VBA programmer. I know about the SQLite commands to create and manipulate data in tables and queries. What I want to know is where do I find info on creating a graphical user interface such as menus,

Re: [sqlite] What if OpenDocument were built atop SQLite?

2014-09-09 Thread justin
On 2014-09-08 13:07, John McKown wrote: Open/Libre Office is Java based. Are you 100% about that? When I used to be involved with OpenOffice (years ago, prior to LibreOffice split), the main code was C++, with Java used for some things. OpenOffice Base was written in Java for example. I

Re: [sqlite] GUI INfo

2014-09-09 Thread Jens Alfke
> On Sep 10, 2014, at 1:56 PM, Maxine Nietz wrote: > > What I want to know is where do I find info on creating a graphical user > interface such as menus, forms and reports. What additional programs are > required to do this? SQLite doesn't have anything related to a

Re: [sqlite] GUI INfo

2014-09-09 Thread justin
On 2014-09-10 20:56, Maxine Nietz wrote: I am an experienced Access VBA programmer. I know about the SQLite commands to create and manipulate data in tables and queries. What I want to know is where do I find info on creating a graphical user interface such as menus, forms and reports. What

[sqlite] SQLITE GUI

2014-09-09 Thread Mark Halegua
Max, I'm currently creating an application with sqlite using python and wxpython for the gui. It's a great combo and working out nicely. Mark ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] GUI INfo

2014-09-09 Thread Ned Fleming
On Wed, 10 Sep 2014 13:56:39 -0700, "Maxine Nietz" wrote: >I am an experienced Access VBA programmer. I know about the SQLite commands >to create and manipulate data in tables and queries. You might want to use Visual Basic, a superset of VBA.

Re: [sqlite] FW: GUI INfo

2014-09-09 Thread Simon Slavin
On 9 Sep 2014, at 8:58pm, Maxine Nietz wrote: > Is this the way to post a question? Yes. We expect you to have made an effort to answer your question before you post. You should have a vague idea where to find things on this site: for

Re: [sqlite] GUI INfo

2014-09-09 Thread Teg
Hello Maxine, It's totally unrelated to Sqlite though. Pick a programming language that works with Sqlite and make a GUI with this programming language. C Wednesday, September 10, 2014, 4:56:39 PM, you wrote: MN> I am an experienced Access VBA programmer. I know about the SQLite commands MN>

Re: [sqlite] GUI INfo

2014-09-09 Thread Warren Young
On 9/10/2014 14:56, Maxine Nietz wrote: I am an experienced Access VBA programmer. I know about the SQLite commands to create and manipulate data in tables and queries. What I want to know is where do I find info on creating a graphical user interface such as menus, forms and reports. What

[sqlite] GUI INfo

2014-09-09 Thread Maxine Nietz
I am an experienced Access VBA programmer. I know about the SQLite commands to create and manipulate data in tables and queries. What I want to know is where do I find info on creating a graphical user interface such as menus, forms and reports. What additional programs are required to do

[sqlite] FW: GUI INfo

2014-09-09 Thread Maxine Nietz
Is this the way to post a question? Max From: Maxine Nietz [mailto:nevada...@sbcglobal.net] Sent: Monday, September 8, 2014 9:55 AM To: 'sqlite-users@sqlite.org' Subject: GUI INfo I am an experienced Access VBA programmer. I know about the SQLite commands to create and manipulate

Re: [sqlite] SQLAR pronunciation

2014-09-09 Thread Richard Hipp
On Tue, Sep 9, 2014 at 2:00 PM, Andy Goth wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I have to ask, and I apologize if it's been asked before, but... how > is SQLAR pronounced? My best guess is "squalor". :^) > >

[sqlite] SQLAR pronunciation

2014-09-09 Thread Andy Goth
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have to ask, and I apologize if it's been asked before, but... how is SQLAR pronounced? My best guess is "squalor". :^) http://www.sqlite.org/sqlar/doc/trunk/README.md - -- Andy Goth | -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22

Re: [sqlite] What if OpenDocument were built atop SQLite?

2014-09-09 Thread Nico Williams
On Mon, Sep 8, 2014 at 11:46 PM, Stephan Beal wrote: > FWIW: > > http://fossil.wanderinghorse.net/wikis/cson/?page=cson_sqlite3 Yup, I've written that sort of wrapper in Python too. Of course, in the preceding sub-thread I'm talking about something rather different, but

Re: [sqlite] sqlite crash when realloc fails

2014-09-09 Thread Richard Hipp
On Tue, Sep 9, 2014 at 10:39 AM, Dominique Devienne wrote: > On Tue, Sep 9, 2014 at 1:50 PM, Sebastien David > wrote: > > > I have a database with 10million of row in one table (file size is ~5GB) > > When I execute a query that should return half of

Re: [sqlite] sqlite crash when realloc fails

2014-09-09 Thread Dominique Devienne
On Tue, Sep 9, 2014 at 1:50 PM, Sebastien David wrote: > I have a database with 10million of row in one table (file size is ~5GB) > When I execute a query that should return half of this table, sqlite fails > because at some point there is no memory (this is normal) [...]

[sqlite] sqlite crash when realloc fails

2014-09-09 Thread Sebastien David
Hi, I have a database with 10million of row in one table (file size is ~5GB) When I execute a query that should return half of this table, sqlite fails because at some point there is no memory (this is normal) but instead of returning an error, it crashes. sqlite version: 3.7.5 #0

Re: [sqlite] About a problem "FTS expression tree is too large"

2014-09-09 Thread Clemens Ladisch
Nao Shoji wrote: > SELECT * FROM my_table WHERE ... word MATCH ' OR OR OR ... ' > > FTS expression tree is too large (maximum depth 12) This means that there are too many (more than 2^12) search words. You could split the word list so that you have multiple queries. (You might be

[sqlite] About a problem "FTS expression tree is too large"

2014-09-09 Thread Nao Shoji
Dear sqlite-users. I am Nao Shoji and I work as a server side engineer. In this time, I contacted to yours, because I faced a sqlite problem. On a daily basis, I develop web applications by PHP. Our application uses sqlite database as full-text searching engine. Additionally, a table format of