KB List: Programming, Including OOP & Multiuser

3.00    | 3.00b

The information in this article applies to:

• Microsoft Visual FoxPro for Windows, version 3.0
• Microsoft Visual FoxPro for Macintosh, version 3.0b

Instructions

Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch- tone telephone. To order items from this catalog, first select the items you want to receive, noting the five- to six-digit number of the Item ID shown below for each item, and then:

• Dial the toll-free FastTips for Development Tools number (800) 936-4300.
• Press six (6) on your phone keypad to select Microsoft FoxPro.
• Press one (1) to select Microsoft Visual FoxPro and other FoxPro for Windows versions.
• Press one (1) to select Microsoft Visual FoxPro.
• Press one (1) to order an item from the FastTips Catalog.
• Press one (1) to select fax as your delivery method.
• When prompted, enter the number of the Item ID and press #, for up to five items.
• When prompted, enter your three-digit area code and seven-digit fax number, and then press #.
• To add personal ID (such as your name) to the fax sheet, press 1, otherwise, press *.

Article Listing

Object Oriented Programming

ITEM ID  ARTICLE TITLE                                               PAGES

Q 127009 INF: How to Control the Access Order of Objects on a Form       2
Q 127844 PRB: Object that Received the Destroy Not Released              1
Q 127845 PRB: Property is Ignored Under Program Control                  2
Q 127848 PRB: RELEASE Command Does Not Release a Form                    2
Q 128076 INF: How to Reference a Class in Class Hierarchy Generically    1

Q 128156 PRB: Invalid Data Type for This Property Error                  2
Q 128633 INF: How Inheritance Affects PROTECTED Methods and Properties   1
Q 128727 INF: How to Copy an Existing Class Without a Subclass           1
Q 128995 PRB: Unrecognized Command Verb Error When Instantiate Object    2
Q 129281 INF: How to Implement a RELEASE Method                          2

Q 129424 PRB: Property Not Evaluated When Object Is Created              2

Q 129790 INF: Base Classes Available in Visual FoxPro                    2
Q 130132 PRB: Instance of Container Class Uses Parent Form Scalemode     3

Q 130224 PRB: Cannot Pass an Array Member to a Procedure                 2
Q 130306 INF: Save/SET/Restore of SET Environment Settings               4

Q 130460 INF: Using a Variable as a Parameter for CreateObject()         1

Q 130526 INF: How to Use the ON ERROR Command and the Error Event        2

Q 130834 INF: Objects Parameters Are Passed by Reference                 2
Q 131027 INF: How to Encapsulate Data in the Form Builder                6

Q 131095 INF: How to Control the Occurrence of a Default Event           2
Q 131357 INF: How to Reference Objects in the Container Hierarchy        2
Q 131408 Object Variables Return "(Object)" in Debug Window              1
Q 131752 PRB: Form Variable Unknown After Running Form Inside App        2
Q 132356 How to Use a Container Object Instead of a Custom Object        2

Q 132359 Example of Polymorphism in Visual FoxPro                        2

MULTI-USER

Item Id  Article Title                                               Pages

Q 126870 INF: How Transaction Processing Affects Record Locking          2
Q 128205 INF: How to Set Buffering Mode in Visual FoxPro                 2
Q 128206 PRB: Function Requires Row or Table Buffering Mode              1
Q 128719 PRB: "Table or Row Buffering Requires that SET ..." Error       1
Q 128772 PRB: Tools Options Does Not Reset Buffering for Current Table   1

Q 129643 INF: How Transaction Processing Interacts with TableUpdate      2
Q 129756 PRB: REPLACE Causes "Field Rule Has Been Violated" Error        2
Q 130237 INF: Duplicating READ NOLOCK Functionality in Visual FoxPro     2

Q 131031 INF: READ NOLOCK Behavior in Visual FoxPro                      1

Q 131711 INF: Browsing a Table While Using Row Buffering in a Form       1
Q 131753 INF: Private Data Sessions Require Additional File Handles      1
Q 131888 PRB: Transaction Affects When Rules or Triggers Fire            3
Q 133016 PRB: Dynamically Changing Buffering Mode Doesn't Work           2

Tables, Databases, & Indexes

ITEM ID  ARTICLE TITLE                                               PAGES

Q 127037 INF: Purpose of CHARACTER BINARY and MEMO BINARY Fields         1
Q 127795 INF Back-Link Functionality in Visual FoxPro for Windows        1
Q 127846 INF: How to Use CANDIDATE Keys                                  1
Q 129098 INF: How to Change a Table's Name                               1
Q 129168 How to Recover Corrupt DataBase Container Files                 1

