Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
FREQUENTLY ASKED QUESTIONS, TIPS & TRICKS AND HOWTO'S

Below is a list of Frequently Asked Questions (FAQs), Tips & Tricks and HowTo's posted by Foxite.COM Community Members. If you like to contribute, please login first. If you do not have an account yet, please Sign Up Now.

ATTENTION: do NOT post questions to this FAQ-section. Please post your questions to the Forum! Any question that is posted to the FAQ-section will be deleted by one of our Moderators!

 Visual FoxPro Forum Login
Login User Name:  
Password:  
 
 No Account? Lost Password?

Chris Chamberlain    How to add a progress bar to a .zip operation
Simple .prg that enables a developer to populate a progress bar utilising the ZipCallBack() function in vfpcompression.fll
Written by Chris Chamberlain, Published @ 11/10/2008 3:30:44 PM
Pete Sass    Intelligent Update of Only Modified Fields with SQL Server Databases
Idea is to update to the underlying SQL Server table only the fields that have been modified in a local cursor. Assumes using SQL pass through and each table has a unique id.
Written by Pete Sass, Published @ 4/24/2008 8:09:07 PM
Boudewijn Lutgerink    _screen.activeform ... HOLD ON!
there is a shorter way to get access to the activeform on the screen. Here's how...
Written by Boudewijn Lutgerink, Published @ 4/16/2008 11:57:42 AM
Ken Murphy    Using Private Data Sessions in Forms
It seems that every couple of weeks we see a thread where a developer is seeing unexpected results when using a private data session. Deleted records are showing up unexpectedly, settings like YEAR no longer work, etc. It seems that a good basic overview is needed.
Written by Ken Murphy, Published @ 3/27/2008 3:23:16 AM
Chris Chamberlain    How can I cancel out of a Zip operation?
Utilising the callback feature in Craig Boyd's compression library to enable cancelling
Written by Chris Chamberlain, Published @ 2/27/2008 11:05:46 AM
Boudewijn Lutgerink    add sms service to your applications
In this tip I show you how you can add SMS service to your application with the use of Skype.
Written by Boudewijn Lutgerink, Published @ 1/3/2008 8:57:36 AM
Boudewijn Lutgerink    #define your tables
#define can be used for many purposes, I show one here I use in simplifying my code
Written by Boudewijn Lutgerink, Published @ 12/19/2007 9:26:33 AM
Marcia Akins    The Difference Between NODEFAULT and DODEFAULT()
Using NODEFAULT and DODEFAULT() to control the Inheritance Hierarchy
Written by Marcia Akins, Published @ 12/18/2007 11:12:03 PM
Bernard Bout    How do I release the memory used by my VFP application.
This function shows how you can release memory as needed from within your application without resorting to Minimising the window.
Written by Bernard Bout, Published @ 12/7/2007 5:31:27 AM
Ken Murphy    Moving to MySQL, SQL, Oracle, etc. - some basics
You have decided that you wish to move to a MySQL, SQL or Oracle etc. backend. Here are some of the basics you will need to get you started.
Written by Ken Murphy, Published @ 9/9/2007 2:51:54 PM
Bernard Bout    How do I change the attributes like Colour, Font etc. for my Menu's
Dynamically change the colours and fonts of menu's created in the VFP Menu Generator.
Written by Bernard Bout, Published @ 8/22/2007 6:42:41 AM
Cetin Basoz    Sample Data as Text to post on forums
If you post part of your data along with your question it would be much easier to reproduce the test code and check propesed solution before replying. This code is about getting your data into clipboard in plain text format that you can paste in your message.
Written by Cetin Basoz, Published @ 7/26/2007 6:27:16 PM
Ken Murphy    Sub-Classing Basics
When developing an app, many developers will simply use the VFP base classes. If you are one of those developers, read this.
Written by Ken Murphy, Published @ 6/13/2007 2:30:20 PM
Bernard Bout    How do I protect my Database from being opened in other applications
This outlines a method for protecting your VFP Database, tables and other files. It uses an approach called "Impersonation"
Written by Bernard Bout, Published @ 6/10/2007 6:22:48 AM
Boudewijn Lutgerink    retrieving the local IP address
with just two lines of code you can retrieve the local IP address
Written by Boudewijn Lutgerink, Published @ 6/6/2007 12:14:52 PM
Boudewijn Lutgerink    a quick and simple "shutdown" button
Create a shutdown button that works like pulling the plug
Written by Boudewijn Lutgerink, Published @ 3/7/2007 12:17:51 PM
Don Higgins    Data Driven SimpleList OLE Control
Adding End User Controls to the SimpleList Class
Written by Don Higgins, Published @ 3/5/2007 3:20:50 AM
Ken Murphy    Indexing in a Multi-User Environment.
You are now moving to a multi-user environment, but with your tables opened in a SHARED environment, you are having difficulties with the INDEX ON command.
Written by Ken Murphy, Published @ 2/21/2007 5:13:55 PM
Ken Murphy    Why won't my "GROUP BY" query work?
With VFP 8, the rules about GROUP BY changed. Here is why and how to fix your code:
Written by Ken Murphy, Published @ 2/11/2007 4:30:30 PM
Boudewijn Lutgerink    one or more tables in my database seems to be corrupted, WHAT DO I DO NOW?
Every now and then a table in your VFP database can get corrupted by any kind of course, what do you do now?
Written by Boudewijn Lutgerink, Published @ 12/28/2006 11:20:28 AM
Ken Murphy    When I run my app as an EXE it just flashes and then dissapears.
One of the most common problems for beginners, a question describing symptoms like tihs pops up on average about once every week or two. This FAQ will provide the beginner with information on the READ EVENTS command
Written by Ken Murphy, Published @ 12/18/2006 4:52:18 AM
Ken Murphy    Backups - The bare minimum
I have noted a number of threads in the past, where a good, basic backup was missing. For the beginner, some guidelines for a basic backup.
Written by Ken Murphy, Published @ 12/15/2006 7:03:36 PM
Boudewijn Lutgerink    be aware of the NVL()
using NVL() in a SQL select can bring somewhat, ahem, unexpected results
Written by Boudewijn Lutgerink, Published @ 12/8/2006 2:04:08 PM
Ken Murphy    Everybody tells me that PUBLIC variables are not good practice - Why?
The use of PUBLIC variables is normally frowned upon by most experienced developers. Why do PUBLIC variables have such a bad reputation?
Written by Ken Murphy, Published @ 12/7/2006 3:21:43 PM
Eric den Doop    Common causes of the infamous C5 Access Violation exception
Sooner or later, every VFP developer will have to deal with the C0000005 error...
Written by Eric den Doop, Published @ 12/6/2006 10:19:02 PM
Ken Murphy    A faster way to RightClick->Edit
When editing a form that has containers and page frames, you have to Right Click and then select Edit from the popup menu. There is a faster way.
Written by Ken Murphy, Published @ 12/6/2006 8:21:54 PM
Ken Murphy    But I don't have an autoinc field - I don't have VFP 8 or better
How to create an incremented primary key field when you do not have an autoinc field.
Written by Ken Murphy, Published @ 12/6/2006 7:39:31 PM
Ken Murphy    The "Rule" for creating primary key fields
Ken's hard and fast rule about creating primary key fields
Written by Ken Murphy, Published @ 12/6/2006 6:58:50 PM
Ken Murphy    How to handle image files in a VFP backend
A simple explanation of how to deal with storing image files without running into VFP's 2 Gig file size limit.
Written by Ken Murphy, Published @ 12/6/2006 1:24:47 PM
Eric den Doop    What are my VFP environment settings?
Use this not well-known feature to get a list of the current VFP environment settings.
Written by Eric den Doop, Published @ 12/6/2006 9:11:41 AM
Boudewijn Lutgerink    disturbing IntelliSense Tamed
4 simple lines of code will help you to Tame the popup of Intellisense.
Written by Boudewijn Lutgerink, Published @ 11/28/2006 9:47:55 AM
Borislav Borissov    How to add Foxite in FireFox search engines
If you are using Mozilla FireFox browser you can add the Foxite.COM Search Engine to the list of Search Providers.
Written by Borislav Borissov, Published @ 11/24/2006 8:29:51 PM
Eric den Doop    Add Foxite To Your IE7 Search Bar
If you are using Internet Explorer 7, you can add the Foxite.COM Search Engine to IE7's list of Search Providers. This takes only a few seconds.
Written by Eric den Doop, Published @ 11/24/2006 4:00:55 PM
Chris Chamberlain    Display images and messages from a VFP menu in a statusbar
If you want to emulate Windows Explorer behaviour in a VFP statusbar by displaying an image followed by a message bottom left...
Written by Chris Chamberlain, Published @ 11/19/2006 10:42:49 AM
Chris Chamberlain    Asynchronous messagebox
Example of an asynchronous messagebox
Written by Chris Chamberlain, Published @ 11/19/2006 8:32:35 AM
Eric den Doop    How to hide the main Visual FoxPro screen
Here's how you can hide the default white VFP background window.
Written by Eric den Doop, Published @ 11/10/2006 1:36:49 PM
Eric den Doop    Tips on Posting Good Questions
Here are a few suggestions that make it sure you get the best answer to your question as quickly as possible.
Written by Eric den Doop, Published @ 11/5/2006 4:51:12 PM
Eric den Doop    Why don't you answer my e-mails?
Explanation why I don't answer every e-mail you send.
Written by Eric den Doop, Published @ 11/4/2006 10:42:25 AM
Eric den Doop    Chat feature for Online Foxite Members
Just some information about a Chat feature for Foxite Members
Written by Eric den Doop, Published @ 11/4/2006 10:33:58 AM
Pete Sass    Exchange Server 2000: Tips from Pete
Pete shares some ideas about maintaining an Exchange Server 2000.
Written by Pete Sass, Published @ 11/4/2006 9:16:17 AM
Pete Sass    SQL SERVER: things to consider prior to starting your application development process
Just some stuff for those out there targeting SQL-Server backends. Here is a list of things you should consider prior to starting your application development process.
Written by Pete Sass, Published @ 11/4/2006 8:58:08 AM
Eric den Doop    How To Enable JavaScript In Your Web Browser
The Foxite.COM web site requires JavaScript to be enabled in your web browser. In this FAQ, your host Eric den Doop explains how to enable JavaScript in a number of popular web browsers.
Written by Eric den Doop, Published @ 10/27/2006 2:18:18 PM
Pete Sass    A few tips when targeting a SQL SERVER backend
Just a few issues I have encountered over the past 2-3 weeks...
Written by Pete Sass, Published @ 10/11/2006 1:18:58 AM
Pete Sass    Tips when using SQL pass-through to target SQL SERVER backends
This FAQ is applicable to those VFP front end developers that are targeting a SQL Server backend and are not using Cursor Adapters, but are in fact using SQLEXEC() and SQL pass-through commands.
Written by Pete Sass, Published @ 9/27/2006 12:18:01 AM
Chris Chamberlain    Add MultiSelect functionality to a Grid control
Short FAQ on how to add a multiselect feature to the VFP grid control.
Written by Chris Chamberlain, Published @ 8/2/2006 4:42:31 PM
Barbara Peisch    Foxite.COM Support Forum Tips & Tricks
Tips on how to use the Foxite.COM Support Forum
Written by Barbara Peisch, Published @ 8/2/2006 4:40:40 PM
Chris Chamberlain    How to use SYS(1500) within a menu procedure
Chris shows you how to activate a Visual FoxPro system menu item from a procedure within a menu.
Written by Chris Chamberlain, Published @ 8/2/2006 12:14:13 PM