December 01, 2024, 11:28:07 AM

News:

Own IWBasic 2.x ? -----> Get your free upgrade to 3.x now.........


SQLite question

Started by billhsln, July 04, 2023, 10:51:14 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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
When all else fails, get a bigger hammer.

billhsln

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

Bill
When all else fails, get a bigger hammer.