Microsoft KB Archive/130815

-

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

When finished, simply hang up. If you have problems receiving a fax, please call (425) 635-3199.

Object Oriented Programming
ITEM ID  ARTICLE TITLE                                         PAGES Q127009 INF: How to Control the Access Order of Objects on a Form 2

Q127844 PRB: Object that Received the Destroy Not Released 1

Q127845 PRB: Property is Ignored Under Program Control 2

Q127848 PRB: RELEASE Command Does Not Release a Form 2

Q128076 INF: How to Reference a Class in Class Hierarchy Generically 1

Q128156 PRB: Invalid Data Type for This Property Error 2

Q128633 INF: How Inheritance Affects PROTECTED Methods and Properties 1

Q128727 INF: How to Copy an Existing Class Without a Subclass 1

Q128995 PRB: Unrecognized Command Verb Error When Instantiate Object 2

Q129281 INF: How to Implement a RELEASE Method 2

Q129424 PRB: Property Not Evaluated When Object Is Created 2

Q129512 INF: How to Programatically List .VCX File's Class Definitions 2

Q129648 INF: Calling a Form as If It Were a Function to Return a Value 2

Q129790 INF: Base Classes Available in Visual FoxPro 2

Q130132 PRB: Instance of Container Class Uses Parent Form Scalemode 3

Q130224 PRB: Cannot Pass an Array Member to a Procedure 2

Q130306 INF: Save/SET/Restore of SET Environment Settings 4

Q130342 PRB: Selecting Cancel Cancels User Code But Not Form Execution 1

Q130406 DOCERR: SHOW(2) Does Not Set Modal Form or Formset to Modeless 1

Q130460 INF: Using a Variable as a Parameter for CreateObject 1

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

Q130833 INF: How to Find If Two Object Variables Refer to One Instance 1

Q130834 INF: Objects Parameters Are Passed by Reference 2

Q131027 INF: How to Encapsulate Data in the Form Builder 6

Q131071 INF: Virtual Functions & Multiple Inheritance in Visual FoxPro 1

Q131095 INF: How to Control the Occurrence of a Default Event 2

Q131357 INF: How to Reference Objects in the Container Hierarchy 2

Q131408 Object Variables Return "(Object)" in Debug Window 1

Q131752 PRB: Form Variable Unknown After Running Form Inside App 2

Q132356 How to Use a Container Object Instead of a Custom Object 2

Q132359 Example of Polymorphism in Visual FoxPro 2

MULTI-USER
ITEM ID  ARTICLE TITLE                                         PAGES Q126870 INF: How Transaction Processing Affects Record Locking 2

Q128205 INF: How to Set Buffering Mode in Visual FoxPro 2

Q128206 PRB: Function Requires Row or Table Buffering Mode 1

Q128719 PRB: "Table or Row Buffering Requires that SET ..." Error 1

Q128772 PRB: Tools Options Does Not Reset Buffering for Current Table 1

Q129643 INF: How Transaction Processing Interacts with TableUpdate 2

Q129756 PRB: REPLACE Causes "Field Rule Has Been Violated" Error 2

Q130237 INF: Duplicating READ NOLOCK Functionality in Visual FoxPro 2

Q130659 PRB: "The database must be opened exclusively" Multiuser Error 2

Q131031 INF: READ NOLOCK Behavior in Visual FoxPro 1

Q131711 INF: Browsing a Table While Using Row Buffering in a Form 1

Q131753 INF: Private Data Sessions Require Additional File Handles 1

Q131888 PRB: Transaction Affects When Rules or Triggers Fire 3

Q133016 PRB: Dynamically Changing Buffering Mode Doesn't Work 2

Tables, Databases, & Indexes
ITEM ID  ARTICLE TITLE                                         PAGES Q127037 INF: Purpose of CHARACTER BINARY and MEMO BINARY Fields 1

Q127795 INF Back-Link Functionality in Visual FoxPro for Windows 1

Q127846 INF: How to Use CANDIDATE Keys 1

Q129098 INF: How to Change a Table's Name 1

Q129168 How to Recover Corrupt DataBase Container Files 1

Q129399 INF: How to Convert FoxPro 3.0 Tables to FoxPro 2.x Format 1

Q129400 INF: FREE TABLE Command Removes Table from Corrupted Database 2

Q129537 PRB: APPEND BLANK Fires Field-Level Validation 2

Q129640 INF: How to Determine What Relations Exist in a .DBC 1

Q130083 PRB: Record Pointer Moves to EOF After INSERT - SQL Fails 2

Q130200 PRB: Deleted Records are Committed with TABLEUPDATE 2

