38209 VFP 9 SP2 Help File

The Visual FoxPro 9 SP2 Help file corrected, supported, and enhanced.


Project Manager: Francis Faure

Ownership transfer of the VFP 9 SP2 Help file source code and rights to change from Microsoft to VFP Community via Creative Commons licensing.

What are the goals of this project?
1) Provide corrected VFP 9 SP2 Help file to the VFP Community. Corrections to the Help file include corrected index, corrected hyperlinks, and corrected stylesheet.

2) Allow the VFP Community to further enhance the Help file moving forward, adding missing content for VFP 9 SP2 and Sedna, making necessary corrections to existing examples, and repairing additional things missing in the index (like the SYS() functions).


  • February 16 2009 Version 1.04
  • February 18 2009 Version 1.05
Added in index:
PADL() -> "PADL( ) | PADR( ) | PADC( ) Functions"
PADR() -> "PADL( ) | PADR( ) | PADC( ) Functions"
PADC() -> "PADL( ) | PADR( ) | PADC( ) Functions"
all the "SYS(....)"
all the "How To: ..."
Added in aLink Keywords:
HELP PADL -> "PADL( ) | PADR( ) | PADC( ) Functions"
HELP PADR -> "PADL( ) | PADR( ) | PADC( ) Functions"
HELP PADC -> "PADL( ) | PADR( ) | PADC( ) Functions"
HELP ERROR -> "Error Messages Listed Alphabetically"
+ "Error Messages Listed Numerically"
HELP SYS -> "SYS( ) Functions Overview"
HELP LIST -> "LIST Commands" + "List Propert"
HELP CLEAR -> "CLEAR Commands" + "Clear Method"
HELP CD -> "CD | CHDIR Command"
HELP CHDIR -> "CD | CHDIR Command"
HELP MD -> "MD | MKDIR command"
HELP MKDIR -> "MD | MKDIR command"
HELP RD -> "RD | RMDIR command"
HELP RMDIR -> "RD | RMDIR command"
HELP GO -> "GO | GOTO Command"
HELP GOTO -> "GO | GOTO Command"
Changed in aLink Keywords:
HELP UPDATE -> Before on "UPDATE Command" -> now on "UPDATE SQL"
HELP INSERT -> Before on "INSERT Command" -> now on "INSERT SQL"
Added in index (popup list choice):
ComboBox control -> "ComboBox Control Properties, Methods, and Events"
CheckBox control -> "CheckBox Control Properties, Methods, and Events"
  • May 2 2011 Version 1.06

All pages:
- Corrected: Style of block "code" (margin & padding)
- Removed: Combobox on top of each page "Language Filter (All / VB / C# / C++ / J# / JScript")
- Page Footer
Added in aLink Keywords:
- now, each page has an "aLink keywords" on the Title of the page (for calling directly in VFP with HELP Title...)
Added in index:
- error messages "numerical order", "Error Messages Listed Numerically" - double click on "error messages", added "Error Messages Listed Numerically"
- double click on "double-byte characters", added "ATCC( ) function" - double click on "double-byte characters", "Application Creation with Double-Byte Character Sets"
Pages added:
- VFPX: List "Add and Updates" in VFP 9 SP2 Help file
- DBALIAS( ) Function
- Error 2202 Buffer manager internal consistency error
- Error 2203 Insufficient GDI resources
- FLDCOUNT( ) Function
- PADPROMPT( ) Function
- WINDOW( ) Function
Pages updated:
- AT_C( ) Function
- ATCC() function
- ADIR( ) Function
- Backward-Compatible Language Elements
- DBC( ) Function
- DEBUG Command
- DEBUGOUT Command
- Error Messages Listed Alphabetically: added buttons list in header
- Error Messages Listed Alphabetically: added errors 2202 and 2203
- Error Messages Listed Numerically: added buttons list in header
- Error Messages Listed Numerically: added errors 2202 and 2203
- FILE( ) Function
- FontCharSet Property
- IMESTATUS( ) Function
- LIKEC() function
- LOADPICTURE( ) Function
- NOTE Command
- PictureVal Property
- RATC( ) Function
- RIGHT( ) Function
- RIGHTC( ) Function
- SET Command Overview
- SET ECHO Command
- SET STEP Command
- SET( ) Function
- STREXTRACT( ) Function bracket removed
- STRTRAN( ) Function
- SUBSTR( ) Function
- SUBSTRC( ) Function
- SYS( ) Functions Overview
- SYS(2029)
- SYS(2325)
- Table File Structure (.dbc, .dbf, .frx, .lbx, .mnx, .pjx, .scx, .vcx)
- TXNLEVEL( ) Function
- VERSION( ) Function
- VFPX Page
Added in TOC / Contents:
- DBALIAS( ) Function
- FLDCOUNT( ) Function
- PADPROMPT( ) Function
- SET DOHISTORY Command (moved)
- VFPX Topic
- WINDOW( ) Function (Backward-Compatible Language Elements)
Installation :
- Inno Setup: now deletes the "dv_foxhelp.chw" file

