I posted this a while ago:
http://sqlite.1065341.n5.nabble.com/Loading-Options-from-the-command-line-binary-td12230.html
It's not very obvious.
John wrote:
Hi,
I have several different computers running an AppleScript that queries and
writes to a SQLite3 database located in a shared folder
I finally figured out how to load multiple dot commands or settings
from the command line tool. (Some users only have the default binary to
rely on, ya know.) Since I have never found this information on the web
before, I thought I would post it here to share the information.
To load options
I finally figured out how to load multiple dot commands, pragma
settings, or settings from the command line tool. (Some users only have
the default binary to rely on, ya know.) Since I have never found this
information on the web before, I thought I would post it here to share
the information.
Original Message
Subject: Re: [sqlite] FTS4 code from the website
From: Dan Kennedy danielk1...@gmail.com
Date: 7/1/2011 7:33 AM
On 06/30/2011 08:55 PM, Ryan Henrie wrote:
Even if I use the stock example from the web page, with only 2 columns,
and the exact schema from
of columns!)
Original Message
Subject: Re: [sqlite] FTS4 code from the website
From: Dan Kennedy danielk1...@gmail.com
Date: 6/29/2011 11:25 PM
On 06/30/2011 10:31 AM, Ryan Henrie wrote:
Reference Page: http://www.sqlite.org/fts3.html#appendix_a
At the bottom of the page
Reference Page: http://www.sqlite.org/fts3.html#appendix_a
At the bottom of the page, there is a sample c file to calculate the
rank, and a FTS query to use it. I can't get it to work.
You can see my files here:
http://coldmist.homeip.net/quotes_sql_test.txt
