Updating sql views from foxpro cursoradapter

The first requirement, and it is of absolute importance, is a familiarity with the back-end engine and data.You’re dreaming if you think you can successfully create a Client/Server system without adequate knowledge of the back end.Producing sample data for this session was a bit of a challenge, especially since there is a strong chance many of you might not actually have SQL Server available on your machines.And even if you did, SQL Server data isn’t as simple to move from machine to machine by floppy as VFP data.In the real world this seldom works, as once you have duplicate data, besides the wasted disk space, you run a real risk of data integrity being damaged.Will the users always remember to make changes to both systems? The solution here might be to create the new VFP system using Views of the 2.x tables, which would allow for one set of data to be used in the system instead of two.So the old system will no longer be able to use the data.You could of course duplicate the data, with one set of data being used by the old 2.x system and the new set being used by Visual Fox Pro.


This session focuses on Remote Views, but we will incorporate some SQL Pass-Through code.

An added advantage is that if your application is constructed to use Views of the data, scalability becomes far simpler.



  1. Pingback:

  2. eric   •  

    She estimates that men comprise 60% of the clients who come to her center seeking help for sexual online compulsivity issues.

  3. eric   •  

    This is becoming the part of modern communications.

  4. eric   •  

    cctrl=public,max-age=518400&quality=90&imagesource=IMLFOH&mark=1&watermark=0&width=422&height=315&filename=0599/1044599/1044599O1536362020.jpg" data-r-id="10" data-mn-id="" data-price-id="3" data-price="1.98" data-is-online="true" data-bio-page="/live-sex-chat/cam-girls/Shanaya_Indian" data-freechaturl="" data-is-auto-play="false" data-is-room-full="False" data-no-wr="0" data-has-coupon="1" //i0.wlmediahub.com/imagesrv/imp_getimage?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>