Help  |   Contact Us  |   About Us  |   News and Events
Books, conferences, and other information about... Moving to Linux Switching to OOo Building Linux Apps Using Visual FoxPro
Buy      Download      Your Account      Catalog      Support      Conferences      Resources      Fun

Hard To Kill: What's New in Visual FoxPro "10"
Table of Contents


About the Team 11
Whil Hentzen 11
Ted Roche 12
Downloads 'N Other Stuff 13
Source Code 13
Screen Shots 13
Revisions 13
History 13
New version 13

1: Huh? There Ain't No VFP 10!

"What'chu talkin' 'bout, Willis? There ain't no VFP 10!" 15
Two Common Scenarios 16
Infrastructure Assumptions 16
Things You Need To Know When Reading This Book 17

2: Should You Even Be Using VFP Anymore? 19

What's Your Situation? 20
Begin 20
Maintain 20
Maintain Redux (Inherit) 20
Extend 20
Upgrade 21
Our Rubric 21
Myths? Myths? They're Myths, I Tell You! 22
Myth #1: The emotional argument 22
Oh really? 23
Myth #2: The VFP is not 'cool' anymore argument 23
Oh really? 23
Myth #3: The technical weakness argument 24
Oh really? 24
Myth #4: The termination of Microsoft support argument 24
Oh really? 24
Myth #5: The An update to Windows might break Visual FoxPro argument 25
Oh really? 25
Myth #6: The VFP might be unable to meet a business requirement in a specific industry argument 25
Oh really? 26
Myth #7: The "VFP developers are hard to find" argument 26
Oh really? 26
Myth #8: The VFP may not work on future versions of Windows argument 27
Oh really? 27
What the Current Environment Looks Like 27
The State of FoxPro 1/2.x Apps 28
The State of Visual FoxPro Apps 29
Let's Not Overlook VFP's Technical Strengths 29
Robust programming language 29
Full-featured IDE 29
Programming tools 30
Object-oriented programming facilities 30
Extensibility 30
Executable and COM component creation within IDE 30
Native data engine 30
Data massage capability 30
Rushmore technology 31
ActiveX extensions and Web services 31
Processing speed 31
Stability and reliability 31
Backward compatibility 32
Nor VFP's Business Advantages 32
Long life span 32
Inexpensive to deploy 32
RAD 32
Community support 33
The Near Future 33
Should You Still Be Using VFP Anymore? 33
Criteria 33
Case Study of Success 34
Summary 35

3. Setting Up and Updating VFP 37

Installing and Updating VFP 37
Where to Get VFP 37
MSDN 37
Other Options 39
Backing Up 39
Preparation for Installation 39
Installing VFP for the First Time 41
Installing the Core Product 41
Service Packs 42
Install the Latest Hotfix 44
Install the Updated VFP 9 Help File 46
VFP ODBC Driver (optional) 48
Finding the ODBC Driver 49
Installing the ODBC Driver 49
Using the ODBC Administrator 52
Finding the ODBC Administrator Windows 7 52
Finding the ODBC Administrator Windows 10 53
Setting up a System DSN 55
Configuring VFP 9 58
The Tools|Options Settings 58
View tab: 59
General tab: 59
Data tab: 59
File Locations tab: 59
Forms tab: 59
Debug tab: 59
Editor tab: 59
IDE tab: 60
Reports tab: 60

4. Configuring VFP 61

The Need for Simplifying your Configuration Setup 61
Your Own Customization Process 62
Capturing Your Environment from the Options Dialog 62
Starting VFP 65
Configuring In More Detail 66
Community Add-Ons 67
The VFP Timeline and Roadmap 68
FFC 68
XSource 69
Sedna 69
Obtaining Sedna 70
Installing Sedna 70
Using Sedna 70
VFPx 70
Obtaining VFPx tools 70
Installing and Using VFPx tools 70
Popular Third Party Tools 71
Thor 71
GoFish 71
Beyond Compare 71
VFP2Text 71
InnoSetup 72
FoxyPreviewer 72
West Wind Web Connection/Internet Protocols 72
SDT 72
XFRX 72
Additional Current Third Party Tools 72
Balsamiq Mockups 73
BLAT 73
Bin2PRG 73
Camtasia 73
ChilKat 73
CM Repair 73
EditPlus 74
Filezilla 74
FoxyClasses 74
FRX2Any 74
GDIPlusX 74
HackCX Pro 75
HTML Help Builder 75
Jenkins 75
Markdown Monster 75
NotePad++ 75
PEM Editor 75
Putty 76
Refox 76
SlickRun 76
SnagIt/Jing 76
TwoFox 76
ViewEditor 3.6 76
vfp2c32 77
WeTransfer 77
WinMerge 77
xCase 77

