The LA Fox Developer Newsletter

March 1998

and Tahoe is no exception. This session covers the latest additions to the programming language, including new objects, properties, events and methods, new functions, and more. Find out how your life as a programmer just got easier. This session assumes familiarity with Visual FoxPro basics.

Using SQL-SELECT Effectively

Visual FoxPro 5 added ANSI-compliant JOINs, including outer joins, to SQL SELECT. But the syntax for using them isn’t intuitive and it’s possible to write a query that runs, but returns the wrong results. The structure of a query and the underlying data also affect performance. This session explains the new join syntax and shows how to write queries that return the right results. It also explores query performance and optimization techniques, including the ability to find out how VFP is applying Rushmore.

Y.AlanGriver

Intro to Design Patterns

Design Patterns are used to enable developers to discuss frameworks and object communication in a more structured manner. This session will discuss the whys and hows of patterns, will cover a number of patterns and will show their use inVFP.

Advanced Design Patterns

This session will continue the discussion of patterns, and will
based applications.

New Tools for Managing Projects and Class Libraries

This session will focus on tools for managing projects and class libraries and will provide practical examples of using them to boost your productivity

Whil Hentzen

Using Visual lnterDev and Visual FoxPro

So you need to deploy your first Web application with Visual

FoxPro data being served up to a variety of users in read-only query as well as simple interactive, data-entry mode. How do you start and how do you get there? We’ll begin by spending a few minutes discussing the tools you’ll need to get up and running, including both the server side and browser side run- time software. Once comfortable with the infrastructure required, we’ll spend the majority of the session showing how you can quickly develop data-centric, Web-based applications. You’ll know how to put together a data set, and how to dig subsets of data out of that data. VFP is the natural tool. How do you deliver the results to the user? Using another tool in the Visual Studio suite: Visual InterDev. We’ll show how you can use VFP and Visual lnterDev to work together to deliver complete applications, and demonstrate an active Web site that was assembled using these tools.

Creating Applications with Internet Information Server and Visual FoxPro

So you’ve got a simple database application running on the Web allowing the user to run some queries and perhaps add or update data on the server. But you’re hungry, wanting more. How do you take your application through to the next steps? You may want to provide a rich, interactive experience through server-side scripting (Active Server Pages.) You may want to provide intelligent business objects that can be accessed on the server (Visual FoxPro components.) You may want to provide a flexible data architecture, transforming a simple text browser into a rich interface with ActiveX Data Objects (ADO.) In this session, you will learn how to build advanced data-centric, Web- based applications with ASP, VFP COM components, and ADO, and how these all build on the Internet Information Server foundation. Attendance at Using Visual lnterDev and VFP (or equivalent experience) is highly recommended.

Ed Leafe

Object Messaging Strategies

This session will be a general 00 session, using VFP objects and code for the examples; however, the concepts will apply whether it is a grid on a form or an Excel spreadsheet created using COM. The focus would be on designing an effective interface for your objects so that they can be re-used by other objects.

Managing Complex Applications Using Collections

This session explains what a collection is, and how it can be used for designing abstract classes which can manage dynamic objects atruntime. I have a few examples from large projects

sis here is more on the design of abstract classes which don’t

have to modified all that much when it comes to implementing concrete subclasses.

John Miller

Upsizing VFP Data to SQL Server

This session will cover moving VFP databases to SQL Server with the help of the VFP Upsizing Wizard. The session will focus on the techniques necessary to create a SQL Server database that is the equivalent to the VFP Database. Topics to be covered include: Preparing the VFP Database; Preparing SQL Server; Handling Stored Procedures; What to Upsize; Using the Wizard; The output from the Wizard; Finishing the SQL Server Database. During the session a sample VFP database will be upsized to SQL Server.

John V. Petersen

Integrating Tahoe with Visual Studio

One of the most valuable new features in Tahoe is the ability for Tahoe COM Components to support Apartment Model Threading and Microsoft Transaction Server making it an ideal middle tier. Many Visual FoxPro Developers are now faced with the decision Hennici "How do I use the other tools in Visual Studio?” This session will focus on how and why other tools in Visual Studio can/should be used in conjunction with Visual FoxPro to create more flexible and extensible applications. In addition, this session will include a discussion of how MDAC (Microsoft Data Access Components) can be used in conjunction with your

(Con’t, page 4)

Doua Henning

Page 3