[sqlite] Problem with MATCH query

Hi I am using FTS3 for table Positions_Text. However I am getting an error 'unable to use function MATCH in the requested context' when using: SELECT DISTINCT [Positions].[PosID] FROM [Categories], [Positions] JOIN [Positions_Text] ON [Positions].[PosID] = [Positions_Text].[rowid] WHERE

Re: [sqlite] no mention of SQLite :(

On Sat, 5 Jan 2008, [EMAIL PROTECTED] wrote: "Shane Harrelson" <[EMAIL PROTECTED]> wrote: Embedded Database Vendors Face Challenges: http://www.eweek.com/article2/0,1895,2243406,00.asp How could an article like this not mention SQLite? I don't know, but my guess is that the article was

Re: [sqlite] sqlite3_get_table(); How to get all column names in C?

Jerry Krinock wrote: Is there any way to get a list of all column names in a table via the C API, which works even when there are no data rows in the table? Jerry, You can get the column names for any query, including a "select * from table", using the prepared statement APIs. After you