Just a thought about your TABLE named "log16":
I'm not at all a database expert but from the idea what a table is, I
would take a more general approach. CREATE a TABLE log with
columns year, logtext, timestamp a la:
CREATE TABLE LOG (logtext TEXT, timestamp TEXT, year INTEGER PRIMARY KEY)
Just my 2cts.
Christoph
Am 21.11.2016 um 19:08 schrieb John R. Sowden:
Thank you all for your answers and direction for further information.
Hopefully, I will not bring these subjects up again. :)
John
On 11/21/2016 09:29 AM, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I understand that with
Sqlite a database includes tables and other items. The scenario that
I do not understand, is: say I have a log file with about 7 fields
totaling about 80 characters per record. How do I name the database
and table. Currently I say log16 for the year 2016.
Secondly, I have 2 "front ends" for Sqlite on my Ubuntu 16.04
computer. Neither one allows me to set the length of the text fields
in the table creation process. How does the Sqlite know how long
each record should be, same with integers.
No help found in the documentation on the Sqlite web site.
John
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users