Re: [sqlite] Does SQLite use field definitions?

2017-02-03 Thread Hick Gunter
ff: Re: [sqlite] Does SQLite use field definitions? What about the INTEGER PRIMARY KEY (defined in my first email post)? Does this field start at 1, and then auto increment for each new line? On Thu, Feb 2, 2017 at 5:02 AM, R Smith <rsm...@rsweb.co.za> wrote: > > > On 2017/02/01 5:41 PM,

Re: [sqlite] Does SQLite use field definitions?

2017-02-02 Thread Keith Medcalf
On Thursday, 2 February, 2017 09:12, Clyde Eisenbeis inquired: > What about the INTEGER PRIMARY KEY (defined in my first email post)? > Does this field start at 1, and then auto increment for each new line? INTEGER PRIMARY KEY declares a field to be an alias for the rowid.

Re: [sqlite] Does SQLite use field definitions?

2017-02-02 Thread David Raymond
f Of Clyde Eisenbeis Sent: Thursday, February 02, 2017 9:12 AM To: SQLite mailing list Subject: Re: [sqlite] Does SQLite use field definitions? What about the INTEGER PRIMARY KEY (defined in my first email post)? Does this field start at 1, and then auto increment for each new line? On Thu, Feb 2, 2017

Re: [sqlite] Does SQLite use field definitions?

2017-02-02 Thread Clyde Eisenbeis
What about the INTEGER PRIMARY KEY (defined in my first email post)? Does this field start at 1, and then auto increment for each new line? On Thu, Feb 2, 2017 at 5:02 AM, R Smith wrote: > > > On 2017/02/01 5:41 PM, Clyde Eisenbeis wrote: >> >> I don't see MEMO listed. I

Re: [sqlite] Does SQLite use field definitions?

2017-02-02 Thread R Smith
On 2017/02/01 5:41 PM, Clyde Eisenbeis wrote: I don't see MEMO listed. I needed to use MEMO in Microsoft Access to handle char strings longer than 256. However, I don't see any complaints by SQLite when I use MEMO. SQLite will never complain about anything you use as a type. What you

Re: [sqlite] Does SQLite use field definitions?

2017-02-01 Thread Donald Griggs
The default maximum string length is one billion (10 ** 9). You can configure the maximum up to about twice that. https://www.sqlite.org/limits.html If column affinity matters in your application, you may want to declare your column as TEXT or maybe CLOB (identical effect.)

Re: [sqlite] Does SQLite use field definitions?

2017-02-01 Thread Jens Alfke
> On Feb 1, 2017, at 7:41 AM, Clyde Eisenbeis wrote: > > However, I don't see any complaints by SQLite when I use MEMO. SQLite actually ignores the column data types completely in a table spec. You can store any type of data in any column of any table. (In other words,

Re: [sqlite] Does SQLite use field definitions?

2017-02-01 Thread Clyde Eisenbeis
n: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: [sqlite] Does SQLite use field definitions? > > In the past, when using Access as a database, I have specified field > definitions. These field definitions have been used when creating a table. > > p

Re: [sqlite] Does SQLite use field definitions?

2017-01-31 Thread Hick Gunter
2017 17:07 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: [sqlite] Does SQLite use field definitions? In the past, when using Access as a database, I have specified field definitions. These field definitions have been used when creating a table. public const

[sqlite] Does SQLite use field definitions?

2017-01-31 Thread Clyde Eisenbeis
In the past, when using Access as a database, I have specified field definitions. These field definitions have been used when creating a table. public const string stFIELD_DEFINITIONS = " fstPriority TEXT, fstInfo MEMO, fstDateCreated TEXT, fstDateModified TEXT, fiKeyID INTEGER PRIMARY KEY ";