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
Figured out that it needs to be a SQLite DB otherwise it gives a 0 (zero) response back.
Bill