I think you'll find SQLite interesting, fast and efficient. There are some caveats particularly when it comes to multi-user functionality, but the book (edited by none other than Ted Roche!) covers all of that material in an easy to understand way. I think I only had to ask Ted for help once! :)
Have fun!
Paul H. Tarver
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 10:06 AM To: profoxtech@leafe.com Subject: RE: SQLite
Thanks Paul. I'll investigate. I'm only playing as I've retired but it's something to do in lockdown 😊
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Paul H. Tarver Sent: 23 June 2020 15:57 To: profoxtech@leafe.com Subject: RE: SQLite
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]