SQLite question

[billhsln]

Does sqlite3_column_count need to have a DB and does the DB need to be open or does it just parse the query sent to it?

I am wondering if I can pass a SELECT to it and it will return how many fields are between the SELECT and FROM or if it only does it for a SQLite DB that is open.  I would like to be able to just use it to get the count of fields no matter what DB is being used.

I am trying to come up with a general DB program that will go against multiple DB types and show the select in a listview.

Thanks,
Bill

[billhsln]

Figured out that it needs to be a SQLite DB otherwise it gives a 0 (zero) response back.

Bill