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/CAJidMY+giDumzW+5miE9WbRJpybmL3non9+167Zykn=och7...@mail.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.
