Re: [sqlite] creating a table

Thank you! John On 11/22/2016 01:21 PM, R Smith wrote: On 2016/11/22 6:00 PM, John R. Sowden wrote: That was a throw back to years ago. I was trying to protect against y2k by making each dbf for 1 calendar year. Also, these files are about 800k in size, so I was worried about storage

Re: [sqlite] creating a table

On 2016/11/22 6:00 PM, John R. Sowden wrote: That was a throw back to years ago. I was trying to protect against y2k by making each dbf for 1 calendar year. Also, these files are about 800k in size, so I was worried about storage and search time. Storage is not an issue anymore. I will

Re: [sqlite] creating a table

On 22 Nov 2016, at 5:03pm, John R. Sowden wrote: > Thank you, but I am currently in the early learning phase of sql databases > and the sql language. I am starting with Sqlite due to its relative > simplicity, and moving on to H2 to integrate it into Libre Office.

Re: [sqlite] creating a table

Thank you, but I am currently in the early learning phase of sql databases and the sql language. I am starting with Sqlite due to its relative simplicity, and moving on to H2 to integrate it into Libre Office. It's commands like analyze that I have never heard of and need to become familiar

Re: [sqlite] creating a table

John, On Tue, Nov 22, 2016 at 11:00 AM, John R. Sowden wrote: > That was a throw back to years ago. I was trying to protect against y2k by > making each dbf for 1 calendar year. Also, these files are about 800k in > size, so I was worried about storage and search

Re: [sqlite] creating a table

That was a throw back to years ago. I was trying to protect against y2k by making each dbf for 1 calendar year. Also, these files are about 800k in size, so I was worried about storage and search time. Storage is not an issue anymore. I will know about search time after learning about sql

Re: [sqlite] creating a table

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)

Re: [sqlite] creating a table

On 21 Nov 2016, at 21:55, Igor Korot wrote: > You are of course correct. It does depend on an application. > However, I tried to explain the SQLite and its paradigm in terms of > the dBase/FoxPro. You were correct also, Igor, and gave good advice. Best regards, Niall

Re: [sqlite] creating a table

Hi, Niall, On Mon, Nov 21, 2016 at 12:52 PM, Niall O'Reilly wrote: > On 21 Nov 2016, at 17:29, 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

Re: [sqlite] creating a table

> On Nov 21, 2016, at 10:08 AM, John R. Sowden > wrote: > > Thank you all for your answers and direction for further information. > Hopefully, I will not bring these subjects up again. :) Some of what you’re asking applies to any SQL database. The SQLite docs do

Re: [sqlite] creating a table

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

Re: [sqlite] creating a table

On 21 Nov 2016, at 17:29, 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

Re: [sqlite] creating a table

Hi, John, On Mon, Nov 21, 2016 at 12:29 PM, 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

Re: [sqlite] creating a table

John, There is a lot of documentation on the SQLite website. Here's the 'official' docs on creating a table https://www.sqlite.org/lang_createtable.html A Sqlite database consists of many tables. I am unsure if there is an upper limit, if there is, its more tables than I have ever created.

Re: [sqlite] creating a table with an index

Hi Sam, > I am trying to create a table with two indexes: > > CREATE TABLE favorites ( > cust_id CHAR(32) NOT NULL, > fldoid CHAR(38) NOT NULL, > imgoid CHAR(64) NOT NULL, > PRIMARY KEY (cust_id), > INDEX (fldoid, imgoid)); > > SQLite keeps complaining saying there is an error around

Re: [sqlite] creating a table with an index

"Sam Carleton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am trying to create a table with two indexes: > > CREATE TABLE favorites ( >cust_id CHAR(32) NOT NULL, >fldoid CHAR(38) NOT NULL, >imgoid CHAR(64) NOT NULL, >PRIMARY KEY (cust_id), >INDEX (fldoid,