Re: [sqlite] looking up records with terms in a table

Try this: SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE CONCAT('%',T2.Terms,'%') Paul -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Richardson Sent: Tuesday, March 26, 2013 10:27 AM To: General Discussion of

[sqlite] SQLite2010 Pro ODBC Driver

Good Morning, I am trying the SQLite2010 Pro ODBC Driver in a connection string in PowerBuilder 12.5. In the database painter and in a compiled app some selects from tables are returning more than what is in the table. The county table has 4280 records. Selecting specific columns or the whole

Re: [sqlite] populating a table as quickly as possible

This is a fast way to load data. sqlite3.exe C:\\Your Dir\\dbname.db