Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
ARTICLE INDEX


Jun Tangunan    Extending Craig Boyd's VFPCompression.fll
In this article, Jun Tangunan shows you how to use and extend Craig Boyd's VFP Compression library (vfpcompression.fll).
Written by Jun Tangunan , Published @ 4/7/2008 7:50:27 PM
Josip Zohil    VFP performance in LAN environment
Visual FoxPro is one the fastest performing desktop and LAN-based database management system available today. But opening large tables creates a great deal of network traffic. This can be a substantial delay, sometimes beyond an acceptable length of time. In this article I present the results of the VFP speed measurement in the process of acquiring database data with different VFP9 methods. The store procedures, duplicated records and unique indexes enriched by the programmers' knowledge of the database organization can speed up the data query. With the stored procedure we can fetches the result set of 100 records from the server about 100% faster than with the full optimized SQL command. Changing the table's normalization and using appropriate indexes, we can improve the retrieval time for 275%.
Written by Josip Zohil , Published @ 4/3/2008 9:03:06 PM
Ken Murphy    Making RushMore Rush More
Ken Murphy explains how to use RushMore to improve your SQL queries in Visual FoxPro.
Written by Ken Murphy , Published @ 1/3/2008 8:57:19 PM
Boudewijn Lutgerink    The German 2007 DevCon from a visitor's perspective
While visiting the German DevCon this year I took the chance to listen to Steven Black's sessions about niche markets and "So fox is 'dead', now what?". This article and some more articles coming up soon, are about my perspective on these and other sessions.
Written by Boudewijn Lutgerink , Published @ 12/13/2007 11:35:27 AM
DENNIS JONES    Using an OLEPUBLIC class to implement a COM interface
Dennis explains how to use QLM from Interactive Studios with VFP.
Written by DENNIS JONES , Published @ 12/4/2007 7:21:50 PM
Simon Arnold    Basic Splash Screens in Visual FoxPro
Simon shows you how to create your own splash forms for your applications.
Written by Simon Arnold , Published @ 10/25/2007 6:55:40 PM
Ken Murphy    MOVING FROM SINGLE USER TO MULTI-USER IN VFP
Things to consider when you're moving from single user to multi user application design and development.
Written by Ken Murphy , Published @ 6/22/2007 2:52:09 PM
tushar    REPORTING ON THE FLY
Tushar from India explains how he dynamically creates Visual FoxPro reports.
Written by tushar , Published @ 12/23/2006 10:30:45 PM
Boudewijn Lutgerink    SOFTWARE ECONOMICS PART 4
Learn how to sell your software! Last part of Boudewijn's series on Software Economics.
Written by Boudewijn Lutgerink , Published @ 7/5/2006 9:04:00 AM
Boudewijn Lutgerink    SOFTWARE ECONOMICS PART 3
Part 3 of Boudewijn's series about Visual FoxPro and Economics.
Written by Boudewijn Lutgerink , Published @ 7/5/2006 8:52:00 AM
Boudewijn Lutgerink    SOFTWARE ECONOMICS PART 2
There are more than enough articles available on how to create robust and well working software. Not many articles however, describe the economics behind the decision making on software. Part 2 of 4.
Written by Boudewijn Lutgerink , Published @ 7/5/2006 8:48:00 AM
Pete Sass    HOW TO HANDLE UPDATE CONFLICTS AND REFRESH DATA IN FORMS WITHIN A NETWORK MULTI-USER APPLICATION
In this article, Pete Sass shows you his way for dealing with update conflicts in multi user applications.
Written by Pete Sass , Published @ 7/2/2006 1:33:14 PM
Chris Chamberlain    QUERY FOR DATA FROM A WMI CLASS
If you need to recover data from a WMI class, the .prg posted in this FAQ will take the code generated by Microsoft's WMI Code Creator and output it to a .txt file.
Written by Chris Chamberlain , Published @ 5/21/2006 4:56:45 PM
Pete Sass    CONDITIONAL BY-PASSING OF THE FIELD LEVEL VALID EVENT IN VISUAL FOXPRO VERSIONS 8.0 AND 9.0
Pete shows you how to by-pass the Field Level Valid Event in Visual FoxPro.
Written by Pete Sass , Published @ 5/14/2006 3:41:12 PM
Bernardo Fourcade    BUILDING AN N-TIER VERSION OF THE TASTRADE DEMO APPLICATION USING FOXDATAOBJECTS – PART 4
Last part of a series of articles about FoxDataObjects.
Written by Bernardo Fourcade , Published @ 5/14/2006 3:21:58 PM
Bernardo Fourcade    BUILDING AN N-TIER VERSION OF THE TASTRADE DEMO APPLICATION USING FOXDATAOBJECTS – PART 3
Part 3 of a series of articles about FoxDataObjects.
Written by Bernardo Fourcade , Published @ 4/16/2006 6:31:53 PM
Mike Lewis    SQL SELECT IN VFP AND T-SQL
Watch out for these language differences when moving between Visual FoxPro and SQL Server.
Written by Mike Lewis , Published @ 4/2/2006 6:41:45 PM
Mike Lewis    AN EASY WAY TO SEND EMAIL FROM A VISUAL FOXPRO APPLICATION
Use this simple technique to help your users compose and send email messages.
Written by Mike Lewis , Published @ 4/2/2006 5:45:17 PM
Mike Lewis    INTRODUCING SHELLEXECUTE()
Forget the ancient RUN command. If you need to invoke an external application from within VFP, this handy API call is all you'll need.
Written by Mike Lewis , Published @ 4/2/2006 5:39:10 PM
Bernardo Fourcade    BUILDING AN N-TIER VERSION OF THE TASTRADE DEMO APPLICATION USING FOXDATAOBJECTS – PART 2
Second part of a series of four articles about FoxDataObjects.
Written by Bernardo Fourcade , Published @ 4/2/2006 4:18:33 PM
Bernardo Fourcade    BUILDING AN N-TIER VERSION OF THE TASTRADE DEMO APPLICATION USING FOXDATAOBJECTS – PART 1
FoxDataObjects (http://www.foxdataobjects.com) is an object/relational persistence and query engine for Visual FoxPro. It lets us develop persistent classes following object-oriented idiom - including association, inheritance, composition, and collections, and allows us to express queries using a simple Object Query language, as well as in native SQL. Basically the product automates the Data-Access layer of an n-Tier application, but more important, it maps our business object model to a relational model, connects our Business layer to any supported database engine and provides a simple API for object persistence and querying. In this article, Bernardo Fourcade shows you how to re-create parts of the Tasmanian Traders (Tastrade) sample application, but in an n-Tier architecture to show some basic features of FoxDataObjects.
Written by Bernardo Fourcade , Published @ 2/16/2006 9:38:58 PM
Boudewijn Lutgerink    SOFTWARE ECONOMICS
There are more than enough articles available on how to create robust and well working software. Not many articles however, describe the economics behind the decision making on software. This article is the first in a range of articles describing some useful techniques to help you on how to decide for the most elegant way for developing software.
Written by Boudewijn Lutgerink , Published @ 2/5/2006 10:32:15 AM
Simon Arnold    OUTLOOK AUTOMATION PART 3
Part 2: Examining the MailItem Properties.
Written by Simon Arnold , Published @ 3/30/2005 6:39:00 PM
Simon Arnold    OUTLOOK AUTOMATION PART 2
Part 2: lets take a look at the Outlook Object Model
Written by Simon Arnold , Published @ 3/26/2005 5:12:00 AM
Simon Arnold    OUTLOOK AUTOMATION PART 2: HOW TO OBTAIN ALL PERSONAL FOLDERS AND SUBFOLDERS INTO A TREEVIEW
Simon uncovers the entire Outlook Object Model and show what areas cause the security dialogs, also how to create the basics. Part 1 explains how to obtain all personal folders and subfolders into a treeview.
Written by Simon Arnold , Published @ 3/24/2005 1:00:00 AM
Bernard Bout    A VERY SIMPLE CA TUTORIAL
Part 3 of Bernard's articles on Cursor Adapters.
Written by Bernard Bout , Published @ 11/28/2004 3:01:06 PM
Pavel Stasenko    PROBLEMS OF CODE RELIABILITY IN MICROSOFT VISUAL FOXPRO
Problems of code reliability are discussed in many articles. In this article we take a look at some basic problems using variables in VFP.
Written by Pavel Stasenko , Published @ 5/9/2004 4:00:22 PM
Bernard Bout    CREATING & USING CA CLASSES – A SIMPLE TUTORIAL PART IIA
Part 2a of Bernard's articles on Cursor Adapters.
Written by Bernard Bout , Published @ 2/15/2004 6:11:30 PM
Bernard Bout    CREATING & USING CA CLASSES – A SIMPLE TUTORIAL PART II
Part 2 of Bernard's articles on Cursor Adapters.
Written by Bernard Bout , Published @ 2/1/2004 6:01:19 PM
Boudewijn Lutgerink    DEMYSTIFY FORMS DATA ENVIRONMENTS, DATA SESSIONS AND RECORD LOCKING STRATEGIES
In this article, Boudewijn discusses Data Environments, Sessions and Record Locking.
Written by Boudewijn Lutgerink , Published @ 1/20/2004 1:50:56 PM
Mz    FTT: FILE TO TEXT
MZ shows you how to convert binary data to text and back.
Written by Mz , Published @ 1/13/2004 9:59:35 AM
Boudewijn Lutgerink    FROM ZERO TO HERO IN 26.84 SECONDS
Visual FoxPro is not slow... no it's as fast as lightning. Boudewijn shows how he helped another Foxite Community Member how to improve his application's performance.
Written by Boudewijn Lutgerink , Published @ 1/6/2004 8:31:08 AM
Bernard Bout    CREATING & USING CURSOR ADAPTER CLASSES – A SIMPLE TUTORIAL
In this tutorial Bernard Bout explains how to create a set of Cursor Adapters that will be used for lookups.
Written by Bernard Bout , Published @ 11/23/2003 1:53:16 PM
Mz    OBFUSCATOR: ENCRYPT YOUR SOURCE CODES
Affraid for people who decompile your binaries? MZ shows you how to write unreadable source code!
Written by Mz , Published @ 11/19/2003 8:01:23 PM
Pete Sass    GRIDWORKS: OPEN A NEW RECORD AFTER CURRENT RECORD IN GRID
Need to add a new record in a grid without it moving to the bottom of the table visually? Pete shows you how to do it!
Written by Pete Sass , Published @ 10/26/2003 2:43:08 PM
Pete Sass    UPDATE CHILD RECORDS USING VFP RI GENERATED CODE
This is a very short article on how to update additional children records within the VFP RI generated code.
Written by Pete Sass , Published @ 10/18/2003 1:11:27 PM
Mz    STEGANOGRAPHY (PART 2)
Second part of MZ's series about steganography and Visual FoxPro.
Written by Mz , Published @ 10/17/2003 2:03:46 PM
Pete Sass    BUILD A NETWORK MONITORING SYSTEM WITH VISUAL FOXPRO
Pete shows you how easy it is to build a basic network monitoring system in Visual FoxPro.
Written by Pete Sass , Published @ 10/13/2003 4:23:01 PM
Foxhound    PERFORM APPLICATION’S USER PRIVILEGES USING WINDOWS AUTHENTICATION FEATURE IN MICROSOFT SQL SERVER 2000
Authenticate application users against Active Directory thru SQL Server.
Written by Foxhound , Published @ 10/5/2003 12:35:55 PM
Mz    STEGANOGRAPHY (PART 1)
Interesting article by MZ about steganography and Visual FoxPro.
Written by Mz , Published @ 9/13/2003 3:42:57 PM
Mike Lewis    TAMING THE MICROSOFT LISTVIEW CONTROL
If you've experimented with the ActiveX controls that come with Visual FoxPro, you've probably come across the Microsoft ListView. This versatile control provides an attractive way of displaying data in a list, and offers a worthwhile alternative to VFP's native listbox and grid controls.
Written by Mike Lewis , Published @ 7/18/2003 10:08:21 AM
Mike Lewis    CONTROLLING TWAIN DEVICES FROM WITHIN VFP
Need to drive a scanner or video camera from inside your application? Here’s how.
Written by Mike Lewis , Published @ 7/18/2003 10:08:21 AM
Mike Lewis    PARSING COMMA-DELIMITED STRINGS INTO A VISUAL FOXPRO ARRAY
In Visual FoxPro (and other programming languages), comma-delimited strings are a handy way of storing small collections of data. It's common to use these strings to pass parameters to procedures or functions, or to store values in custom properties of a class. You might also import data from other applications in the form of a comma-delimited text file.
Written by Mike Lewis , Published @ 7/18/2003 10:08:21 AM
Simon Arnold    GETTING TO GRIPS WITH THE MICROSOFT DOM OBJECT
Simon explains what DOM is and how DOM relates to XML documents. Sample code included!
Written by Simon Arnold , Published @ 6/21/2003 6:59:10 PM
Boudewijn Lutgerink    SOFTWARE DEVELOPMENT COSTS AND CHOICE OF TOOLS
With the emphasis that any manufacturer puts on the fact that they invented a new technology it is easy forgotten that the first interest of managers is the fact that they want solutions to any problem they meet in their daily work as soon as possible and with the least possible costs. Technical knowledge is a totally different field of interest. It is not uncommon that, due to the "marketing seasoning" put on the message they bring to you about this hot new great fantastic tool, you, as a manager tend to believe that this great new tool speeds up development. If that is so, then by all means do read on!
Written by Boudewijn Lutgerink , Published @ 6/1/2003 12:29:06 PM
Boudewijn Lutgerink    HOOKED ON OBJECTS, PART 2
Part two of Boudewijn's ideas about OOP.
Written by Boudewijn Lutgerink , Published @ 3/23/2003 1:35:46 PM
Boudewijn Lutgerink    PROTECT YOUR APPLICATIONS
Boudewijn tested a demo version of KONxISE, a tool to compress and protect your VFP EXE against decompilers.
Written by Boudewijn Lutgerink , Published @ 3/6/2003 5:32:48 PM
Vladimir Trukhin    PRIMARY KEYS WITHOUT PROBLEMS
When somebody got regular “Unique key violation” message, perhaps he would say: “Why doesn’t database do it itself”? He’s right 1000 times. Database must find a proper key value. We should teach it if it doesn’t know how to do such operation.
Written by Vladimir Trukhin , Published @ 3/6/2003 5:32:33 PM
Boudewijn Lutgerink    ACCESSING YOUR VFP DATABASE IN ACCESS
Learn how to use the VFP ODBC driver to access your VFP data in Microsoft Access.
Written by Boudewijn Lutgerink , Published @ 2/16/2003 8:46:40 PM
Boudewijn Lutgerink    HOOKED ON OBJECTS, PART 1
This is the first part of two articles about creating classes and using Objects in your code. This part also discusses the Project Hook class.
Written by Boudewijn Lutgerink , Published @ 1/19/2003 5:07:59 PM
Vladimir Trukhin    MANAGER OF THE OBJECTS LINKED BY COMMON DATA
The objects know all about themselves, but they know little about their neighbors in an application. However, as Vladimir Trukhin shows us here, each of them can affect other objects. The application needs something to notify the objects about a change of environment—the Manager of the Objects.
Written by Vladimir Trukhin , Published @ 1/4/2003 12:00:00 AM
Vladimir Trukhin    FRIENDLY GRID AND LEARNED SEARCH
It's a fairly easy to organize data searching in the columns of the Grid object that's placed in the form. It's easy to do it in the second and the third form as well, but from here, this process tires a developer with its monotony. It's an appropriate time to create some classes that will be able to deal with both the Grid objects and their columns, and Vladimir Trukhin shows you how.
Written by Vladimir Trukhin , Published @ 1/4/2003 12:00:00 AM
Boudewijn Lutgerink    CONTROL THE BACKCOLOR OF THE _SCREEN
Read more about how to respond to Windows display changes.
Written by Boudewijn Lutgerink , Published @ 12/26/2002 9:29:48 AM
Boudewijn Lutgerink    MAKE A DEMO VERSION OF YOUR APP
Need a demo version of your VFP application? Boudewijn shows you how to do it!
Written by Boudewijn Lutgerink , Published @ 9/26/2002 4:34:04 PM
Simon Arnold    VFP7 DATABASE EVENTS
Simon talks about VFP7 Database Events.
Written by Simon Arnold , Published @ 9/8/2002 12:27:18 AM
Boudewijn Lutgerink    RESTRICT THE NUMBER OF USERS TO YOUR APP
Learn how to control and limit the number of concurrent users.
Written by Boudewijn Lutgerink , Published @ 9/4/2002 10:47:14 PM
Pete Sass    THE VISUAL FOXPRO REPORT WRITER
Questions and Answers and Tips and Tricks for the Visual FoxPro Report Writer.
Written by Pete Sass , Published @ 9/4/2002 10:46:12 PM
Pete Sass    FORMSET BASICS IN VISUAL FOXPRO
Pete Sass explains why he likes to use formsets.
Written by Pete Sass , Published @ 1/30/2002 9:02:03 PM
Boudewijn Lutgerink    USING THE VFP7 INTELLISENSE MANAGER (PART 2 OF 2)
More about VFP7's IntelliSense features by Boudewijn Lutgerink.
Written by Boudewijn Lutgerink , Published @ 10/14/2001 3:28:54 PM
Boudewijn Lutgerink    USING THE VFP7 INTELLISENSE MANAGER (PART 1 OF 2)
How to use and modify the IntelliSense feature of Visual FoxPro 7.
Written by Boudewijn Lutgerink , Published @ 10/9/2001 4:36:20 PM
Boudewijn Lutgerink    A LITTLE BIT ABOUT MANIPULATING LITTLE BITS
Boudewijn explains some of VFP's BITxxx() functions.
Written by Boudewijn Lutgerink , Published @ 10/9/2001 4:36:18 PM
Yuri Rubinov    HOW TO CALL EXCEL WORKSHEET FUNCTIONS FROM VFP
Learn how to use powerful MS Excel functions in your VFP application.
Written by Yuri Rubinov , Published @ 10/9/2001 4:36:09 PM
Vladimir Trukhin    REMOTE SHUTDOWN OF APPLICATIONS
Vladimir demonstrates a technique to remotely shut down a VFP application.
Written by Vladimir Trukhin , Published @ 9/20/2001 2:32:42 PM
Dale Dedoroy    AN ALTERNATIVE TO KODAK IMAGE EDIT SCROLLBARS
Here's a workaround for the display problem with the scrollbars of the Kodak Imaging Control.
Written by Dale Dedoroy , Published @ 9/9/2001 12:10:52 AM
Dale Dedoroy    WHO SAYS YOU CAN'T BUILD INDEXES IN A SHARED ENVIRONMENT?
Learn how to create indexes in a multi-user environment.
Written by Dale Dedoroy , Published @ 8/13/2001 10:13:02 PM
Vladimir Trukhin    THE EASY WAY TO FORM A PRIMARY KEY
Vladimir talks about a primary key generator.
Written by Vladimir Trukhin , Published @ 8/13/2001 10:12:50 PM
Boudewijn Lutgerink    THE MAGIC OF THE MODEM
Dial phone numbers with Visual FoxPro and the MSCOMM32 ActiveX control.
Written by Boudewijn Lutgerink , Published @ 7/11/2001 10:09:16 PM
Dale Dedoroy    THUMBNAILS, ANYONE? (PART 2 OF 2)
Part 2 of a series of two articles by Dale Dedoroy on how to create thumbnails in Visual FoxPro.
Written by Dale Dedoroy , Published @ 7/9/2001 11:03:36 PM
Dale Dedoroy    THUMBNAILS, ANYONE? (PART 1 OF 2)
Part 1 of a series of two articles by Dale Dedoroy on how to create thumbnails in Visual FoxPro.
Written by Dale Dedoroy , Published @ 6/13/2001 10:01:45 PM
Vladimir Trukhin    CREEPING LINE
This sample by Vladimir Trukhin shows you how to create a scrolling text class in Visual FoxPro.
Written by Vladimir Trukhin , Published @ 5/28/2001 8:16:12 PM
Vladimir Trukhin    CREATE A REPORT IN THE MICROSOFT WORD FORMAT
In this article, Vladimir Trukhin explains how to create report templates in Word and merge them with data from Visual FoxPro.
Written by Vladimir Trukhin , Published @ 5/28/2001 8:16:12 PM
Vladimir Trukhin    MULTI-CHANNEL OUTPUT INTO TEXT FILES
Vladimir Trukhin introduces an OOPish way in writing text files.
Written by Vladimir Trukhin , Published @ 5/28/2001 8:16:12 PM
Simon Arnold    EXCEL CLASS VERSION 1.0.1
In this article, Simon Arnold explains how to use his great Office Class automation library for Office applications.
Written by Simon Arnold , Published @ 5/25/2001 5:00:35 PM
Simon Arnold    THE MICROSOFT LISTVIEW CONTROL
This sample by Simon Arnold shows you how to implement a Listview in your Visual FoxPro forms.
Written by Simon Arnold , Published @ 5/3/2001 1:30:27 PM
Dale Dedoroy    TAME THE STRING
Team member Dale Dedoroy tells us how to deal with strings and string manipulation in Visual FoxPro.
Written by Dale Dedoroy , Published @ 4/20/2001 7:36:53 PM
Simon Arnold    VFP AND ADO (PART 2 OF 2)
Second and last part of a series of articles/samples in which Foxite.COM Team Member Simon Arnold explains how to use ADO in Visual FoxPro.
Written by Simon Arnold , Published @ 4/11/2001 10:34:33 PM
Dale Dedoroy    TEACH THE FOX HUNT PICTURES BETTER
Dale Dedory shows us how to use the Kodak Image Edit control in Visual FoxPro.
Written by Dale Dedoroy , Published @ 4/11/2001 10:34:19 PM
Simon Arnold    VFP AND ADO (PART 1 OF 2)
First part of a series of two articles/samples in which Foxite.COM Team Member Simon Arnold explains how to use ADO in Visual FoxPro.
Written by Simon Arnold , Published @ 4/10/2001 8:40:47 PM