Q 129399 INF: How to Convert FoxPro 3.0 Tables to FoxPro 2.x Format      1
Q 129400 INF: FREE TABLE Command Removes Table from Corrupted Database   2
Q 129537 PRB: APPEND BLANK Fires Field-Level Validation                  2
Q 129640 INF: How to Determine What Relations Exist in a .DBC            1
Q 130083 PRB: Record Pointer Moves to EOF After INSERT - SQL Fails       2

Q 130200 PRB: Deleted Records are Committed with TABLEUPDATE             2
Q 130240 INF: How to Use the Caption Field Property                      1
Q 130244 PRB: All New Field Values Set to .NULL. When You Modify Table   1
Q 130299 PRB: CURVAL() Returns Same Value as OLDVAL()                    2
Q 130301 PRB: INSERT Command Fails with Buffering and Integrity Rules    1

Q 130345 INF: How to Retreive Database Properties in a Program           2
Q 130346 INF: How to Manipulate DateTime Fields in a Browse              1

Q 130455 PRB: Long Variable Names from 2.x Not Found in Visual FoxPro    1
Q 130461 New Header Structure for Tables in Visual FoxPro                1
Q 130601 INF: How to Create a Primary Index in a Visual FoxPro Program   2
Q 130603 INF: How to Use SET PATH to Control Which Table Opens First     2
Q 130604 INF: How to Retrieve Table Properties in a Program              3

Q 130663 PRB: ZAP Command Ignores Table's Delete Triggers                1
Q 130706 PRB: MODIFY STRUCTURE Command Doesn't Set Index Order           3
Q 131265 INF: Use Exlamation Mark (!) Notation for Precise Referencing   2
Q 132467 Firing Order for Rules and Triggers in Visual FoxPro            3
Q 132726 How to Enumerate and Open All Tables in a Database Container    1

SQL
---

Item Id  Article Title                                               Pages

Q 128072 INF: How to use SQL Select to Locate NULL Values                1
Q 130166 INF: Data Type Mapping in the Upsizing Wizard                   2
Q 130239 PRB: Changes to SQL Remote View Aren't Saved                    1
Q 130840 How to Append Records from One Remote View to Another           1
Q 133001 PRB: SQL SELECT Statement UDF Executes Twice On First Record    3

CLIENT/SERVER

Item Id  Article Title                                               Pages

Q 129468 INF: How to Update a Remote Table from a Local Table            2
Q 129642 INF: Buffering Must Be Handled Manually in DBC Rules/Triggers   1

Q 130506 INF: Use AERROR() in Place of DBERROR() for ODBC Errors         2

BROWSE

Item Id  Article Title                                               Pages

Q 128337 INF: How to Make a Terminating Command Button                   1
Q 130131 PRB: ON ERROR Not Called When Trigger Fails in Browse or Grid   2
Q 130146 INF: How to Create a Scrolling Field in a BROWSE Window         1
Q 131599 INF: Record Pointer Moves in BROWSE as Records Are Deleted      1

GRID
----

Item Id  Article Title                                               Pages

Q 126839 INF: How to Create Special Effects in a Grid                    2
Q 127880 INF: How to View Memo Fields as Edit Boxes in a Grid            1
Q 129280 INF: How to Change the Color of the Active Cell in a Grid       1
Q 130458 INF: How to Highlight the Entire Row in Grid When User Clicks   1
Q 130707 How to Use Criteria to Limit Records Displayed in a Grid        1

Q 131836 PRB: Grid Not Refreshing Displaying a Cursor From Query         2
Q 132549 How to Set the Color and Font of Grid Rows Conditionally        2
Q 133002 How the AddColumn Method Computes New ColumnCount Value         1
Q 133164 How to Define Multiple-Line Grid Headers                        1

OTHER PROGRAMMING ISSUES

Item Id  Article Title                                               Pages

Q 127179 PRB: Output from TIME() Does Not Change with SET HOURS          2
Q 127840 INF: Info Provided by the Version() Function in Visual FoxPro   1
Q 127942 INF: How to Place a Timer in the Main Window                    2
Q 128074 INF: How to Refer to a Form from a Menu or a Program            1

Q 128077 PRB: Can't Use DOCKED or DOCKPOSITION Props to Dock a Toolbar   1
Q 128201 INF: How to Put a Null Value in a Field                         1
Q 128648 INF: How to Create a List Box That Lists Available Fonts        2
Q 128769 INF: How to Create a Screen Programatically                     2
Q 128816 PRB: Cannot Access MAPI Under Win32s                            1