Last edited May 2, 2011 at 3:16 PM by Faure, version 8


dkreuzen Jul 8, 2013 at 10:53 PM 
The Remarks of how these events work are backwards between the RangeLow and RangeHigh events.

dkreuzen Apr 3, 2013 at 6:14 PM 
When using ASCAN() the nStartElement and nElementsSearched parameters can not be empty if the nSearchColumn parameter is used. They must contain a -1.
ASCAN(aaray,"HELLO", , ,2,15) will return an error where ASCAN(aaray,"HELLO",-1,-1,2,15) will work.

dkreuzen Apr 3, 2013 at 6:10 PM 
There are no references to the ADLLS() function from any of the other DLL functions (ie DECLARE DLL, DISPLAY DLL, etc.).

Cyberfacz Feb 21, 2013 at 1:06 PM 
Gracias por el esfuerzo en realida sigo progrmando en VFP y pienzo continuar haciendolo hasta lo ultimo, mi consulta trata sobre si no hay mas actualizaciones.

amgostick Feb 7, 2012 at 9:00 PM 
Hi Francis,
Still cannot get the new help file working. It loads but when I try to expand "Example" or "Remarks" or "See Also" etc (via the "+" sign), nothing happens. I think something in the browser (IE8) is blocking whatever code does the expanding. Do you know enough about .chm files to know some setting that might unblock this? Thanks. Albert

billand88 Nov 20, 2011 at 8:16 PM 

In case you didn't get my email, you can add SET SYSMENUS and SET BROWSEIMECONTROL to the list of undocumented equivalent names. There are also a bunch of things to potentially add at http://fox.wikis.com/wc.dll?Wiki~CategoryUndocumentedVFPFunctions http://tinyurl.com/8353uon if you like.

Bill Anderson

youngal Nov 9, 2011 at 2:16 PM 
Hi Francis:
Just a quick thank you for your excellent work.

gruperez Jun 12, 2011 at 10:00 AM 
Thank you Francis.

cmanuel May 6, 2011 at 6:25 PM 
Thank you Francis.
I think the vfp-help is better now than it ever has been.
Maybe the best help file I have ever seen... :-)

amgostick May 3, 2011 at 5:37 PM 
After installing ver 1.06, the help file does indeed fire up properly but I can't expand any of the sections that have a "+" control beside them. I checked first that the file was "unblocked" and it was (although when I have seen that before, if it is marked "blocked", you get no content whatsoever showing; in my case, the "basic" content shows but anything inside the "+" control will not open up). Is this somehow controlled by Java or something and my browser is blocking that?

sebae May 3, 2011 at 11:25 AM 
Awesome! Thanks for your hard work, Francis.

Cnopsoft May 3, 2011 at 8:44 AM 
Thanks a lot Francis for keeping VFP alive and kicking ...
Merci beaucoup ! A+

LOGO Mar 4, 2010 at 11:18 AM 
A great and warm thank you for taking on this task to Francis and to all the others involved to get the Sourcefiles from MS into "our" hands. This is the best proof that the Fox is still alive and kicking.

edyshor Mar 9, 2009 at 12:04 PM 
I'm sorry, there was a problem on my machine. In case someone else encounters the same problem it can be fixed by running the nex two line in cmd (Start->run->cmd.exe):
"C:\Program Files\Common Files\Microsoft Shared\VFP\foxhhelp9.exe" /regserver
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\VFP\foxhhelpps9.dll"
Althou i can't figure out how they got unregistered.

edyshor Mar 7, 2009 at 8:56 PM 
Ever sine i replaced the orignal chm file with this one help doens't fire from visual foxpro IDE. I know this is strange but i have no ideea why it doesn't work anymore. It doesn't work F1, nor the "HELP" command. The file is in options -> file locations, set("help") is "On", Set("help",1) is the file, and File(Set("Help",1)) retun .T., but the help doen't work. The path is Home(0). Is somehing broken in this or what ?! I Run WinXP SP3, ad VFP9 SP2 wth PEM Editor and FoxTabs (latest versions). The chm file opens from exporer.

MikePotjer Feb 18, 2009 at 5:56 PM 
This is fantastic! Thank you, Francis. To get a corrected/updated help file only *2 days* after the release of the previous version would have been unthinkable before.

rpeduzzi Feb 17, 2009 at 12:02 PM 
Wow! What a lot of work. Thank you.

Faure Feb 16, 2009 at 9:16 PM 
Dear Toreb,
Ok: Easy to fix. I add in next beta with proposal of Cathy in "Issue tracker"
(note : I test with the original VFP9sp2 help file : it's the same result ;)

toreb Feb 16, 2009 at 6:39 PM 
Great work, Francis, it's really appreciated. But if the helpfile will be further enhanced, I hope that the SQL commands are given some priority. When I enter HELP SELECT, three topics are found, and shown in a menu, but SQL Select is not one of the choices. Enter HELP UPDATE, and you get "Update command, included for backward compatibility....", and not SQL Update which is most relevant. The same is true for Insert, extremely frustrating. And of course DELETE should give a menu to choose between SQL Delete and VFP Delete.