I'm with you mostly it would seem, Paul. I wrote my own SPT framework
years ago after watching Bob Lee demonstrate his VFP app in Wisconsin
accessing a MySQL database over the internet in New York back at
WhilFest in 2002 or 2003. CursorAdapters sounded great and I'm told
they work great today, but initially, I steered clear of them after
initial issues in VFP8 after reading Ed Leafe's and others testing
results. I know others who use CAs and they work great for them, making
it super easy to change backends (VFP, SQL Server, Firebird, etc.)
without much code change at all apparently.
On 8/20/2019 10:11 AM, Paul H. Tarver wrote:
Peter,
Personally, I like SPT because I can build valid and safe pass-through commands
in my code based on user selections, generate the string, hand it off to the
server with an ASYNCH connection and easily provide users with progress
feedback while data is returned.
For some reason, I've never been able to wrap my head around cursor adapters
completely. Maybe it’s a control issue! :) I think SPT just made more sense to
me upfront. Thankfully, Foxpro gives you plenty of different ways to accomplish
the same things and you can pick the one that works the way you do! I use it to
query data for reporting purposes and it gives me a lot of control over how I
construct the query string since I can use all of the string functions within
Foxpro to build exactly the query I want based upon users' selections.
Another advantage is I able to dump the query string to my audit files just
before the SQLEXEC() command fires, so if something goes wrong, I can just copy
the query to my SQL management tool and see if I can manually figure out what
is going on.
So far, I've used SPT successfully to backend Foxpro with SQL, MySQL, Oracle,
Access, PostgreSQL, SQLite, etc. I just tweak queries to customize for the
database and the rest of my code remains the same.
It works for me, but I'm sure, someone else here will provide you with the
benefits of cursor adapters.
Paul H. Tarver
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter
Cushing
Sent: Tuesday, August 20, 2019 4:40 AM
To: profoxt...@leafe.com
Subject: SQL server connection
Hi,
After running my app (VFP 9) on our local network (with a DBC) for many
years, we are upgrading it (in stages) to a visual studio app with SQL
server back end.
I have read many people here talking about using SQL as a back end. At
the beginning I will just be accessing the SQL data for reporting
purposes but may need to write to it at some point. Looking through the
archives some people mentioned SPT and others cursor adapters. Just
wondering what people recommend to connect, so I can avoid the usual
gotchas.
Thanks,
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/0dae4f3d-c30d-cece-0815-1ebb3146c...@mbsoftwaresolutions.com
** 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.
