|
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. | ||
Written by Josip Zohil , Published @ 8/17/2008 12:17:47 PM | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
REPORTING ON THE FLY | ||
Tushar from India explains how he dynamically creates Visual FoxPro reports. | ||
Written by tushar Kanvinde , Published @ 12/23/2006 10:30:45 PM | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
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 | ||
|
BUILDING AN N-TIER VERSION OF THE TASTRADE DEMO APPLICATION USING FOXDATAOBJECTS – PART 1 | ||
FoxDataObjects (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 | ||
|
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 | ||
|
OUTLOOK AUTOMATION PART 3 | ||
Part 2: Examining the MailItem Properties. | ||
Written by Simon Arnold , Published @ 3/30/2005 6:39:00 PM | ||
|
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 | ||
|
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 | ||
|
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 | ||
|