The LA Fox Developer Newsletter

September 1997

ActiveX (Con’t from page 6)

PC Magazine; April22, 1997; Vol. 16, No. 8; pp. 201- 205

rEd. Note: Michael W. Thomas is a commercial application developer for Resource Data International, Inc. in Boulder, CO. CIS: 103650,2175; email: mthomas@resdata.com.]

VFP Tips, Tricks, and Bugs

Eliminating Deleted Records

from Views

by Doug Sherman, Rocky Mountain Fox User Group

I’m developing a VFP5O application that is using PrivateDataSession DBC views of underlying tables, instead of the tables directly, in order to more easily up-size the application utilizing to a SQL back end server. When running the forms in testing, I began encountering deleted records present in the view of the table. However, the records were not flagged as deleted!! Placing SET DELETED ON into the INIT or the LOAD event did not solve the situation because these events occur after the views are created in the data environment.

THE SOLUTION

Make use of the BeforeOpenlables procedure of the Data Environment! This code section is accessed by right clicking on the form and selecting “Data Environment”. The form data environment opens. Right click in the environment area. The dialog opens with selections for “Add, Properties, Form Designer, and Code”. Select “Code”, then select the procedure “BeforeOpenTabbles” of the Dataenvironemt object.

Place the code “SET DELETED ON” into this procedure.

(Doug Sherman is president of the Rocky Mountain Fox User Group in Denver. He has been developing in xBased languages for 8 years and with other ‘big box’ main frame languages many decades. Doug specializes in database apps that also integrate with communications and Office elements. He can be reached at 73112.11 1@CompuServe.com]

Future Programming (Con't form page 8)

language has its strong points and will have to be used for that purpose. The “one is totally better then the other” or “Mine can do it all and do it better” mindset needs to be discarded as soon as possible and an “this is better for that purpose” attitude will need to be adopted. In my opinion this is the future of programming — an integrated programming environment.

Tricks, Tips, Techniques (Con? from page 8)

whole lot easier? Not only can you drag and drop classes between libraries, the Class Browser will automatically update all references for you.

Here’s how. Open two instances of the Class Browser and drag and drop the class icon from one instance to a different class library in the other instance. All .vcx and .scx files in all class browser windows automatically get updated if a subclass or instance exists for the class. In Visual FoxPro 5.0, you can now open a project file (*.pjx) in the Class Browser, which loads all .vcx and .scx files in the project. This means one drag and drop operation can automatically update your entire project!

The default behavior when you drag and drop a class icon is to move the class. If you want to copy the class, hold the CtrI key down while dragging and dropping. Note that copying does not update class references.

Here’s one more tip to save you mouse clicks! In the Visual FoxPro 5.0 Command window you can type MODIFY CLASS myclass OF myclasslib METHOD foo. This will open the Class Designer and take you right to the method snippet. No mouse clicking necessary!

(Ed. Note: VFUG is an online Visual FoxPro Developer Newsletter. For in formation on how to become a member and receive their newsletter, e-mail Scot Becker, Director of Marketing and Public Relations, Virtual FoxPro User Group (VFUG), scot@vfug.org. Or visit their website at http://www.vfug.org.

It Can’t Get Any Easier.......

We’ve come up with an easy way to submit articles to the LA Fox Developer Newsletter one that has been overlooked for a long time.

You can submit your articles to Barry Lee at CIS# 72723,3422 on Compuserve, orbrlee@earthlink.net.

These articles can be on any FoxPro-related topic, whether it concerns a new technique you’ve discovered, a certain development technique you may favor over others, book reviews, etc. Editor reserves the right to edit or offer constructive comments concerning submitted articles and accepted articles shall be considered to be in the public domain.

The quality of this newsletter really depends on the members that support it, not just read it. And I think we’d all be surprised by the useful information that could be circulated around the membership.

Page 9