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 applica-

tions, 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