<hr /><i>anonymous added on 2010-10-29 23:51:13:</i><br />
How to access functions accessible in fossil by built-in sqlite shell?

Thanks.

<pre>
c:\bin>fossil help sqlite
Usage: fossil sqlite3 ?DATABASE? ?OPTIONS?
Run the standalone sqlite3 command-line shell on DATABASE with OPTIONS.
If DATABASE is omitted, then the repository that serves the working
directory is opened.

c:\bin>fossil sqlite myfossilclone.fossil
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT * FROM sqlite_master where name ='blob';
table|blob|blob|2|CREATE TABLE blob(
  rid INTEGER PRIMARY KEY,
  rcvid INTEGER,
  size INTEGER,
  uuid TEXT UNIQUE NOT NULL,
  content BLOB,
  CHECK( length(uuid)==40 AND rid>0 )
)

sqlite> select * from blob where rid =9310;
9310|526|43735|a67ab11ff47c2c026af817110a564a13fd9c33a2|

sqlite> select content from blob where rid =9310;
returns nothing
</pre>