Microsoft KB Archive/894011

= Miscellaneous problems that are fixed by Visual FoxPro 9.0 =

Article ID: 894011

Article Last Modified on 3/2/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 9.0 Professional Edition

-



SUMMARY
This article lists many of the general bugs that are fixed in Microsoft Visual FoxPro 9.0. This list is not at all exhaustive. However, it does highlight fixes in several different product areas.



MORE INFORMATION
 The grid displays records that do not satisfy the SET FILTER condition. The XMLTable.ChildTable property does not work if it does not belong to an XMLAdapter object. View Designer replaces the &quot;LIKE&quot; operator with the &quot;=&quot; operator. You receive an error 1494 error message when the following conditions are true:  A view is opened by using the NODATA clause. The view is refreshed by using the REQUERYfunction. The view preforms a SQL-UNION query with implicit type conversions.</li></ul>

Note The text of the error message is &quot;View definition has been changed.&quot;</li> Visual FoxPro closes unexpectedly when you switch datasessions from a form that has a grid to a session object.</li> The VALID and LOSTFOCUS events of Pages objects on a PageFrame control can be bypassed.</li> A CATCH command to a memory variable that is prefaced with &quot;m.&quot; fails inside a TRY...CATCH structure.</li> If you run a program many times quickly by clicking the ! button on the Standard Toolbar, you receive error messages.</li> The Print dialog box appears behind the desktop when it prints the Clipboard.</li> The Product ID (PID) from Visual FoxPro 8 appears on the Microsoft online support Web site as Visual FoxPro 7. New PIDs are generated for Visual FoxPro 9.0.</li> The PageFrame.Move method incorrectly adjusts the size of the PageFrame control.</li> When you use a member class to add an ActiveX control to a PageFrame control Page that is different from the first page, the ActiveX control appears on the first page.</li> With Themes enabled, if you resize a form in a specific way in the Designer, controls do not redraw on the PageFrame control page.</li> When the BackColor property of a graphical OptionButton control is set to hot tracking, the control appears incorrect on a themed page.</li> The ALINES function trims carriage return-linefeed combination (CRLF)characters if the cParseChar parameter is provided.</li> When you use the SET EVENTLIST TO command, Windows event tracking by using the SYS(2801,2) function is disabled for your Visual FoxPro session.</li> A non-themed, opaque label does not have the correct BackColor property on a themed page.</li> An item that has been added to a ComboBox control is not available to delegate code when the delegate is bound to the Combo.AddItem method by using parameter 1.</li> The INSERT INTO command does not reselect a vacant work area.</li> The INPUTBOX function disables custom menu bars.</li> <li>In a mutiuser scenario with a table buffered grid, you receive an &quot;Index does not match table&quot; error message.</li> <li>When an unexpected failure occurs, the CursorAdapter.CursorFill method unexpectedly closes the recordset that it is trying to attach.</li> <li>You have a grid on a form that has a Partition property set to a value that is 319 or greater. When you run the MODIFY FORM or DO FORM commands on that form, you receive error messages.</li> <li>If you set the AllowCellSelection property to False (.F.), a disabled grid is enabled.</li> <li>If you interactively set the LockColumns property of a grid, the LockColumns_assign method or any other method that is bound to the LockColumns property is not called.</li> <li>If the AllowCellSelection property of a grid is False (.F.), the grid cannot obtain focus if the RecordSource property has no records.</li> <li>You receive the following error message when you publish a Web service:

SCHEMANODE does not evaluate to an object.

