Foxite.COM Frequently Asked Questions - www.foxite.com - The Home Of The Visual FoxPro Experts

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

	User Name: *
	Password: *
		Remember me
		No Account? Lost Password?

		Connecting to ODBC from VFP on 64bit OS
		32 bit ODBC drivers on 64 bit OS
		Written by tushar, Published @ 3/23/2012 3:31:54 PM

		How do I print Multiple LABELS + Barcodes in VFP
		A concise tutorial on printing Labels in VFP
		Written by Bernard Bout, Published @ 1/13/2012 2:00:35 AM

		SQL Joins
		Results of the different SQL Joins
		Written by tushar, Published @ 6/22/2011 5:14:49 PM

		Class definition MSXML2.DOMDOCUMENT.4.0 is not found
		The task manager is not displayed correctly. Instead you get a message saying Class definition MSXML2.DOMDOCUMENT.4.0 is not found
		Written by tushar, Published @ 6/10/2011 8:33:53 AM

		How to create an animated .gif with ImageMagick
		Until such time as such functionality exists with GdiPlus, the following alternative methodology does provide a way to allow a user or developer to programatically create an animated .gif.
		Written by Chris Chamberlain, Published @ 3/23/2009 9:19:38 AM

		Classes and Objects
		PROBLEM WITH CA
		Written by Osis Barajas, Published @ 1/21/2009 12:18:57 AM

		My System toolbars do not save positions
		System Toolbars do not save positions in IDE and line up one below the other left-aligned in IDE
		Written by Bernard Bout, Published @ 12/23/2008 11:25:32 AM

		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

		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

		_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

		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

		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

		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

		#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

		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

		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

		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

		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

		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

		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

		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

		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

		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

		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

		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