Re: [sqlite] After column add, what should be done to update the schema?

Probably a bug. SQLiteExpert does not even run on my computer. It just farts in the wind and does not even bother to log or show an error message. Maybe it tries to access some internal Microsoft Spying mechanism that I have disabled. -- The fact that there's a Highway to Hell but only a

Re: [sqlite] After column add, what should be done to update the schema?

Bonjour, I use a simple ALTER TABLE ADD COLUMN statement. However, when I use the Sqlite Expert, the DDL is not reflected. Even though the column is created. I read somewhere that the DDL is really just a copy of the text when teh table was created. Is there a way to refresh this? I can't

[sqlite] After column add, what should be done to update the schema?

Hi, I use a simple ALTER TABLE ADD COLUMN statement. However, when I use the Sqlite Expert, the DDL is not reflected. Even though the column is created. I read somewhere that the DDL is really just a copy of the text when teh table was created. Is there a way to refresh this? Thanks, Andy

Re: [sqlite] sqlite-users Digest, Vol 146, Issue 27

On Thu, Feb 27, 2020 at 6:00 AM < sqlite-users-requ...@mailinglists.sqlite.org> wrote: > 18. Cannot export 'sqlite3' file to CSV (Rachael Courts) > From: Rachael Courts > To: "sqlite-users@mailinglists.sqlite.org" < > sqlite-users@mailinglists.sqlite.org> > Cc: > Bcc: > Date: Thu, 27 Feb 2020

Re: [sqlite] Issues with sqlite3session_attach(conn, NULL) w/ duplicate table in temp

Dan, I tried the above patch and it resolves the issue! Also you were right about use of "*" in attach. I misinterpreted the output of my test in that case. Thank you so much for taking the time to fix this! When can I expect this patch to make it into a release? Adam Levy On Thu, Feb 27, 2020

Re: [sqlite] Issues with sqlite3session_attach(conn, NULL) w/ duplicate table in temp

On 27/2/63 05:04, Adam Levy wrote: Hi all When I have a database connection with a temp table of the same name as a table in main, I am getting what I feel is unexpected behavior from the session extension. Most succinctly, I start a session on a connection on the main db with a table with an

Re: [sqlite] Cannot export 'sqlite3' file to CSV

Easier still: Install https://nightlies.sqlitebrowser.org/latest/ Then open your sqlite database(s) directly within the browser. There you can run queries and/or export to csv. On Thu, Feb 27, 2020, 4:54 AM Shawn Wagner wrote: > Use the standard sqlite3 shell program: >

Re: [sqlite] VFS xFullPathname cannot access URI parameters

On 2/26/20, Chris Warner wrote: > In 3.31.1, attempting to access URI Parameters via the sqlite3_uri_* > functions inside a VFS xFullPathname function returns junk. This was not an > issue in 3.30.1 or 3.31.0. > SQLite does not promise that sqlite3_uri_parameter() will work for the argument

Re: [sqlite] Cannot export 'sqlite3' file to CSV

Use the standard sqlite3 shell program: https://www.sqlite.org/cli.html#csv_export On Thu, Feb 27, 2020, 1:48 AM Rachael Courts wrote: > Hi All, > > I'm a couple of months into my PhD, studying bioacoustics. I am using > SQLiteStudio to open '.sqlite3' files, which I need to convert to CSV

[sqlite] Cannot export 'sqlite3' file to CSV

Hi All, I'm a couple of months into my PhD, studying bioacoustics. I am using SQLiteStudio to open '.sqlite3' files, which I need to convert to CSV files to import into MATLAB for further analyses. Currently I have attempted the data export function, selecting which database and table I would