Q130240 INF: How to Use the Caption Field Property 1

Q130244 PRB: All New Field Values Set to .NULL. When You Modify Table 1

Q130299 PRB: CURVAL Returns Same Value as OLDVAL 2

Q130301 PRB: INSERT Command Fails with Buffering and Integrity Rules 1

Q130303 PRB: Default Values Not Checked for Integrity by Visual FoxPro 1

Q130304 INF: How to Create Stored Procedures in Visual FoxPro Programs 1

Q130345 INF: How to Retreive Database Properties in a Program 2

Q130346 INF: How to Manipulate DateTime Fields in a Browse 1

Q130352 INF: How to Remove Table from Persistent Relation with Program 2

Q130455 PRB: Long Variable Names from 2.x Not Found in Visual FoxPro 1

Q130461 New Header Structure for Tables in Visual FoxPro 1

Q130601 INF: How to Create a Primary Index in a Visual FoxPro Program 2

Q130603 INF: How to Use SET PATH to Control Which Table Opens First 2

Q130604 INF: How to Retrieve Table Properties in a Program 3

Q130663 PRB: ZAP Command Ignores Table's Delete Triggers 1

Q130706 PRB: MODIFY STRUCTURE Command Doesn't Set Index Order 3

Q131265 INF: Use Exlamation Mark (!) Notation for Precise Referencing 2

Q132467 Firing Order for Rules and Triggers in Visual FoxPro 3

Q132726 How to Enumerate and Open All Tables in a Database Container 1

SQL
ITEM ID  ARTICLE TITLE                                         PAGES Q128072 INF: How to use SQL Select to Locate NULL Values 1

Q130166 INF: Data Type Mapping in the Upsizing Wizard 2

Q130239 PRB: Changes to SQL Remote View Aren't Saved 1

Q130840 How to Append Records from One Remote View to Another 1

Q133001 PRB: SQL SELECT Statement UDF Executes Twice On First Record 3

CLIENT/SERVER
ITEM ID  ARTICLE TITLE                                         PAGES Q129468 INF: How to Update a Remote Table from a Local Table 2

Q129642 INF: Buffering Must Be Handled Manually in DBC Rules/Triggers 1

Q129647 INF: Using ROLLBACK and END TRANSACTION in Nested Transactions 2

Q130506 INF: Use AERROR in Place of DBERROR for ODBC Errors 2

BROWSE
ITEM ID  ARTICLE TITLE                                         PAGES Q128337 INF: How to Make a Terminating Command Button 1

Q130131 PRB: ON ERROR Not Called When Trigger Fails in Browse or Grid 2

Q130146 INF: How to Create a Scrolling Field in a BROWSE Window 1

Q131599 INF: Record Pointer Moves in BROWSE as Records Are Deleted 1

GRID
ITEM ID  ARTICLE TITLE                                         PAGES Q126839 INF: How to Create Special Effects in a Grid 2

Q127880 INF: How to View Memo Fields as Edit Boxes in a Grid 1

Q129280 INF: How to Change the Color of the Active Cell in a Grid 1

Q130458 INF: How to Highlight the Entire Row in Grid When User Clicks 1

Q130707 How to Use Criteria to Limit Records Displayed in a Grid 1

Q131836 PRB: Grid Not Refreshing Displaying a Cursor From Query 2

Q132549 How to Set the Color and Font of Grid Rows Conditionally 2

Q133002 How the AddColumn Method Computes New ColumnCount Value 1

Q133164 How to Define Multiple-Line Grid Headers 1

OTHER PROGRAMMING ISSUES
ITEM ID  ARTICLE TITLE                                         PAGES Q126780 PRB: Operator/Operand Type Mismatch When Comparing Two Objects 2

Q127179 PRB: Output from TIME Does Not Change with SET HOURS 2

Q127840 INF: Info Provided by the Version Function in Visual FoxPro 1

Q127942 INF: How to Place a Timer in the Main Window 2

Q128074 INF: How to Refer to a Form from a Menu or a Program 1

Q128077 PRB: Can't Use DOCKED or DOCKPOSITION Props to Dock a Toolbar 1

Q128201 INF: How to Put a Null Value in a Field 1

Q128648 INF: How to Create a List Box That Lists Available Fonts 2

Q128769 INF: How to Create a Screen Programatically 2

Q128816 PRB: Cannot Access MAPI Under Win32s 1

Q128973 INF: How To Create a Vertical Caption in Label Control 2

Q128996 INF: How to Assign Database Location Generically in Data Env 2

Q129014 PRB: Converted 2.x Screen Can Not Be Opened in Prior Versions 1

