Subscribe: Foxite.COM Frequently Asked Questions
Added By: Feedage Forager Feedage Grade B rated
Language: English
add foxite  add  application  code  data  environment  feature  foxite  menu  search  server  sql pass  sql server  sql  tips  vfp 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Foxite.COM Frequently Asked Questions

Foxite.COM Frequently Asked Questions

Foxite.COM Frequently Asked Questions


WinAPI calls

Wed, 07 Sep 2016 16:41:34 +0100

How can I ensure ShellExecute() will print a pdf in windows 10?

Connecting to ODBC from VFP on 64bit OS

Fri, 23 Mar 2012 15:31:53 +0100

32 bit ODBC drivers on 64 bit OS

How do I print Multiple LABELS + Barcodes in VFP

Fri, 13 Jan 2012 02:00:34 +0100

A concise tutorial on printing Labels in VFP

SQL Joins

Wed, 22 Jun 2011 17:14:48 +0100

Results of the different SQL Joins

Class definition MSXML2.DOMDOCUMENT.4.0 is not found

Fri, 10 Jun 2011 08:33:52 +0100

The task manager is not displayed correctly. Instead you get a message saying Class definition MSXML2.DOMDOCUMENT.4.0 is not found

How to create an animated .gif with ImageMagick

Mon, 23 Mar 2009 09:19:37 +0100

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.

Classes and Objects

Wed, 21 Jan 2009 00:18:56 +0100


My System toolbars do not save positions

Tue, 23 Dec 2008 11:25:31 +0100

System Toolbars do not save positions in IDE and line up one below the other left-aligned in IDE

How to add a progress bar to a .zip operation

Mon, 10 Nov 2008 15:30:43 +0100

Simple .prg that enables a developer to populate a progress bar utilising the ZipCallBack() function in vfpcompression.fll

Intelligent Update of Only Modified Fields with SQL Server Databases

Thu, 24 Apr 2008 20:09:06 +0100

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.

_screen.activeform ... HOLD ON!

Wed, 16 Apr 2008 11:57:41 +0100

there is a shorter way to get access to the activeform on the screen. Here's how...

Using Private Data Sessions in Forms

Thu, 27 Mar 2008 03:23:15 +0100

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.

How can I cancel out of a Zip operation?

Wed, 27 Feb 2008 11:05:45 +0100

Utilising the callback feature in Craig Boyd's compression library to enable cancelling

add sms service to your applications

Thu, 03 Jan 2008 08:57:36 +0100

In this tip I show you how you can add SMS service to your application with the use of Skype.

#define your tables

Wed, 19 Dec 2007 09:26:32 +0100

#define can be used for many purposes, I show one here I use in simplifying my code

The Difference Between NODEFAULT and DODEFAULT()

Tue, 18 Dec 2007 23:12:02 +0100

Using NODEFAULT and DODEFAULT() to control the Inheritance Hierarchy

How do I release the memory used by my VFP application.

Fri, 07 Dec 2007 05:31:26 +0100

This function shows how you can release memory as needed from within your application without resorting to Minimising the window.

Moving to MySQL, SQL, Oracle, etc. - some basics

Sun, 09 Sep 2007 14:51:53 +0100

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.

How do I change the attributes like Colour, Font etc. for my Menu's

Wed, 22 Aug 2007 06:42:40 +0100

Dynamically change the colours and fonts of menu's created in the VFP Menu Generator.

Sample Data as Text to post on forums

Thu, 26 Jul 2007 18:27:15 +0100

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.

Sub-Classing Basics

Wed, 13 Jun 2007 14:30:19 +0100

When developing an app, many developers will simply use the VFP base classes. If you are one of those developers, read this.

How do I protect my Database from being opened in other applications

Sun, 10 Jun 2007 06:22:47 +0100

This outlines a method for protecting your VFP Database, tables and other files. It uses an approach called "Impersonation"

retrieving the local IP address

Wed, 06 Jun 2007 12:14:51 +0100

with just two lines of code you can retrieve the local IP address

a quick and simple "shutdown" button

Wed, 07 Mar 2007 12:17:50 +0100

Create a shutdown button that works like pulling the plug

Data Driven SimpleList OLE Control

Mon, 05 Mar 2007 03:20:49 +0100

Adding End User Controls to the SimpleList Class

Indexing in a Multi-User Environment.

Wed, 21 Feb 2007 17:13:54 +0100

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.

Why won't my "GROUP BY" query work?

Sun, 11 Feb 2007 16:30:29 +0100

