Yes, agreed using stored procedures is a good way, however I believe you
still need SPT or CursorAdapters to access those stored procedures, so
they are not necessarily mutually exclusive.
Frank.
Frank Cazabon
On 20/08/2019 09:42 AM, Stephen Russell wrote:
Considering they are flipping over SQL Server I would learn to USE SQL
SERVER correctly on the front end from VFP. You create the sprocs that do
all of your CRUD operations. Populate them from the fox world and as VFP
is replaced, the newer interfaces will use the same sprocs you laid down
today whenever they are activated.
On Tue, Aug 20, 2019 at 7:24 AM Frank Cazabon <frank.caza...@gmail.com>
wrote:
I use Visual MaxFrame Professional so the details are hidden from me and
I don't really care what technology is used behind the scenes. < smile >
I actually think that Drew coded it so that it works through remote
views in the background.
If I were to start doing my own code/framework now in VFP I would
probably use CursorAdapters but I have never actually used them for more
than playing with to learn about them. I believe they give you enough
flexibility while hiding some of the technical details. If you want
absolute control, then go with SPT.
Frank.
Frank Cazabon
On 20/08/2019 05:39 AM, Peter Cushing wrote:
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,
[excessive quoting removed by server]
_______________________________________________
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/cf6bd2c1-06c7-35e6-354e-472f0d257...@gmail.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.