5. Running VFP on Windows 7, 8 and 10 79

Are You Sure? 79
Which Processor, Which Windows? 80
VFP (32-bit) on Windows (32-bit or 64-bit) 83

6. The VFP Ecosystem 85

Microsoft 85
Books 85
Hentzenwerke Publishing Books 85
Effective Techniques for Application Development with Visual FoxPro 6.0 85
Hacker's Guide to Visual FoxPro 6.0 86
Advanced Object Oriented Programming with Visual FoxPro 6.0 86
Internet Applications with Visual FoxPro 6.0 87
The Fundamentals: Building VS Applications on a Visual FoxPro 6.0 Foundation 87
Microsoft Office Automation with Visual FoxPro 88
1001 Things You Wanted to Know About Visual FoxPro 88
Client-Server Applications with Visual FoxPro and SQL Server 7 89
Creating Visual FoxPro Applications with Visual FoxExpress 89
Visual FoxPro Certification Exams Study Guide 90
Essential SourceSafe 90
What's New in Visual FoxPro 7 91
Debugging Visual FoxPro Applications 91
Hacker's Guide to Visual FoxPro 7.0 92
The Visual FoxPro Report Writer: Pushing it to the Limit and Beyond 93
WebRAD: Building Database Applications on the Web with Visual FoxPro and Web Connection 93
Microsoft .NET with Visual FoxPro Developers 94
MegaFox: 1002 Things You Wanted To Know About Extending Visual FoxPro 94
What's New in Visual FoxPro 8.0 95
Painless Legacy FoxPro Applications 96
Build Your Own Framework with Visual FoxPro 96
Deploying Visual FoxPro Solutions 97
What's New in Nine: Visual FoxPro's Latest Hits 97
Taming Visual FoxPro's SQL 98
Visual FoxPro Best Practices for the Next Ten Years 99
MySql Client-Server Applications with Visual FoxPro 100
The Business Case for VFP in 2013 100
So You've Inherited a Visual FoxPro Application 101
Dealing with Reserved Words Used as Data Names in a VFP Application 102
Using SQLite to Bypass the 2 GB .DBF Filesize Limit 102
Hard to Kill: What's New in Visual FoxPro 10 103
dFPUG Books 103
Flying Fox: Applying Visual FoxPro Reporting to Any Data, in Any Environment 103
Effective Techniques for Application Development w Visual FoxPro, v2 104
Making Sense of Sedna and SP2 105
VFPX: Open Source Treasure for the VFP Developer 106
Newsletters 106
FoxRockX 107
Conferences 107
Southwest Fox 107
Microsoft Visual FoxPro Konferenz in Frankfurt 107
User Groups 108

7. Online Support 111

Forums and Lists 111
Universal Thread 111
Foxite 112
ProFox 112
West Wind Bulletin Board 112
Fox Wiki 112
Microsoft Developer Network Forums 112
Stack Overflow 113
Experts Exchange 113
Tek Tips 113
Websites 113
Craig Bailey's Site 113
Demo Data Sets 113
Doug Hennig's Site 113
Garfield Hudson's VFP Videos and Training 114
LA Fox Presentation Archive 114
Neil's Page 114
Rick Borup's Site 114
Rick Schummer's Site 114
Sergey Berezniker's Site 114
Spacefold's Site 114
Steven Black's Site 114
Tamar Granor's Site 115
VFPx 115
Whil Hentzen's Site 115
Win32 Functions in VFP 115

8. Business Continuity And Estate Planning 117

Danger, Will Robinson! 117
Disaster 117
Disability 118
Death 118
The Recovery Checklist 119
A VFP-Specific Checklist 119
Your Development Environment 119
Your Applications 120
Connecting to Your Customers 120
Their Production Environment 121
The Application Functionality 121
Where Does This Go? 122
What To Do With Your Checklist 123
Disaster 123
Disability and Death 123
Find Someone 123
Designating a Backup 124
How To Turn Over A Case Study 125

Appendix A: Recovery Checklist 127

Development Environment 127
Visual FoxPro 9 127
Third Party Tools 127
Applications 128
Connecting to Your Customers 128
Network Logins 128
Websites 128
Production Environment 129
Data Dictionary 129
Tables 129
Fields 129
Application 129
Menu Calls 129
Terminology Dictionary 130

Appendix B: Source Code for this Book