Q129077 INF: How to Use the NODATA and NOREQUERY Clauses of USE 2

Q129097 INF: Displaying Bitmaps Using CENTERED & ISOMETRIC keywords 2

Q129205 INF: How to Add Multiple Properties When You Add Objects 2

Q129208 INF:Pixel Replaces Foxel as Default Scale Value in Design Mode 2

Q129228 PRB: "Syntax Error" When Using the GETDIR Function 1

Q129311 INF: Visual FoxPro Has 3 New SYS Functions Related to Memory 2

Q129314 INF: SCATTER & GATHER Commands Have a New NAME Argument 4

Q129413 INF: Explanation & Usage of the LOCKSCREEN Property 2

Q129641 INF: Alternative to SCATTER and GATHER in the New VFP Model 2

Q129865 INF: Limitations of the AINSTANCE Function 3

Q129977 INF: Recommended Naming Conventions for Visual FoxPro 3

Q130005 INF: How to Use a Custom Class to Encrypt Passwords 3

Q130085 INF: Details of the .VCX File Architecture 3

Q130128 PRB: MOD Function w/ Negative Number May Give Different Answer 1

Q130129 INF: How to Open a Database or Table in Visual FoxPro 2

Q130210 INF: Error Message Parameters Displayed with SYS(2018) 2

Q130236 INF: Explanation of Referential Integrity Rules for INSERT 1

Q130238 PRB: Macro Substitution Won't Work in Expression Builder 1

Q130242 PRB: Error: Index Tag Not Found After DELETE TAG ALL 2

Q130243 INF: How to Create Persistent Relations Using ALTER TABLE SQL 2

Q130277 PRB: WPARENT Gives Error in 3.0 Different from Error in 2.x 1

Q130307 INF: How to Use Null Values in Visual FoxPro 3

Q130343 INF: Reserved Color Schemes in Visual FoxPro Now Include 15 1

Q130350 INF: TYPE Returns "N" for Double, Float, and Integer 1

Q130355 INF: How to Validate Data by Using Customized Error Messages 2

Q130408 INF: How to Create a Wallpaper Effect in Visual FoxPro 1

Q130413 INF: How to Create an Updatable Cursor (View) to Update Table 2

Q130440 INF: Reserved Words in Visual FoxPro 8

Q130442 PRB: RELEASE LIBRARY Results in "API library not found" Error 1

Q130462 INF: Difference Between REQUERY and REFRESH in Visual FoxPro 1

Q130525 PRB: SETFOCUS Doesn't Work When Called in VALID Method 2

Q130544 INF: How to Place Values Containing Commas in a Combo Box 1

Q130577 PRB: Leading Equals Sign (=) Not Displayed If RowSource Value 2

Q130657 INF: How to Change the Font of Menu Items 1

Q130665 PRB: " is not an array" Error When Creating Array 1

Q130992 PRB: GETFILE Caption Limited to 9 Characters in Windows 95 1

Q131003 PRB: Setting DECIMALS to 15 or More Produces Incorrect Result 1

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

Q131121 INF: Combo Box with RowSourceType of SQL Must Result in Cursor 1

Q131133 INF: How to Create and Access Protected Properties 1

Q131146 PRB: CLEAR ALL in Cleanup Code of FoxPro 2.6 Form Causes Error 1

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

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

Q131306 INF: Transferring Data Between General Fields Programmatically 1

Q131345 INF: Using the DISPLAY OBJECTS Command 2

Q131348 PRB: SET STEP ON Opens the TRACE Window Only 1

Q131465 PRB: Cannot Use LOCAL Variables as Arrays 1

Q131475 INF: Use #INCLUDE to Add Header Files to a Visual FoxPro Proj 3

Q131549 INF: Use Place-Holder Commas in Calls with Missing Parameters 2

Q131600 INF: How to Customize RightClick Behavior 2

Q131837 How to Return from an Event or Method 1

Q131838 How OptionGroup Buttons Behave 2

Q132179 PRB: Controls in a Page Frame Are Not Refreshed 2

Q132295 How to Change the Attributes of a Visual FoxPro Window 1

Q132677 How to Place Insertion Point at Far Left of Field on Entry 1

Q132697 PRB: Application Appears Then Exits to Operating System 2

Q133357 INF: Differences Between Temporary and Permanent Relationships 2

Additional query words: VFoxMac VFoxWin kblist kbtlc

Keywords         : FxotherReference Version          : MACINTOSH:3.0b; WINDOWS:3.0 Platform         : MACINTOSH WINDOWS Issue type       : Last Reviewed: July 27, 1999