I have and it works great. I'm using it to import a table much wider than 250 columns and then querying that table for specific results and using them to create an upload file for a third party service. I recommend the following book as your starting point:
https://www.hentzenwerke.com/catalog/sqlite2gb.htm
Paul H. Tarver
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 9:19 AM To: profoxtech@leafe.com Subject: SQLite
Has anyone used SQLite with VFP? I have always used DBFs as it seemed over-kill to use SQL Server for the small membership databases I've been using (2000 records) however I was introduced to SQLite as part of a Python course so thought I'd give it a try with VFP.
John
John Weller
01380 723235
07976 393631
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]