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]
-----------------------------------------------------------------------------