How are you calling Sqlite?  Have you tried sqlite3.exe?

ohadp wrote:
Scott Hess <[EMAIL PROTECTED]> writes:



 CREATE VIRTUAL TABLE t USING fts1(content);
 INSERT INTO t (rowid, content) VALUES (1, 'this is a test');
 UPDATE t SET content = 'that was a test' WHERE rowid = 1;

 -- The following is returning 'gibberish here' for me:
 SELECT content FROM t WHERE rowid = 1;



Hi Scott,

I'm using the latest version available for download on the sqlite site,
3.3.10.
Compiling on Windows with MSVC (2003).
I tried the script you provide and I get gibberish.
To be sure I selected the data before the update and it comes back
correctly.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to