With VFP 8, the rules about GROUP BY changed. Here is why and how to fix your code:

one or more tables in my database seems to be corrupted, WHAT DO I DO NOW?

Thu, 28 Dec 2006 11:20:27 +0100

Every now and then a table in your VFP database can get corrupted by any kind of course, what do you do now?

When I run my app as an EXE it just flashes and then dissapears.

Mon, 18 Dec 2006 04:52:17 +0100

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

Backups - The bare minimum

Fri, 15 Dec 2006 19:03:35 +0100

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.

be aware of the NVL()

Fri, 08 Dec 2006 14:04:07 +0100

using NVL() in a SQL select can bring somewhat, ahem, unexpected results

Everybody tells me that PUBLIC variables are not good practice - Why?

Thu, 07 Dec 2006 15:21:42 +0100

The use of PUBLIC variables is normally frowned upon by most experienced developers. Why do PUBLIC variables have such a bad reputation?

Common causes of the infamous C5 Access Violation exception

Wed, 06 Dec 2006 22:19:01 +0100

Sooner or later, every VFP developer will have to deal with the C0000005 error...

A faster way to RightClick->Edit

Wed, 06 Dec 2006 20:21:53 +0100

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.

But I don't have an autoinc field - I don't have VFP 8 or better

Wed, 06 Dec 2006 19:39:30 +0100

How to create an incremented primary key field when you do not have an autoinc field.

The "Rule" for creating primary key fields

Wed, 06 Dec 2006 18:58:49 +0100

Ken's hard and fast rule about creating primary key fields

How to handle image files in a VFP backend

Wed, 06 Dec 2006 13:24:46 +0100

A simple explanation of how to deal with storing image files without running into VFP's 2 Gig file size limit.

What are my VFP environment settings?

Wed, 06 Dec 2006 09:11:40 +0100

Use this not well-known feature to get a list of the current VFP environment settings.

disturbing IntelliSense Tamed

Tue, 28 Nov 2006 09:47:54 +0100

4 simple lines of code will help you to Tame the popup of Intellisense.

How to add Foxite in FireFox search engines

Fri, 24 Nov 2006 20:29:50 +0100

If you are using Mozilla FireFox browser you can add the Foxite.COM Search Engine to the list of Search Providers.

Add Foxite To Your IE7 Search Bar

Fri, 24 Nov 2006 16:00:54 +0100

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.

Display images and messages from a VFP menu in a statusbar

Sun, 19 Nov 2006 10:42:48 +0100

If you want to emulate Windows Explorer behaviour in a VFP statusbar by displaying an image followed by a message bottom left...

Asynchronous messagebox

Sun, 19 Nov 2006 08:32:34 +0100

Example of an asynchronous messagebox

How to hide the main Visual FoxPro screen

Fri, 10 Nov 2006 13:36:48 +0100

Here's how you can hide the default white VFP background window.

Tips on Posting Good Questions

Sun, 05 Nov 2006 16:51:11 +0100

Here are a few suggestions that make it sure you get the best answer to your question as quickly as possible.

Why don't you answer my e-mails?

Sat, 04 Nov 2006 10:42:24 +0100

Explanation why I don't answer every e-mail you send.

Chat feature for Online Foxite Members

Sat, 04 Nov 2006 10:33:57 +0100

Just some information about a Chat feature for Foxite Members

Exchange Server 2000: Tips from Pete

Sat, 04 Nov 2006 09:16:16 +0100

Pete shares some ideas about maintaining an Exchange Server 2000.

SQL SERVER: things to consider prior to starting your application development process

Sat, 04 Nov 2006 08:58:07 +0100

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.

How To Enable JavaScript In Your Web Browser

Fri, 27 Oct 2006 14:18:17 +0100

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.

A few tips when targeting a SQL SERVER backend

Wed, 11 Oct 2006 01:18:57 +0100

Just a few issues I have encountered over the past 2-3 weeks...

Tips when using SQL pass-through to target SQL SERVER backends

Wed, 27 Sep 2006 00:18:00 +0100

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.

Add MultiSelect functionality to a Grid control

Wed, 02 Aug 2006 16:42:30 +0100

Short FAQ on how to add a multiselect feature to the VFP grid control.

Foxite.COM Support Forum Tips & Tricks

Wed, 02 Aug 2006 16:40:39 +0100

Tips on how to use the Foxite.COM Support Forum

How to use SYS(1500) within a menu procedure

Wed, 02 Aug 2006 12:14:12 +0100

Chris shows you how to activate a Visual FoxPro system menu item from a procedure within a menu.