Re: [sqlite] (dot) output call locks up when used on a named pipe

On Sat, 31 Dec 2016 15:16:19 -0500 Paul Lambert wrote: > I have used the (dot) .output call in conjunction with a both a file > and name pipe on Linux with Sqlite 3.13 installed. With a file this > functions successfully and completes. When using a named pipe this >

Re: [sqlite] (dot) output call locks up when used on a named pipe

On 12/31/16, Paul Lambert wrote: > The "wb" your listing has add the "b" but based on what I have found > the "b" adds nothing and is the same as just "w." True for Linux. But SQLite is x-platform. And the "w" is significant on other systems. -- D. Richard Hipp

Re: [sqlite] Out of date online documents

On Sat, Dec 31, 2016 at 4:04 PM, Simon Slavin wrote: > > On 31 Dec 2016, at 8:59pm, Kevin Benson wrote: > > > > The Home page Search *DOES* result in linking to > > "other dot commands" but *NOT* > > "special commands to sqlite3 dot commands" nor

[sqlite] Happy New Year!

Hi Happy New year to people on this lists. Many more releases and without bugs. :-) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Out of date online documents

On 31 Dec 2016, at 8:59pm, Kevin Benson wrote: > > The Home page Search *DOES* result in linking to > "other dot commands" but *NOT* > "special commands to sqlite3 dot commands" nor > "rules for dot commands". Because there are no such commands. The dot commands are

Re: [sqlite] Out of date online documents

On Sat, Dec 31, 2016 at 3:20 PM, Paul Lambert wrote: > Web search. In fact I cannot find any link on the sqlite.org page that > links to the (dot) functions, alias special functions. > > The Home page Search *DOES* result in linking to "other dot commands" but *NOT* "special

Re: [sqlite] (dot) output call locks up when used on a named pipe

I will need to do some testing. Here is an example of fopen using a named pipe mkfifo fifoname /* issue fopen for write end of the fifo */ wr_stream = fopen(fifoname,"w"); from:

Re: [sqlite] (dot) output call locks up when used on a named pipe

On 12/31/16, Paul Lambert wrote: > I have observed that the file write mode of this function when using the > same file name a second time will delete the previous data in the file. > This is most likely accomplished by deleting the file and recreating a new > one. if so then

Re: [sqlite] Out of date online documents

Web search. In fact I cannot find any link on the sqlite.org page that links to the (dot) functions, alias special functions. Nothing there on the By Alphabetical Name, or SQL as Understood by Sqlite webpages. Seems to me that there should be a link on Undertsood by Sqlite similar to the

[sqlite] (dot) output call locks up when used on a named pipe

I have used the (dot) .output call in conjunction with a both a file and name pipe on Linux with Sqlite 3.13 installed. With a file this functions successfully and completes. When using a named pipe this functions locks up sqlite and it must be aborted for termination. I have observed that the

Re: [sqlite] Out of date online documents

On 31 Dec 2016, at 8:06pm, Richard Hipp wrote: > Huh. Ok. It's gone now. I suppose Google's spider will figure that > out at some point and remove the link. Allow 6 weeks. At least, last time I looked it took Google’s cycle for checking every reference in its database

Re: [sqlite] Out of date online documents

On 12/31/16, Luuk wrote: > > On 31-12-16 20:52, Richard Hipp wrote: >> On 12/31/16, Paul Lambert wrote: >>> While exploring the sqlite.org website for specific sqlite details I >>> found >>> the document at the URL below which is labelled as "draft" and

Re: [sqlite] (dot) commands will execute from sqlite command line but not from query

On 12/31/16, Paul Lambert wrote: > > Issue 2. No matter how I mix the use of .system in a trigger I cannot get > the syntax checker to allow for (dot) functions .system or .shell to > work. I know there is a qualifier about where the (dot) functions are > parsed but I have

Re: [sqlite] (dot) commands will execute from sqlite command line but not from query

On 31 Dec 2016, at 7:55pm, Paul Lambert wrote: > Issue 2. No matter how I mix the use of .system in a trigger I cannot get > the syntax checker to allow for (dot) functions .system or .shell to > work. Dot functions are not part of SQLite. They are handled directly by the

Re: [sqlite] Out of date online documents

On 31-12-16 20:52, Richard Hipp wrote: On 12/31/16, Paul Lambert wrote: While exploring the sqlite.org website for specific sqlite details I found the document at the URL below which is labelled as "draft" and appears to be from version 3.6.11. The latest release is 3.15

[sqlite] (dot) commands will execute from sqlite command line but not from query

On Linux with sqlite 3.13.0 installedI have successfully invoked the (dot) commands .system and .shell. Below are the results. In both instances the application at the target location launched as expected. (Ignore the Gtk message as it relates to the modal dialog box employed in the the

Re: [sqlite] Out of date online documents

On 12/31/16, Paul Lambert wrote: > While exploring the sqlite.org website for specific sqlite details I found > the document at the URL below which is labelled as "draft" and appears to > be from version 3.6.11. The latest release is 3.15 and I currently have > version 3.13

[sqlite] Out of date online documents

While exploring the sqlite.org website for specific sqlite details I found the document at the URL below which is labelled as "draft" and appears to be from version 3.6.11. The latest release is 3.15 and I currently have version 3.13 installed. https://www.sqlite.org/sessions/sqlite.html .shell