Foxite.COM Frequently Asked Questionshttps://www.foxite.com/faq/Foxite.COM Frequently Asked Questionshttps://www.foxite.com/articles/5enFoxite.Community.Web.RSSFeeds.Faqhttps://www.foxite.com/images/foxite.gifFoxite.COM Frequently Asked Questionshttps://www.foxite.com/faq/Foxite.COM Frequently Asked QuestionsWinAPI calls https://www.foxite.com/faq/default.aspx?id=96https://www.foxite.com/faq/default.aspx?id=96How can I ensure ShellExecute() will print a pdf in windows 10?Chris Chamberlain<invalid-address@foxite.com>Wed, 07 Sep 2016 16:41:34 +0100Connecting to ODBC from VFP on 64bit OS https://www.foxite.com/faq/default.aspx?id=91https://www.foxite.com/faq/default.aspx?id=9132 bit ODBC drivers on 64 bit OStushar<invalid-address@foxite.com>Fri, 23 Mar 2012 15:31:53 +0100How do I print Multiple LABELS + Barcodes in VFP https://www.foxite.com/faq/default.aspx?id=90https://www.foxite.com/faq/default.aspx?id=90A concise tutorial on printing Labels in VFPBernard Bout<invalid-address@foxite.com>Fri, 13 Jan 2012 02:00:34 +0100SQL Joins https://www.foxite.com/faq/default.aspx?id=89https://www.foxite.com/faq/default.aspx?id=89Results of the different SQL Joinstushar<invalid-address@foxite.com>Wed, 22 Jun 2011 17:14:48 +0100Class definition MSXML2.DOMDOCUMENT.4.0 is not found https://www.foxite.com/faq/default.aspx?id=88https://www.foxite.com/faq/default.aspx?id=88The task manager is not displayed correctly. Instead you get a message saying Class definition MSXML2.DOMDOCUMENT.4.0 is not foundtushar<invalid-address@foxite.com>Fri, 10 Jun 2011 08:33:52 +0100How to create an animated .gif with ImageMagick https://www.foxite.com/faq/default.aspx?id=80https://www.foxite.com/faq/default.aspx?id=80Until 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.Chris Chamberlain<invalid-address@foxite.com>Mon, 23 Mar 2009 09:19:37 +0100Classes and Objects https://www.foxite.com/faq/default.aspx?id=78https://www.foxite.com/faq/default.aspx?id=78PROBLEM WITH CAOsis Barajas<invalid-address@foxite.com>Wed, 21 Jan 2009 00:18:56 +0100My System toolbars do not save positions https://www.foxite.com/faq/default.aspx?id=76https://www.foxite.com/faq/default.aspx?id=76System Toolbars do not save positions in IDE and line up one below the other left-aligned in IDEBernard Bout<invalid-address@foxite.com>Tue, 23 Dec 2008 11:25:31 +0100How to add a progress bar to a .zip operation https://www.foxite.com/faq/default.aspx?id=75https://www.foxite.com/faq/default.aspx?id=75Simple .prg that enables a developer to populate a progress bar utilising the ZipCallBack() function in vfpcompression.fllChris Chamberlain<invalid-address@foxite.com>Mon, 10 Nov 2008 15:30:43 +0100Intelligent Update of Only Modified Fields with SQL Server Databases https://www.foxite.com/faq/default.aspx?id=66https://www.foxite.com/faq/default.aspx?id=66Idea 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.Pete Sass<invalid-address@foxite.com>Thu, 24 Apr 2008 20:09:06 +0100_screen.activeform ... HOLD ON! https://www.foxite.com/faq/default.aspx?id=65https://www.foxite.com/faq/default.aspx?id=65there is a shorter way to get access to the activeform on the screen. Here's how...Boudewijn Lutgerink<invalid-address@foxite.com>Wed, 16 Apr 2008 11:57:41 +0100Using Private Data Sessions in Forms https://www.foxite.com/faq/default.aspx?id=61https://www.foxite.com/faq/default.aspx?id=61It 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.Ken Murphy<invalid-address@foxite.com>Thu, 27 Mar 2008 03:23:15 +0100How can I cancel out of a Zip operation? https://www.foxite.com/faq/default.aspx?id=59https://www.foxite.com/faq/default.aspx?id=59Utilising the callback feature in Craig Boyd's compression library to enable cancellingChris Chamberlain<invalid-address@foxite.com>Wed, 27 Feb 2008 11:05:45 +0100add sms service to your applications https://www.foxite.com/faq/default.aspx?id=58https://www.foxite.com/faq/default.aspx?id=58In this tip I show you how you can add SMS service to your application with the use of Skype.Boudewijn Lutgerink<invalid-address@foxite.com>Thu, 03 Jan 2008 08:57:36 +0100#define your tables https://www.foxite.com/faq/default.aspx?id=57https://www.foxite.com/faq/default.aspx?id=57#define can be used for many purposes, I show one here I use in simplifying my codeBoudewijn Lutgerink<invalid-address@foxite.com>Wed, 19 Dec 2007 09:26:32 +0100The Difference Between NODEFAULT and DODEFAULT() https://www.foxite.com/faq/default.aspx?id=56https://www.foxite.com/faq/default.aspx?id=56Using NODEFAULT and DODEFAULT() to control the Inheritance HierarchyMarcia Akins<invalid-address@foxite.com>Tue, 18 Dec 2007 23:12:02 +0100How do I release the memory used by my VFP application. https://www.foxite.com/faq/default.aspx?id=55https://www.foxite.com/faq/default.aspx?id=55This function shows how you can release memory as needed from within your application without resorting to Minimising the window.Bernard Bout<invalid-address@foxite.com>Fri, 07 Dec 2007 05:31:26 +0100Moving to MySQL, SQL, Oracle, etc. - some basics https://www.foxite.com/faq/default.aspx?id=54https://www.foxite.com/faq/default.aspx?id=54You 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.Ken Murphy<invalid-address@foxite.com>Sun, 09 Sep 2007 14:51:53 +0100How do I change the attributes like Colour, Font etc. for my Menu's https://www.foxite.com/faq/default.aspx?id=52https://www.foxite.com/faq/default.aspx?id=52Dynamically change the colours and fonts of menu's created in the VFP Menu Generator.Bernard Bout<invalid-address@foxite.com>Wed, 22 Aug 2007 06:42:40 +0100Sample Data as Text to post on forums https://www.foxite.com/faq/default.aspx?id=50https://www.foxite.com/faq/default.aspx?id=50If 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.Cetin Basoz<invalid-address@foxite.com>Thu, 26 Jul 2007 18:27:15 +0100Sub-Classing Basics https://www.foxite.com/faq/default.aspx?id=49https://www.foxite.com/faq/default.aspx?id=49When developing an app, many developers will simply use the VFP base classes. If you are one of those developers, read this.Ken Murphy<invalid-address@foxite.com>Wed, 13 Jun 2007 14:30:19 +0100How do I protect my Database from being opened in other applications https://www.foxite.com/faq/default.aspx?id=48https://www.foxite.com/faq/default.aspx?id=48This outlines a method for protecting your VFP Database, tables and other files. It uses an approach called "Impersonation"Bernard Bout<invalid-address@foxite.com>Sun, 10 Jun 2007 06:22:47 +0100retrieving the local IP address https://www.foxite.com/faq/default.aspx?id=47https://www.foxite.com/faq/default.aspx?id=47with just two lines of code you can retrieve the local IP addressBoudewijn Lutgerink<invalid-address@foxite.com>Wed, 06 Jun 2007 12:14:51 +0100a quick and simple "shutdown" button https://www.foxite.com/faq/default.aspx?id=46https://www.foxite.com/faq/default.aspx?id=46Create a shutdown button that works like pulling the plugBoudewijn Lutgerink<invalid-address@foxite.com>Wed, 07 Mar 2007 12:17:50 +0100Data Driven SimpleList OLE Control https://www.foxite.com/faq/default.aspx?id=45https://www.foxite.com/faq/default.aspx?id=45Adding End User Controls to the SimpleList ClassDon Higgins<invalid-address@foxite.com>Mon, 05 Mar 2007 03:20:49 +0100Indexing in a Multi-User Environment. https://www.foxite.com/faq/default.aspx?id=44https://www.foxite.com/faq/default.aspx?id=44You 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.Ken Murphy<invalid-address@foxite.com>Wed, 21 Feb 2007 17:13:54 +0100Why won't my "GROUP BY" query work? https://www.foxite.com/faq/default.aspx?id=43https://www.foxite.com/faq/default.aspx?id=43With VFP 8, the rules about GROUP BY changed. Here is why and how to fix your code:Ken Murphy<invalid-address@foxite.com>Sun, 11 Feb 2007 16:30:29 +0100one or more tables in my database seems to be corrupted, WHAT DO I DO NOW? https://www.foxite.com/faq/default.aspx?id=37https://www.foxite.com/faq/default.aspx?id=37Every now and then a table in your VFP database can get corrupted by any kind of course, what do you do now?Boudewijn Lutgerink<invalid-address@foxite.com>Thu, 28 Dec 2006 11:20:27 +0100When I run my app as an EXE it just flashes and then dissapears. https://www.foxite.com/faq/default.aspx?id=36https://www.foxite.com/faq/default.aspx?id=36One 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 commandKen Murphy<invalid-address@foxite.com>Mon, 18 Dec 2006 04:52:17 +0100Backups - The bare minimum https://www.foxite.com/faq/default.aspx?id=35https://www.foxite.com/faq/default.aspx?id=35I 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.Ken Murphy<invalid-address@foxite.com>Fri, 15 Dec 2006 19:03:35 +0100be aware of the NVL() https://www.foxite.com/faq/default.aspx?id=32https://www.foxite.com/faq/default.aspx?id=32using NVL() in a SQL select can bring somewhat, ahem, unexpected resultsBoudewijn Lutgerink<invalid-address@foxite.com>Fri, 08 Dec 2006 14:04:07 +0100Everybody tells me that PUBLIC variables are not good practice - Why? https://www.foxite.com/faq/default.aspx?id=31https://www.foxite.com/faq/default.aspx?id=31The use of PUBLIC variables is normally frowned upon by most experienced developers. Why do PUBLIC variables have such a bad reputation?Ken Murphy<invalid-address@foxite.com>Thu, 07 Dec 2006 15:21:42 +0100Common causes of the infamous C5 Access Violation exception https://www.foxite.com/faq/default.aspx?id=30https://www.foxite.com/faq/default.aspx?id=30Sooner or later, every VFP developer will have to deal with the C0000005 error...Eric den Doop<invalid-address@foxite.com>Wed, 06 Dec 2006 22:19:01 +0100A faster way to RightClick->Edit https://www.foxite.com/faq/default.aspx?id=29https://www.foxite.com/faq/default.aspx?id=29When 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.Ken Murphy<invalid-address@foxite.com>Wed, 06 Dec 2006 20:21:53 +0100But I don't have an autoinc field - I don't have VFP 8 or better https://www.foxite.com/faq/default.aspx?id=28https://www.foxite.com/faq/default.aspx?id=28How to create an incremented primary key field when you do not have an autoinc field.Ken Murphy<invalid-address@foxite.com>Wed, 06 Dec 2006 19:39:30 +0100The "Rule" for creating primary key fields https://www.foxite.com/faq/default.aspx?id=27https://www.foxite.com/faq/default.aspx?id=27Ken's hard and fast rule about creating primary key fieldsKen Murphy<invalid-address@foxite.com>Wed, 06 Dec 2006 18:58:49 +0100How to handle image files in a VFP backend https://www.foxite.com/faq/default.aspx?id=26https://www.foxite.com/faq/default.aspx?id=26A simple explanation of how to deal with storing image files without running into VFP's 2 Gig file size limit.Ken Murphy<invalid-address@foxite.com>Wed, 06 Dec 2006 13:24:46 +0100What are my VFP environment settings? https://www.foxite.com/faq/default.aspx?id=25https://www.foxite.com/faq/default.aspx?id=25Use this not well-known feature to get a list of the current VFP environment settings.Eric den Doop<invalid-address@foxite.com>Wed, 06 Dec 2006 09:11:40 +0100disturbing IntelliSense Tamed https://www.foxite.com/faq/default.aspx?id=24https://www.foxite.com/faq/default.aspx?id=244 simple lines of code will help you to Tame the popup of Intellisense.Boudewijn Lutgerink<invalid-address@foxite.com>Tue, 28 Nov 2006 09:47:54 +0100How to add Foxite in FireFox search engines https://www.foxite.com/faq/default.aspx?id=23https://www.foxite.com/faq/default.aspx?id=23If you are using Mozilla FireFox browser you can add the Foxite.COM Search Engine to the list of Search Providers.Borislav Borissov<invalid-address@foxite.com>Fri, 24 Nov 2006 20:29:50 +0100Add Foxite To Your IE7 Search Bar https://www.foxite.com/faq/default.aspx?id=22https://www.foxite.com/faq/default.aspx?id=22If 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.Eric den Doop<invalid-address@foxite.com>Fri, 24 Nov 2006 16:00:54 +0100Display images and messages from a VFP menu in a statusbar https://www.foxite.com/faq/default.aspx?id=20https://www.foxite.com/faq/default.aspx?id=20If you want to emulate Windows Explorer behaviour in a VFP statusbar by displaying an image followed by a message bottom left...Chris Chamberlain<invalid-address@foxite.com>Sun, 19 Nov 2006 10:42:48 +0100Asynchronous messagebox https://www.foxite.com/faq/default.aspx?id=19https://www.foxite.com/faq/default.aspx?id=19Example of an asynchronous messageboxChris Chamberlain<invalid-address@foxite.com>Sun, 19 Nov 2006 08:32:34 +0100How to hide the main Visual FoxPro screen https://www.foxite.com/faq/default.aspx?id=18https://www.foxite.com/faq/default.aspx?id=18Here's how you can hide the default white VFP background window.Eric den Doop<invalid-address@foxite.com>Fri, 10 Nov 2006 13:36:48 +0100Tips on Posting Good Questions https://www.foxite.com/faq/default.aspx?id=17https://www.foxite.com/faq/default.aspx?id=17Here are a few suggestions that make it sure you get the best answer to your question as quickly as possible.Eric den Doop<invalid-address@foxite.com>Sun, 05 Nov 2006 16:51:11 +0100Why don't you answer my e-mails? https://www.foxite.com/faq/default.aspx?id=16https://www.foxite.com/faq/default.aspx?id=16Explanation why I don't answer every e-mail you send.Eric den Doop<invalid-address@foxite.com>Sat, 04 Nov 2006 10:42:24 +0100Chat feature for Online Foxite Members https://www.foxite.com/faq/default.aspx?id=15https://www.foxite.com/faq/default.aspx?id=15Just some information about a Chat feature for Foxite MembersEric den Doop<invalid-address@foxite.com>Sat, 04 Nov 2006 10:33:57 +0100Exchange Server 2000: Tips from Pete https://www.foxite.com/faq/default.aspx?id=5https://www.foxite.com/faq/default.aspx?id=5Pete shares some ideas about maintaining an Exchange Server 2000.Pete Sass<invalid-address@foxite.com>Sat, 04 Nov 2006 09:16:16 +0100SQL SERVER: things to consider prior to starting your application development process https://www.foxite.com/faq/default.aspx?id=13https://www.foxite.com/faq/default.aspx?id=13Just 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.Pete Sass<invalid-address@foxite.com>Sat, 04 Nov 2006 08:58:07 +0100How To Enable JavaScript In Your Web Browser https://www.foxite.com/faq/default.aspx?id=4https://www.foxite.com/faq/default.aspx?id=4The 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.Eric den Doop<invalid-address@foxite.com>Fri, 27 Oct 2006 14:18:17 +0100A few tips when targeting a SQL SERVER backend https://www.foxite.com/faq/default.aspx?id=7https://www.foxite.com/faq/default.aspx?id=7Just a few issues I have encountered over the past 2-3 weeks...Pete Sass<invalid-address@foxite.com>Wed, 11 Oct 2006 01:18:57 +0100Tips when using SQL pass-through to target SQL SERVER backends https://www.foxite.com/faq/default.aspx?id=8https://www.foxite.com/faq/default.aspx?id=8This 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.
Pete Sass<invalid-address@foxite.com>Wed, 27 Sep 2006 00:18:00 +0100Add MultiSelect functionality to a Grid control https://www.foxite.com/faq/default.aspx?id=3https://www.foxite.com/faq/default.aspx?id=3Short FAQ on how to add a multiselect feature to the VFP grid control.Chris Chamberlain<invalid-address@foxite.com>Wed, 02 Aug 2006 16:42:30 +0100Foxite.COM Support Forum Tips & Tricks https://www.foxite.com/faq/default.aspx?id=2https://www.foxite.com/faq/default.aspx?id=2Tips on how to use the Foxite.COM Support ForumBarbara Peisch<invalid-address@foxite.com>Wed, 02 Aug 2006 16:40:39 +0100How to use SYS(1500) within a menu procedure https://www.foxite.com/faq/default.aspx?id=1https://www.foxite.com/faq/default.aspx?id=1Chris shows you how to activate a Visual FoxPro system menu item from a procedure within a menu.Chris Chamberlain<invalid-address@foxite.com>Wed, 02 Aug 2006 12:14:12 +0100