Q 128973 INF: How To Create a Vertical Caption in Label Control          2
Q 128996 INF: How to Assign Database Location Generically in Data Env    2
Q 129014 PRB: Converted 2.x Screen Can Not Be Opened in Prior Versions   1
Q 129077 INF: How to Use the NODATA and NOREQUERY Clauses of USE         2
Q 129097 INF: Displaying Bitmaps Using CENTERED & ISOMETRIC keywords     2

Q 129205 INF: How to Add Multiple Properties When You Add Objects        2

Q 129228 PRB: "Syntax Error" When Using the GETDIR() Function            1
Q 129311 INF: Visual FoxPro Has 3 New SYS Functions Related to Memory    2
Q 129314 INF: SCATTER & GATHER Commands Have a New NAME Argument         4

Q 129413 INF: Explanation & Usage of the LOCKSCREEN Property             2
Q 129641 INF: Alternative to SCATTER and GATHER in the New VFP Model     2
Q 129865 INF: Limitations of the AINSTANCE Function                      3
Q 129977 INF: Recommended Naming Conventions for Visual FoxPro           3
Q 130005 INF: How to Use a Custom Class to Encrypt Passwords             3

Q 130085 INF: Details of the .VCX File Architecture                      3

Q 130129 INF: How to Open a Database or Table in Visual FoxPro           2
Q 130210 INF: Error Message Parameters Displayed with SYS(2018)          2
Q 130236 INF: Explanation of Referential Integrity Rules for INSERT      1

Q 130238 PRB: Macro Substitution Won't Work in Expression Builder        1
Q 130242 PRB: Error: Index Tag Not Found After DELETE TAG ALL            2
Q 130243 INF: How to Create Persistent Relations Using ALTER TABLE SQL   2
Q 130277 PRB: WPARENT() Gives Error in 3.0 Different from Error in 2.x   1
Q 130307 INF: How to Use Null Values in Visual FoxPro                    3

Q 130343 INF: Reserved Color Schemes in Visual FoxPro Now Include 15     1
Q 130350 INF: TYPE() Returns "N" for Double, Float, and Integer          1
Q 130355 INF: How to Validate Data by Using Customized Error Messages    2
Q 130408 INF: How to Create a Wallpaper Effect in Visual FoxPro          1
Q 130413 INF: How to Create an Updatable Cursor (View) to Update Table   2

Q 130440 INF: Reserved Words in Visual FoxPro                            8
Q 130442 PRB: RELEASE LIBRARY Results in "API library not found" Error   1
Q 130462 INF: Difference Between REQUERY and REFRESH in Visual FoxPro    1
Q 130525 PRB: SETFOCUS Doesn't Work When Called in VALID Method          2
Q 130544 INF: How to Place Values Containing Commas in a Combo Box       1

Q 130577 PRB: Leading Equals Sign (=) Not Displayed If RowSource Value   2
Q 130657 INF: How to Change the Font of Menu Items                       1
Q 130665 PRB: "<arrayname> is not an array" Error When Creating Array    1
Q 130992 PRB: GETFILE() Caption Limited to 9 Characters in Windows 95    1
Q 131003 PRB: Setting DECIMALS to 15 or More Produces Incorrect Result   1

Q 131017 INF: How to Use Data Sessions in a Toolbar to Show Changes      2

Q 131133 INF: How to Create and Access Protected Properties              1

Q 131289 INF: How to Add to the System Menu as Visual FoxPro Starts      1

Q 131300 PRB: Clicking a Disabled Item in a List Box Selects It          2

Q 131345 INF: Using the DISPLAY OBJECTS Command                          2
Q 131348 PRB: SET STEP ON Opens the TRACE Window Only                    1
Q 131465 PRB: Cannot Use LOCAL Variables as Arrays                       1

Q 131475 INF: Use #INCLUDE to Add Header Files to a Visual FoxPro Proj   3
Q 131549 INF: Use Place-Holder Commas in Calls with Missing Parameters   2
Q 131600 INF: How to Customize RightClick Behavior                       2
Q 131837 How to Return from an Event or Method                           1
Q 131838 How OptionGroup Buttons Behave                                  2

Q 132179 PRB: Controls in a Page Frame Are Not Refreshed                 2
Q 132295 How to Change the Attributes of a Visual FoxPro Window          1
Q 132677 How to Place Insertion Point at Far Left of Field on Entry      1
Q 132697 PRB: Application Appears Then Exits to Operating System         2