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