Tom and Slavin:
The dump of information sounds like a good idea. To Slavin's question, the user
need to be able to repeated search, but as a developer, I would want and idea I
can eventually implement repeatedly. I've done this successfully in the past,
but it required 4-5 methods handling a combination of SQL statements and
looping arrays.
Thanks for your help guys!
Scott ValleryEcclesiastes 4:9-10
On Thursday, February 13, 2020, 09:35:54 AM EST, Simon Slavin
<[email protected]> wrote:
On 13 Feb 2020, at 2:01pm, Scott <[email protected]> wrote:
> Can I search all tables and columns of SQLite database for a specific text
> string?
No. There's no way to do this, and there's no way to say "all tables" in SQL.
In other words it's not easy to write such a thing.
I like Thomas Kurz's solution, to dump the database as SQL commands.
Alternatively you could write a text exporter for all the columns you think
might hold the string, then search that text.
If you want better solutions, it might help to tell us whether this is a
one-time problem, something you (the developer) might want to do repeatedly, or
something you want the user to be able to do repeatedly.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
