Re: SQLite conundrum

2015-12-16 Thread Bob Sneidar
Copy the sql statement into an SQL utility and try to execute it there. See what you get. Bob S > On Dec 15, 2015, at 07:26 , James Hale wrote: > > I have an array of text values (actually book chapters) that I am adding to a > database. > The text is a mixture of alphabetic and numerals. >

Re: SQLite conundrum - Solved

2015-12-16 Thread James Hale
Luckily one cannot see your red face behind an email. My app keeps master copies of the dbs I use and as a new book is added copies the master to the user's folder, renames it and proceeds to populate it. It has been quite some time since I last read in a book as I have been editing the app usin

Re: SQLite conundrum

2015-12-15 Thread Peter Haworth
Hi James, Very strange. I seriously doubt sqlite is manipulating the data in any way. Are you displaying the data using lc calls? Don't recall if you are an SQLiteAdmin customer but if so, I suggest you go to the SQL tab, execute an insert with sample data, then execute a select statement to displa

SQLite conundrum

2015-12-15 Thread James Hale
I have an array of text values (actually book chapters) that I am adding to a database. The text is a mixture of alphabetic and numerals. For some of it I have line numbers at the beginning of each paragraph. E.g blah blah1. Blah blah more blah.2. Some more blah After I insert this text