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
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
In SQLite type guid does not exist. Look at this documentation:
https://www.sqlite.org/datatype3.html
Affinity for guid would be BLOB but in trigger you store TEXT.
I do not use .NET but I think you should use different parameter
type. I would use TEXT type.
Regards R.A.
On 14.02.2020 15:09,
Thanks for the response. Do you suggest me keeping storing TEXT (and declaring
the column as TEXT instead of GUID) or storing and declaring BLOB (and remove
HEX)?
I think both cases would work, but for performance, does it matter? AS long as
my index is binary collated, it probably does not,
In SQLite type guid does not exist. Look at this documentation:
https://www.sqlite.org/datatype3.html
Affinity for guid would be BLOB but in trigger you store TEXT.
I do not use .NET but I think you should use different parameter
type. I would use TEXT type.
Regards R.A.
On 14.02.2020 15:09,
Hi,
I am having trouble searching for a Guid. I think some conversion is missing.
I wonder if someone can point me to the error…
Column:
[ID] GUID(16)
Index:
CREATE UNIQUE INDEX [ID_INDEX] ON [DXLOG]([ID] COLLATE [BINARY] ASC);
Trigger:
CREATE TRIGGER [AUTOGENERATE_ID] AFTER INSERT ON [DXLOG]
On 14 Feb 2020, at 2:59pm, Andy KU7T wrote:
> Do you suggest me keeping storing TEXT (and declaring the column as TEXT
> instead of GUID) or storing and declaring BLOB (and remove HEX)?
TEXT. Makes sorting and searching easier.
___
sqlite-users
How can I prevent receiving the "ok" added here:
https://www.sqlite.org/src/info/b3692c406f7ba625
when I'm using `sqlite -cmd "PRAGMA key " database.sqlite .output`?
iulianOnofrei
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
test
iulianOnofrei
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 13-Feb-20 23:38, Keith Medcalf wrote:
Correct. "memory" databases can only be shared between connections in the same process, and then
only by the sharedcache method. In effect, a "memory" database is nothing more than a cache, and
sharing it between connections means sharing the cache.
10 matches
Mail list logo