http://www.foxite.com/faq/Foxite.COM Frequently Asked Questionshttp://www.foxite.com/articles/5enFoxite.Community.Web.RSSFeeds.Faqhttp://www.foxite.com/images/foxite.gifhttp://www.foxite.com/faq/Foxite.COM Frequently Asked Questionshttp://www.foxite.com/faq/default.aspx?id=66http://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 +0100http://www.foxite.com/faq/default.aspx?id=65http://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 +0100http://www.foxite.com/faq/default.aspx?id=61http://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 +0100http://www.foxite.com/faq/default.aspx?id=59http://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 +0100http://www.foxite.com/faq/default.aspx?id=58http://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 +0100http://www.foxite.com/faq/default.aspx?id=57http://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 +0100http://www.foxite.com/faq/default.aspx?id=56http://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 +0100http://www.foxite.com/faq/default.aspx?id=55http://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 +0100http://www.foxite.com/faq/default.aspx?id=54http://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 +0100http://www.foxite.com/faq/default.aspx?id=52http://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 +0100http://www.foxite.com/faq/default.aspx?id=50http://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 +0100http://www.foxite.com/faq/default.aspx?id=49http://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 +0100http://www.foxite.com/faq/default.aspx?id=48http://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 +0100http://www.foxite.com/faq/default.aspx?id=47http://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 +0100http://www.foxite.com/faq/default.aspx?id=46http://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 +0100http://www.foxite.com/faq/default.aspx?id=45http://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 +0100http://www.foxite.com/faq/default.aspx?id=44http://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 +0100http://www.foxite.com/faq/default.aspx?id=43http://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 +0100http://www.foxite.com/faq/default.aspx?id=37http://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 +0100http://www.foxite.com/faq/default.aspx?id=36http://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 +0100http://www.foxite.com/faq/default.aspx?id=35http://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 +0100http://www.foxite.com/faq/default.aspx?id=32http://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 +0100http://www.foxite.com/faq/default.aspx?id=31http://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 +0100http://www.foxite.com/faq/default.aspx?id=30http://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 +0100http://www.foxite.com/faq/default.aspx?id=29http://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 +0100http://www.foxite.com/faq/default.aspx?id=28http://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 +0100http://www.foxite.com/faq/default.aspx?id=27http://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 +0100http://www.foxite.com/faq/default.aspx?id=26http://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 +0100http://www.foxite.com/faq/default.aspx?id=25http://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 +0100http://www.foxite.com/faq/default.aspx?id=24http://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 +0100http://www.foxite.com/faq/default.aspx?id=23http://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 +0100http://www.foxite.com/faq/default.aspx?id=22http://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 +0100http://www.foxite.com/faq/default.aspx?id=20http://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 +0100http://www.foxite.com/faq/default.aspx?id=19http://www.foxite.com/faq/default.aspx?id=19Example of an asynchronous messageboxChris Chamberlain<invalid-address@foxite.com>Sun, 19 Nov 2006 08:32:34 +0100http://www.foxite.com/faq/default.aspx?id=18http://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 +0100http://www.foxite.com/faq/default.aspx?id=17http://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 +0100http://www.foxite.com/faq/default.aspx?id=16http://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 +0100http://www.foxite.com/faq/default.aspx?id=15http://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 +0100http://www.foxite.com/faq/default.aspx?id=5http://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 +0100http://www.foxite.com/faq/default.aspx?id=13http://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 +0100http://www.foxite.com/faq/default.aspx?id=4http://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 +0100http://www.foxite.com/faq/default.aspx?id=7http://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 +0100http://www.foxite.com/faq/default.aspx?id=8http://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 +0100http://www.foxite.com/faq/default.aspx?id=3http://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 +0100http://www.foxite.com/faq/default.aspx?id=2http://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 +0100http://www.foxite.com/faq/default.aspx?id=1http://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