Microsoft Visual FoxPro 9.0 Service Pack 1 Fix List |
Control and Classes |
---|
Olecontrol unable to use mouse to get focus to other controls from DHTML control |
Wizard–generated forms fail when you try to add a record if the underlying table has AutoInc field(s) |
Web Browser control: implementing DWebBrowserEvents2 causes parameter count mismatch |
Saving form to an in–use file causes eventual fatal exception |
Fatal exception building project containing VCX with properties separated by only carriage returns |
Collections – removing items from collection with >=500 items crashes VFP under application verifier |
CursorAdapter – TABLEUPDATE(0) ignores SendUpdate setting for table buffered cursor |
Textbox – C0000005 exception with AutoComplete textbox where textbox has ControlSource set to a field which allows NULLs |
Combobox – "Data type mismatch" error setting value in dropdown when controlsource is null member property |
Fatal exception error with MODI FORM command when MSXML3.dll not registered |
Wizards – SEARCH function in a Wizard–generated form does not take new VFP9 data types into account, doesn't find varchar data |
Control class doesn't resize anchored controls within itself |
QUIT fired in DESTROY of form does not close FoxPro or application |
Converted form's READ gets released in 9.0, but not in earlier versions of VFP |
Grid loses data when selected alias is changed from one populating grid to alias of same table used again, and a CALCULATE command is used against 2nd alias |
C0000005 exception pressing ENTER key when listbox ListIndex = 0 |
Unexpected Anchor behavior for values 256/512 and odd Width/Height |
Form – Internal Consistency error then fatal exception editing form after adding relation to dataenvironment of form using aselobj() reference |
IMPLEMENTS failed with Word.Application object with Office 2003 |
Grid – AccountMate – Grid goes blank when custom method of parent formset is set as ControlSource of a grid column |
ActiveX Controls – LeadTools ActiveX control makes 2 empty bars appear in Window menu |
Checkbox – Graphical checkbox and option button do not appear with darker backcolor when depressed with themes enabled |
C0000005 exception working with a class library stored in hidden folder |
Combobox – DownClick() does not fire unless user first passes mouse over contents of dropdown list |
Pageframe w/ TabStretch=0 (multiple), many tabs – keeps growing when form is opened for edit |
Add support for adVarNumeric for ADO data source |
Form – Refresh problems on PageFrame in FormSet causes "ghosting" of a TextBox |
Form – Refresh issues in VFP9 only with various controls on a form when .EXE is run over network (UNC or mapped drive). No refresh issues at all when .EXE is run locally |
Active Accessibility – Value for dropdown list style combobox does not appear in Accessible Event Viewer |
Form – Orphaned form DataEnvironment causes VFP to crash when exited |
Crash when Ctrl–Tab off disabled page on pageframe |
A formset object exhibits memory corruption of user properties the second time it is run after a CLEAR ALL |
Form – Internal Consistency Error modifying or running a form with object having invalid Zorder setting |
Toolbar not active with Modal Form inside Top Level Form |
Grid – "Data type mismatch" (Error 9) editing a DOUBLE field via grid or browse |
Top Level forms with contained modal form should be resizable, movable |
Grid – Fatal exception setting value property in init of control in grid column |
Form Designer – Fatal exception clicking relation in data environment window with persistent relation on compound index key |
CursorAdapter – base table names are converted to lower case in auto–generated SQL |
Textbox – Fatal exception in bound autocomplete textbox if form uses private datasession |
Editbox wordwrap causes blank lines to disappear |
Engine |
---|
Data engine no longer optimizes some queries involving DELETED() function and OR clauses |
Indexes on STR() are not Rushmore optimized with SET ANSI OFF |
TOP N in subquery (new feature) is ignored when UNION is used |
Memo values aren't translated when copied between tables with different code pages (SQL SELECT, APPEND FROM) |
Fatal exception with REPLACE with undefined variable if row validation rule is present |
Hang occurs when UNLOCK is executed |
C0000005 exception accessing free table in transaction if table made transactable in different data session |
Requery() on prepared remote view fails |
LOCATE fails to find a match when index on Currency is used for optimization and the right part of comparison is certain Numeric value |
USE command can assign duplicate alias for the work area |
Unexpected error "Table has a file length / record count inconsistency." on END TRANSACTION |
Unexpected "SQL expression is too complex." error on CREATE SQL VIEW against large tables |
Reopening or FLUSH of table after ZAP with SET TABLEVALIDATE >= 8 causes "Table ... has become corrupted" error |
SQL SELECT returns incorrect result when correlated sub–query returning COUNT(*) is compared with 0 |
Data corruption when CursorAdapter bound to Grid is updated within a TRANSACTION |
Unexpected "SQL: Error correlating fields." error with two EXISTS subqueries |
Correlation is not verified to meet "correlation is supported only to immediate parent query" limit |
Unexpected "Subquery returned more than one record." error when aggregate is used in HAVING, but not in SELECT list |
Query returns incorrect result when ORDER BY+TOP N evaluation is merged with GROUP BY evaluation and TOP is optimized |
SELECT COUNT(ICASE(.T.,1)) returns incorrect result |
SELECT INTO ARRAY changes current work area if it uses sub–query in FROM |
Index on table buffered cursor is corrupted after REPLACE with scope |
A Query with OUTER JOIN produces incorrect result if NOT EMPTY(...) is used in WHERE |
Unexpected "SQL expression is too complex." error with correlated subquery |
"Microsoft Visual C++ Runtime Library Buffer overrun detected!" and C0000005 exception running SCAN loop against very large table |
CAST() to date of a blank datetime field returns datetime type |
ALTER TABLE ... ALTER COLUMN to change character field to integer also changes value |
"Error building key for index..." error when indexing using str() on a NULL value |
Fatal exception on REQUERY() after tableupdate() to remote view with batchupdatecount = –1 and table buffering |
Fatal exception on SQL SELECT when record size * record count is very high |
Enable optimization for tables with non–current code page when ENGINEBEHAVIOR < 90 |
C0000005 exception when indexing with a nested collection filter |
Filter condition that temporarily changes current work area may break relation, or break nested XML generation with XMLAdapter |
Query processor fails to find column in SELECT list if it is enclosed in parenthesis, reports false "SQL: ORDER BY clause is invalid." error |
Unexpected "SQL: GROUP BY clause is missing or invalid." error trying to create a view or USE view with NODATA |
Query produces incorrect result when ENGINEBEHAVIOR < 90, sub–query returns Aggregate function and no records match sub–query's WHERE condition |
COPY TO ... AS nCodepage fails to encode memo with correct codepage, uses CPCURRENT() instead |
Memo values aren't translated when copied from tables with current code page to a table with different code page (COPY TO, SQL SELECT, APPEND FROM) |
SELECT ... WITH BUFFERING unexpectedly pulls buffered data from a cursor, which wasn't explicitly referenced in the FROM clause |
IDE |
---|
Project Manager – Fatal exception building application which uses icon which is still in memory |
Properties Window – Fatal exception closing Zoom window with Enter key under App Verifier with SET KEYCOMP TO DOS |
"Menu manager internal consistency error." crash issuing CLEAR POPUPS |
Prompt for saving query references tmp file |
Tooltips appear in right monitor running VFP in left monitor in multi monitor setup where primary monitor is on right |
C0000005 error in the View Designer with long expression |
Project Manager – Fatal Exception changing font on Project Manager after Dock/Undock operation |
Project Manager – New Project Managers do not remember their positions when "Override Individual Settings" is selected for the "Projects" type on the IDE Tab of the Options Dialog |
RI builder uses incorrect syntax for UNLOCK command |
Picbtns class of Wizbtns.vcx displays warnings when used the CursorAdapter |
Project Manager – VFP hangs rebuilding app after error that classlib is in use |
Access violation C0000005 activating Intellisense in the Program Editor |
IntelliSense – C0000005 Access Violation exiting Class Designer after failed attempt to access LPARAMETER Intellisense for member method |
Fatal exception when debugging a large code file |
Builders – MemberData Editor – Code bug in GetHierarchy() of MemberDataEditor.SCX causes MemberData Editor to get hierarchy wrong |
Properties Window – C0000005 exception closing Class Designer with CursorAdapter, XMLAdapter, XMLTable and XMLField after hitting ESC on a property with value over 255 characters long |
Editor – 100% CPU usage hang using Expression Builder from code editor window which contains nothing but two blank lines |
IntelliSense – Fatal exception in List Members after creating early binding mapi.session object with CreateObjectex() |
"Browse table is closed" error message followed by unhandled exception (c05) when messing with Resource file during table browse |
On CHS Platform, reducing the width of a textbox which contains dbcs string will cause IDE to hang |
On CHS, fatal exception when executing program |
Resizing Project Manager does not update treeview of files |
Option Button Sample in Solution Samples throws DATATYPE MISMATCH error |
Component Gallery – "Error building key for index" selecting "Clean Up" from context menu |
Builders – Problems with Properties dialogs in ReportBuilder.app |
"Printer is not ready" printing to EMF–Citrix printer driver inside Citrix client session to Metaframe 4.0 Presentation Server. Other apps can print to this printer fine |
Error "'local thisview' is not allowed in the view script or is in the wrong place" in View Designer |
Make ReportBuilder.App localizable |
Language |
---|
SQLEXEC() function allows reentrance for the same connection handle |
DEBUGOUT outputs binary data as strings |
CursorToXML() and XMLAdapter don't output seconds for xsd:dateTime values if SET SECONDS is OFF |
C0000005 followed by "Mismatched pushjmp/popjmp call." executing program from "do <program.prg>" on Program Editor context menu when followed by call to EXESCRIPT() |
WEXIST() finds ToolTipText windows |
Memory leak setting ActiveConnection property of ADO RecordSet object to NULL |
Internal Consistency Error followed by crash of VFP calling methods of object returned with GetObject("IIS://LocalHost/W3SVC/1") |
XMLToCursor() and XMLAdapter fail to load values of type xsd:date if time portion is present |
SQLCOLUMNS() fails with complex names if at least one part of the name contains a space or other "illegal" character |
ADIR returns invalid file size for >2gig files (virtual PCs) |
GETOBJECT() has parameter limit based on file spec (261 chars) |
String optimization for recursion produces erroneous results |
Literal number causes BINTOC() errors |
Converting Bintoc to Character using CTOBIN() throws junk value |
OLEDB Provider |
---|
OLEDB Provider – SYS(3050) should default to 128 MB in provider |
OLEDB Provider – Apparent memory leak leads to connectivity error "could not convert the data value..." with repeated openrowset or openquery to SQL linked server |
Unable to create dataset via the VFP OLEDB Provider |
GetSchema(string, string[]) failed to filter based on INDEX_NAME |
OLE DB Provider – Enable SYS(3055) inside provider |
VFPOLEDB improperly handles binary parameters |
DELETE VIEW and DELETE PROCEDURE |
DBSCHEMA_PROCEDURES rowset returns obsolete procedures |
DBSCHEMA_PROCEDURES rowset returns incomplete procedure definition |
APPEND PROCEDURES ignores compilation errors in procedures |
When accessing DBC which has no tables you may see overrun |
Reporting |
---|
Report Builder dialogs should respect regional settings |
Report Preview has incorrect title in some cases |
Report Preview – Different Print Preview Toolbar is opened when object assisted report is previewed than is opened when "Toolbar" is selected from Report Preview surface context menu |
Report Output – HTML Listener – Object on report that is set to "Scale Contents, retain shape" appears differently between report preview and in an .HTM gen'ed by an HTMLListener |
Multidetail bands don't work correctly when 'Start on new page' is on |
Report Preview – "Go To Page" dialog opens out of visible range in when Preview Container TopForm property is .T. and windowstate is NORMAL |
Object Assisted Report Preview – New–style Report Preview Toolbar inaccessible when report is previewed in SDI form without NOWAIT clause on REPORT FORM command |
Report Builder App – Open code window gets filled with garbage characters when one tries to close Report Designer and answers "NO" to "Do you want to save changes to <proc>?" prompt |
Report Designer – Data Grouping limit for a report is listed as 74 in the help topic ""How to: Add Data Groups to Reports", but ReportBuilder.app limits you to 20 |
ReportBuilder.app – Justification for numeric format is "Left justify". This differs from previous VFP versions and default Report Designer |
Report Builder – No error is given closing "Report Properties" dialog after setting "Initial Value" of a Report Variable to an invalid value |
Report Previewer – Report Expression dialog for field with error not displayed after preview error with while REPORTBEHAVIOR = 90 |
Calculated values in report detail header reset unexpectedly when 'reprint detail header' option is on |
ReportListener AdjustObjectSize and MaxHeightAvailable Properties do not work with floating objects |
Previewing a report with an image located on the disk causes a GDI handle leak each time the preview is refreshed |
REPORT PREVIEW GDI handles limitation with many pages |
Bug with Associated header and footer report option– Sequential numbers do not print across pages |
ReportListener.OutputPage to HDC uses 96 DPI instead of printer DPI |
Error "Property WindowState does not exist in line 325 of ResourceManager::SaveWindowState() |
Multiselect dialog allows setting of protection flags, even when report is PROTECTED |
You are prompted for frx if switching from "load from FRX" to "link to Class" |
After cancelling from the first GETFILE(FRX) prompt, you get prompted with GETFILE again |
Report Preview blows away m.oForm if it is previously declared outside the preview |
Programs should respect "real" screen DPI at runtime, rather than the design–time 96 DPI |
Various errors when loading a dataenvironment from a class with specific attributes |
The full path of the linked DE class library is written into the linking code. This is not always appropriate |
Properties of preview form not being saved to resource file correctly under some circumstances |
You can easily get the error "Unknown member .cmdPrint" if you've selected AllowPrintFromPreview = .F. |
Not all vars in FRXOUTPUT.PRG had "m." |
Enhance app to be smarter about unknown output type, if a valid listener reference is passed |
Pervasive fix: check for "m." in all methods and #DEFINEs that include expressions |
Filebased listeners derived from XmlListener that used its ApplyUserXSLT property could not specify directory–only for TargetFileName |
Report Preview context menu can no longer be displayed by the Shift–F10 key once the "Go To Page" dialog has been displayed |
Report band size does not change properly with floating objects that stretch |
C0000005 exception during report print preview with corrupt EXPR field in frx file |
Enhance reportoutput.app to handle unknown output type if a valid listener reference is passed |
Runtime and COM |
---|
Runtime – Toolbar or Status Bar not visible in app run on Win98 SE |
COM object returning array loses array type |
Error "The procedure entry point GetLongPathNameA could not be located in the dynamic link library KERNEL32.dll" in runtime on NT4 |
Memory leak with IMPLEMENTS, COM servers |
Invalid COM parameter passing with unsigned long and unsigned int types |
COM Servers – Deadlock in REMClearConnect and csCritSectionEnter when COM+ recycles dllhost worker process |
On VB6 COM Server, Date type does not work |
OCXAPI cannot be initialized for early binding objects |
Passing large array >65000 gives error |