Re: [sqlite] WITHOUT ROWID tables

2020-02-17 Thread sky5walk
unday, February 16, 2020 6:11:02 PM > To: SQLite mailing list > Subject: Re: [sqlite] WITHOUT ROWID tables > > On 16 Feb 2020, at 6:00pm, Bernardo Ramos wrote: > > > I've got no rows for both with and without rowid tables: > > <https:

Re: [sqlite] WITHOUT ROWID tables

2020-02-16 Thread x
; for Windows 10 From: sqlite-users on behalf of Simon Slavin Sent: Sunday, February 16, 2020 6:11:02 PM To: SQLite mailing list Subject: Re: [sqlite] WITHOUT ROWID tables On 16 Feb 2020, at 6:00pm, Bernardo Ramos wrote: > I've got no rows for both with and w

Re: [sqlite] WITHOUT ROWID tables

2020-02-16 Thread Peter da Silva
name='?' AND type='table' > >contains "WITHOUT ROWID" > > > >be sufficient? > > > >Just being curious. > > > >- Original Message - > >From: sky5w...@gmail.com > >To: SQLite mailing list > >Sent: Saturday, February 15, 2020, 1

Re: [sqlite] WITHOUT ROWID tables

2020-02-16 Thread Simon Slavin
On 16 Feb 2020, at 6:00pm, Bernardo Ramos wrote: > I've got no rows for both with and without rowid tables: " as of SQLite version 3.30.0 on 2019-10-04 " ___ sqlite-users mailing list

Re: [sqlite] WITHOUT ROWID tables

2020-02-16 Thread Bernardo Ramos
I've got no rows for both with and without rowid tables: SQLite version 3.27.2 2019-02-25 16:06:06 Enter ".help" for usage hints. sqlite> create table t1(name); sqlite> create table t2(name primary key, phone) without rowid; sqlite> pragma index_info(t1); sqlite> pragma index_info(t2); sqlite>

Re: [sqlite] WITHOUT ROWID tables

2020-02-15 Thread J. King
>From: sky5w...@gmail.com >To: SQLite mailing list >Sent: Saturday, February 15, 2020, 18:06:47 >Subject: [sqlite] WITHOUT ROWID tables > >Ok, not ideal. Still confusing, but I see the difference. >For my code, I know the schemas. I guess a SQL builder could offer up >quer

Re: [sqlite] WITHOUT ROWID tables

2020-02-15 Thread Thomas Kurz
t: [sqlite] WITHOUT ROWID tables Ok, not ideal. Still confusing, but I see the difference. For my code, I know the schemas. I guess a SQL builder could offer up query options to the user browsing new databases. On Sat, Feb 15, 2020 at 11:26 AM Simon Slavin wrote: > On 15 Feb 2020, at

Re: [sqlite] WITHOUT ROWID tables

2020-02-15 Thread curmudgeon
Does sqlite3_table_column_metadata(db,dbName,tblName,"rowid",0,0,0,0,0)==SQLITE_OK return false if table tblName is a without rowid table? https://sqlite.org/c3ref/table_column_metadata.html -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___

Re: [sqlite] WITHOUT ROWID tables

2020-02-15 Thread sky5walk
Ok, not ideal. Still confusing, but I see the difference. For my code, I know the schemas. I guess a SQL builder could offer up query options to the user browsing new databases. On Sat, Feb 15, 2020 at 11:26 AM Simon Slavin wrote: > On 15 Feb 2020, at 3:14pm, sky5w...@gmail.com wrote: > > >> To

Re: [sqlite] WITHOUT ROWID tables

2020-02-15 Thread Simon Slavin
On 15 Feb 2020, at 3:14pm, sky5w...@gmail.com wrote: >> To determine if table XYZ is a WITHOUT ROWID table, run "PRAGMA >> index_info('XYZ');". If you get back one or more rows, then XYZ is a >> WITHOUT ROWID table. If you get back no rows, then XYZ is a rowid >> table. >> > Confused...What if

Re: [sqlite] WITHOUT ROWID tables

2020-02-15 Thread sky5walk
> > To determine if table XYZ is a WITHOUT ROWID table, run "PRAGMA > index_info('XYZ');". If you get back one or more rows, then XYZ is a > WITHOUT ROWID table. If you get back no rows, then XYZ is a rowid > table. > Confused...What if I made an index on a ROWID table? CREATE INDEX "Z" ON "DOC"

Re: [sqlite] WITHOUT ROWID tables

2020-02-14 Thread Richard Hipp
On 2/14/20, Wayne Collins wrote: > My first posting so I hope I get the etiquette correct. > > 1st question How can I determine from a C-program if a table was > generated with the "WITHOUT ROWID" option? I have an application where > it is important to know if a table has a rowid or not. To

[sqlite] WITHOUT ROWID tables

2020-02-14 Thread Wayne Collins
My first posting so I hope I get the etiquette correct. 1st question How can I determine from a C-program if a table was generated with the "WITHOUT ROWID" option? I have an application where it is important to know if a table has a rowid or not. 2nd Question After a database is defined and

Re: [sqlite] WITHOUT ROWID tables with a ROWID

2019-02-22 Thread Tom Bassel
Ah I see now. Sorry I should have read the docs more carefully -- it is working according to spec in all cases. Great answers. Thanks guys! Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] WITHOUT ROWID tables with a ROWID

2019-02-22 Thread tom-sqlite
Ah I see now. Sorry I should have read the docs more carefully -- it is working according to spec in all cases. Great answers. Thanks guys! Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] WITHOUT ROWID tables with a ROWID

2019-02-21 Thread David Raymond
t; affinity. Aka "prefer to store it as an integer but don't have to" sort. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Tom Bassel Sent: Thursday, February 21, 2019 3:02 PM To: sqlite-users@mailinglists.sqlite.org S

Re: [sqlite] WITHOUT ROWID tables with a ROWID

2019-02-21 Thread J. King
On 2019-02-21 15:02:23, "Tom Bassel" wrote: Are tables t3, t4, and t5 below working as designed? Yes. See : > The rowid value can be accessed using one of the special case-independent names "rowid", "oid", or "_rowid_" in place of a column

[sqlite] WITHOUT ROWID tables with a ROWID

2019-02-21 Thread Tom Bassel
Hi, this is my first post to this group. I am not trying to be difficult. I work on an app that uses SQLite as the underlying database engine. At one time years ago I remember assuming that the ROWID column in a table in SQLite would always be an integer. However, I can see a user who is not