38209 VFP 9 SP2 Help File

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

38236

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).



Download
Discussions

History:
  • June 12 2014 Version 1.07
All pages:
- Removed: Javascript about Language management
- Page Footer: mention "Enable Javascript for use this Help file" in red, if Javascript isn't enabled.
Added in aLink Keywords:
- ADD OBJECT to "DEFINE CLASS Command - ADD OBJECT Clause"
- IMPLEMENTS to "DEFINE CLASS Command - IMPLEMENTS Clause"
Added in index:
- ADD OBJECT Clause - DEFINE CLASS Command Ticket https://vfpx.codeplex.com/workitem/34583
- IMPLEMENTS Clause - DEFINE CLASS Command
Removed from index:
- "OPEN DATABASE commad" (Duplicate with "OPEN DATABASE Command" and writing mistake "commad")
- "ON KEY LABEL assignment restore" (Linked on "POP KEY Command" and Duplicate with "ON KEY LABEL command"
- "active page" (Duplicate with "Activepage")
- SET CLASSLIB command (Duplicate)
Updated in Index :
- "FIND Command (Visual FoxPro)" -> "FIND Command"
Pages updated:
- "Character Functions"
- TAGNO() Function
- TAG() Function
- SYS(14)
- INDEX Command
- HELP Index Manipulation Language
- DECLARE - DLL Command
- DISPLAY DLLS Command
- LIST DLLS Command
- ASCAN()
- SYS(16)
- SIN( ) Function
- ASIN( ) Function
- COS( ) Function
- ACOS( ) Function
- TAN( ) Function
- ATAN( ) Function
- ATN2( ) Function
- DTOR( ) Function
- RTOD( ) Function
- CDX()
- Backward-Compatible Language Elements
- @ ... CLASS Command
- @ ... CLEAR Command
- @ ... FILL Command
- @ ... SCROLL Command
- System Menu Names
- ANSITOOEM() Function
- OEMTONANSI() Function
- VFPX - Undocumented SET SYSMENUS Command
- VFPX - Undocumented SET BROWSEIMECONTROL Command
- VFPX - page updated
Pages updated with documentation found in FoxPro for Windows 2.6 :
- @ ... BOX Command
- @ ... EDIT - Text Edit Regions Command / @ ... EDIT - Edit Boxes Command
- @ ... GET Command / @ ... GET - Text Boxes Command
- @ ... GET - Check Boxes Command / @ ... GET - Check Boxes Command
- @ ... GET - Invisible Buttons Command / @ ... GET - Transparent Buttons Command
- @ ... GET - Lists Command / @ ... GET - List Boxes Command
- @ ... GET - Popups Command / @ ... GET - Combo Boxes Command
- @ ... GET - Push Buttons Command / @ ... GET - Command Buttons Command
- @ ... GET - Radio Buttons Command / @ ... GET - Option Buttons Command
- @ ... GET - Spinners Command / @ ... GET - Spinners Command
- @ ... MENU Command
- @ ... PROMPT Command
- @ ... SAY Command
- @ ... SAY - BMPs & OLE Objects Command / @ ... SAY - Pictures & OLE Objects Command
- @ ... TO Command
- ACCEPT Command
- ANSITOOEM() Function
- ASSIST Command
- CALL Command
- COL() Function
- CREATE SCREEN Command
- CREATE SCREEN - Quick Screen Command
- DEFINE BOX Command
- FIND Command
- INPUT Command
- INSERT Command
- JOIN Command
- LOAD Command
- MDOWN() Function
- MENU Command
- MENU TO Command
- MODIFY SCREEN Command
- OBJNUM() Function
- OBJVAR() Function
- OEMTOANSI() Function
- ON KEY Command
- ON KEY = Command
- ON READERROR Command
- RDLEVEL() Function
- READ Command
- READ MENU Command
- READKEY() Function
- ROW() Function
- SET BORDER Command
- SET BRSTATUS Command
- SET CLEAR Command
- SET COLOR OF Command
- SET COLOR TO Command
- SET DELIMITERS Command
- SET DISPLAY Command
- SET FORMAT Command
- SET INTENSITY Command
- SET WINDOW OF MEMO Command
- SHOW GET Command
- SHOW GETS Command
- SHOW OBJECT Command
- SYS(18) Current field/object Function / SYS(18) - Current Control
- SYS(20) Transform German text Function
- SYS(2016) SHOW GETS WINDOW Function / SYS(2016) - SHOW GETS WINDOW Name
- SYS(23) EMS memory available Function / SYS(23) - FoxPro EMS Memory Usage
- SYS(24) EMS memory limit Function / SYS(24) - EMS Memory Limit
- UPDATE Command
- UPDATED() Function
- VARREAD() Function
- WREAD() Function
- _ALIGNMENT System Variable
- _ASSIST System Variable
- _BOX System Variable
- _CUROBJ System Variable
- _FOXDOC System Variable
- _GENGRAPH System Variable
- _GENPD System Variable
- _GENSCRN System Variable
- _GENXTAB System Variable
- _INDENT System Variable
- _LMARGIN System Variable
- _PADVANCE System Variable
- _PBPAGE System Variable
- _PCOLNO System Variable
- _PCOPIES System Variable
- _PDRIVER System Variable
- _PDSETUP System Variable
- _PECODE System Variable
- _PEJECT System Variable
- _PEPAGE System Variable
- _PLENGTH System Variable
- _PLINENO System Variable
- _PLOFFSET System Variable
- _PPITCH System Variable
- _PQUALITY System Variable
- _PSCODE System Variable
- _PSPACING System Variable
- _PWAIT System Variable
- _RMARGIN System Variable
- _TABS System Variable
- _TRANSPORT System Variable
- _WRAP System Variable
Removed from TOC / Contents:
- Move "READ Command" -> Backward-Compatible Language Elements
- Move "@ ... CLASS Command" -> Backward-Compatible Language Elements
- Move "@ ... CLEAR Command" -> Backward-Compatible Language Elements
- Move "@ ... FILL Command" -> Backward-Compatible Language Elements
- Move "@ ... SCROLL Command" -> Backward-Compatible Language Elements
- Move "WREAD() Function" -> Backward-Compatible Language Elements
  • 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
- SET DIRECTORY Command
- 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 DATABASE Command
- SET DOHISTORY Command
- 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 DIRECTORY Command
- SET DOHISTORY Command (moved)
- VFPX Topic
- WINDOW( ) Function (Backward-Compatible Language Elements)
Installation :
- Inno Setup: now deletes the "dv_foxhelp.chw" file
  • 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"
HELP DELETE -> "DELETE Command" + "DELETE SQL"
HELP SELECT -> "SELECT Command" + "SELECT SQL"
Added in index (popup list choice):
ComboBox control -> "ComboBox Control Properties, Methods, and Events"
CheckBox control -> "CheckBox Control Properties, Methods, and Events"
  • February 16 2009 Version 1.04
First public Version

Last edited Jul 16 at 12:14 PM by Faure, version 10

Comments

billand88 Jul 2 at 7:17 PM 
Regarding the SET DOHISTORY command, there's more to it. There's also...

SET DOHISTORY TO <Filename> [ADDITIVE]
SET DOHISTORY TO

Even if SET DOHISTORY is set to OFF, setting SET DOHISTORY TO <Filename> [ADDITIVE] will "work". Try the same set of commands in a second version of VFP and you'll get a "File access denied" message. So the setting remains dormant until it is brought to life as explained in the VFPX help text and SET DOHISTORY is set to "ON".

Apparently these clauses have existed since VFP 3.

billand88 Jun 27 at 6:51 PM 
I created a discussion thread on Wednesday (06/25/2014) for possible inclusions into a 1.08 version.

Faure Jun 12 at 3:48 PM 
VFP9SP2 Help File v1.07 is now released (Backward-Compatible Language Elements: updated with documentation found in FoxPro for Windows 2.6)

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

dkreuzen Apr 3, 2013 at 7: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 7: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 2: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 10: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 9:16 PM 
Francis,

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 3:16 PM 
Hi Francis:
Just a quick thank you for your excellent work.

gruperez Jun 12, 2011 at 11:00 AM 
Thank you Francis.
Regards,
gino

cmanuel May 6, 2011 at 7: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 6: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 12:25 PM 
Awesome! Thanks for your hard work, Francis.

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

LOGO Mar 4, 2010 at 12:18 PM 
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 1: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 9: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 6: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 1:02 PM 
Wow! What a lot of work. Thank you.
Rick

Faure Feb 16, 2009 at 10: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 ;)
Regards
Francis

toreb Feb 16, 2009 at 7: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.