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



Josip Zohil    THE SMALL BINARY INDEX SPEED
In database application we normally retrieve data using indexes. Most valuable are small indexes, especially in LAN applications, where the indexes data travel over the wire. We present an example of table’s data distribution on which the small binary index is significantly slower than others.

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).

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%.

Ken Murphy    MAKING RUSHMORE RUSH MORE
Ken Murphy explains how to use RushMore to improve your SQL queries in Visual FoxPro.

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.

DENNIS JONES    USING AN OLEPUBLIC CLASS TO IMPLEMENT A COM INTERFACE
Dennis explains how to use QLM from Interactive Studios with VFP.

Simon Arnold    BASIC SPLASH SCREENS IN VISUAL FOXPRO
Simon shows you how to create your own splash forms for your applications.

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.

tushar Kanvinde    REPORTING ON THE FLY
Tushar from India explains how he dynamically creates Visual FoxPro reports.

Boudewijn Lutgerink    SOFTWARE ECONOMICS PART 4
Learn how to sell your software! Last part of Boudewijn's series on Software Economics.

Boudewijn Lutgerink    SOFTWARE ECONOMICS PART 3
Part 3 of Boudewijn's series about Visual FoxPro and Economics.

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.

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.

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.

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.

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.

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.

Mike Lewis    SQL SELECT IN VFP AND T-SQL
Watch out for these language differences when moving between Visual FoxPro and SQL Server.

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.

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.

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.

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.

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.

Simon Arnold    OUTLOOK AUTOMATION PART 3
Part 2: Examining the MailItem Properties.

Simon Arnold    OUTLOOK AUTOMATION PART 2
Part 2: lets take a look at the Outlook Object Model

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.

Bernard Bout    A VERY SIMPLE CA TUTORIAL
Part 3 of Bernard's articles on Cursor Adapters.

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.

Bernard Bout    CREATING & USING CA CLASSES – A SIMPLE TUTORIAL PART IIA
Part 2a of Bernard's articles on Cursor Adapters.

Bernard Bout    CREATING & USING CA CLASSES – A SIMPLE TUTORIAL PART II
Part 2 of Bernard's articles on Cursor Adapters.

Boudewijn Lutgerink    DEMYSTIFY FORMS DATA ENVIRONMENTS, DATA SESSIONS AND RECORD LOCKING STRATEGIES
In this article, Boudewijn discusses Data Environments, Sessions and Record Locking.

Mz    FTT: FILE TO TEXT
MZ shows you how to convert binary data to text and back.

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.

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.

Mz    OBFUSCATOR: ENCRYPT YOUR SOURCE CODES
Affraid for people who decompile your binaries? MZ shows you how to write unreadable source code!

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!

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.

Mz    STEGANOGRAPHY (PART 2)
Second part of MZ's series about steganography and Visual FoxPro.

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.

Foxhound    PERFORM APPLICATION’S USER PRIVILEGES USING WINDOWS AUTHENTICATION FEATURE IN MICROSOFT SQL SERVER 2000
Authenticate application users against Active Directory thru SQL Server.

Mz    STEGANOGRAPHY (PART 1)
Interesting article by MZ about steganography and Visual FoxPro.

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.

Mike Lewis    CONTROLLING TWAIN DEVICES FROM WITHIN VFP
Need to drive a scanner or video camera from inside your application? Here’s how.

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.

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!

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!

Boudewijn Lutgerink    HOOKED ON OBJECTS, PART 2
Part two of Boudewijn's ideas about OOP.

Boudewijn Lutgerink    PROTECT YOUR APPLICATIONS
Boudewijn tested a demo version of KONxISE, a tool to compress and protect your VFP EXE against decompilers.

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.

Boudewijn Lutgerink    ACCESSING YOUR VFP DATABASE IN ACCESS
Learn how to use the VFP ODBC driver to access your VFP data in Microsoft Access.

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.

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.

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.

Boudewijn Lutgerink    CONTROL THE BACKCOLOR OF THE _SCREEN
Read more about how to respond to Windows display changes.

Boudewijn Lutgerink    MAKE A DEMO VERSION OF YOUR APP
Need a demo version of your VFP application? Boudewijn shows you how to do it!

Simon Arnold    VFP7 DATABASE EVENTS
Simon talks about VFP7 Database Events.

Boudewijn Lutgerink    RESTRICT THE NUMBER OF USERS TO YOUR APP
Learn how to control and limit the number of concurrent users.

Pete Sass    THE VISUAL FOXPRO REPORT WRITER
Questions and Answers and Tips and Tricks for the Visual FoxPro Report Writer.

Pete Sass    FORMSET BASICS IN VISUAL FOXPRO
Pete Sass explains why he likes to use formsets.

Boudewijn Lutgerink    USING THE VFP7 INTELLISENSE MANAGER (PART 2 OF 2)
More about VFP7's IntelliSense features by Boudewijn Lutgerink.

Boudewijn Lutgerink    USING THE VFP7 INTELLISENSE MANAGER (PART 1 OF 2)
How to use and modify the IntelliSense feature of Visual FoxPro 7.

Boudewijn Lutgerink    A LITTLE BIT ABOUT MANIPULATING LITTLE BITS
Boudewijn explains some of VFP's BITxxx() functions.

Yuri Rubinov    HOW TO CALL EXCEL WORKSHEET FUNCTIONS FROM VFP
Learn how to use powerful MS Excel functions in your VFP application.

Vladimir Trukhin    REMOTE SHUTDOWN OF APPLICATIONS
Vladimir demonstrates a technique to remotely shut down a VFP application.

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.

Dale Dedoroy    WHO SAYS YOU CAN'T BUILD INDEXES IN A SHARED ENVIRONMENT?
Learn how to create indexes in a multi-user environment.

Vladimir Trukhin    THE EASY WAY TO FORM A PRIMARY KEY
Vladimir talks about a primary key generator.

Boudewijn Lutgerink    THE MAGIC OF THE MODEM
Dial phone numbers with Visual FoxPro and the MSCOMM32 ActiveX control.

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.

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.

Vladimir Trukhin    CREEPING LINE
This sample by Vladimir Trukhin shows you how to create a scrolling text class in Visual FoxPro.

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.

Vladimir Trukhin    MULTI-CHANNEL OUTPUT INTO TEXT FILES
Vladimir Trukhin introduces an OOPish way in writing text files.

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.

Simon Arnold    THE MICROSOFT LISTVIEW CONTROL
This sample by Simon Arnold shows you how to implement a Listview in your Visual FoxPro forms.

Dale Dedoroy    TAME THE STRING
Team member Dale Dedoroy tells us how to deal with strings and string manipulation in Visual FoxPro.

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.

Dale Dedoroy    TEACH THE FOX HUNT PICTURES BETTER
Dale Dedory shows us how to use the Kodak Image Edit control in Visual FoxPro.

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.