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:[email protected]] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 10:06 AM To: [email protected] 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 <[email protected]> On Behalf Of Paul H. Tarver Sent: 23 June 2020 15:57 To: [email protected] 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:[email protected]] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 9:19 AM To: [email protected] 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
