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,
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.
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
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
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
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.)
> 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,
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
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
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 ";
10 matches
Mail list logo