</li> <li>The EditBox control does not respect the lead bytes of double-byte characters.</li> <li>The Version(3) function returns enu code (00) when the Vfp8rcht.dll file is loaded as a runtime resource file.</li> <li>The BeforeOpenTable DBC event receives the name of the currently-open table instead of the name of the cursor that is being opened.</li> <li>The Activate DBC event does not occur before the Database Designer window opens on a deactivated database.</li> <li>The CursorAdapter object does not update the back-end if the ODBC driver does not support transactions.</li> <li>The CursorAdapter.ConversionFunc property is not found if the SKIP command is used in the cursor before the TableUpdate function is used.</li> <li>The CREATE SQL VIEW command fails if the SELECT-SQL command includes a literal string that is enclosed into brackets ([ ]) with a single apostrophe ( ' ) inside.</li> <li>If you pass no parameter to the SQLSTRINGCONNECT function, you receive the following error message:

Function argument value, type, or count is invalid.

The expected behavior is to open the Select Data Source window.</li> <li>You can still change a value in a ComboBox control that returns .F. from the When event.</li> <li>When you delete a parameter statement from an inherited method while it is in the class or in Form Designer, the method appears as [Default] in the Properties window.</li> <li>In Visual FoxPro 8, the COPY TO ... FOX2X command converts the Currency field to Float(12,4). In earlier versions of Visual FoxPro, the '''COPY TO ... FOX2X command converted the Currency field to Float(20,4)'''.</li> <li>The Form.SaveAsClass method lets you save a file by using an invalid name.</li> <li>The WAIT WINDOW command does not position the window correctly in a dual or multiple-monitor configuration.</li> <li>If you use the $ operator in a SQL -Select statement, you receive a &quot;SQL: Internal Error&quot; error message. This error message is Visual FoxPro error number 1800.</li> <li>When you press the DOWN ARROW key in a grid, you receive a &quot;Record is out of range&quot; error message. This error message is Visual FoxPro error number 5.</li> <li>The SYS(3054) function does not display the percent sign (&quot;%&quot;) in a string when the function reprints the SQL statement.</li> <li>A stack overflow error occurs when an object and its descendant are both derived from the same class, and the object and its descendant are stored in the same class library.</li> <li>You may use the SCREEN=ON command in the Config.fpw file. When the file is compiled into a DLL or a multithreaded DLL (MTDLL), a fatal exception occurs in Visual FoxPro.</li> <li>The Report Wizard does not display indexes.</li> <li>The value of the _PAGENO system variable is incorrect in a report when the group spans more than one page.</li> <li>The REFRESH command does not update the current record in the local view. The REFRESH command works fine in the remote view.</li> <li>A query returns an incorrect result when you use a temporary index on a nullable field to optimize JOIN evaluation.</li> <li>A query returns an incorrect result when you use a temporary index on a nullable field to optimize JOIN evaluation for a not equal to (!=) condition.</li> <li>You receive a &quot;Variable '...' is not found&quot; error message when you build a project that has an included table and an indexed long field name.</li> <li>The PageFrame.Width and PageFrame.Height properties do not return the current width and height if the TabStretch property is set to 0 (zero).</li> <li>The value of the PageFrame.PageHeight property does not change when rows are added.</li> <li>The PAGE UP, PAGE DOWN, and HOME keys do not raise the Click event in a ListBox control like the arrow keys do.</li> <li>A NULL literal in the Remote View command is replaced with .NULL.. This behavior prevents save or execution.</li> <li>A MODIFY COMMAND command with a short file name erases a file that has a long file name. A short file name may be have eight characters in the name, have three characters in the file name extension, and use the tilde (~) character.</li> <li>The ListBox.InteractiveChange event does not raise when you click a list box item and then move the mouse pointer to another item in same list box.</li> <li>The This_Access method is not called if an object is referenced by using an array element or a collection item.</li> <li>When you try to pass an additional parameter by reference to a procedure or an object method, you receive a &quot;Cannot redefine&quot; error message.</li> <li>When Microsoft ClearType is enabled, a label on a form becomes bolder each time that the form is refreshed.</li> <li>When you use the ISBLANK function in a SQL SELECT command together with an aliased table, you receive an &quot;Object  not found&quot; error message.</li> <li>The BitLShift function causes an integer overflow exception (0xC0000095).</li> <li>You receive an error message when you add a table from the Database Designer to a form if the table has a numeric name.</li> <li>If you click the drop-down portion of a ComboBox control, the click passes through the ComboBox control to the underlying control and then fires the Click event of the underlying control.</li> <li>You receive a &quot;Connectivity internal consistency error&quot; error message when you save a local view if the database name includes a bracket ( [ ) or an apostrophe ('). This error message is Visual FoxPro error number 1522.</li> <li>The WordWrap property of the CommandButton control lets you wrap text. However, you cannot specify a carriage return.</li> <li>The drop-down columns of a ComboBox control are not centered on the screen.</li> <li>The ResetToDefault method of a member property that contains an object reference does not release the object reference.</li> <li>Changes to a buffered cursor disappear in a multilevel transaction.</li> <li>If you call the CDX function with a value of 17, you receive a &quot;Function argument value, type, or count is invalid&quot; error message.</li> <li>The SQL UPDATE command is limited to 128 fields. It should be limited to 255.</li> <li>You receive an &quot;Internal consistency error&quot; error message when a ListBox control is bound to an indexed cursor.</li> <li>You receive an &quot;API call caused an exception error message when you use the CallFn function from the FoxTools.fll library that is included with Visual FoxPro 7 and Visual FoxPro 8. This error message is Visual FoxPro error number 2028.</li></ul>

<div class="references_section">