Visual FoxPro 9.0 articles, fixes and updates - February 2007

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Visual FoxPro 9.0 that have been released in February 2007. The list is daily updated.

• 317466 How to remove buttons from the Print Preview toolbar Q317466 KB317466 February 12, 2007
• 315124 How to use the Winsock ActiveX control with Visual FoxPro Q315124 KB315124 February 12, 2007
• 306079 PRB: SET PROCEDURE TO causes unknown error with FoxPro DLL Q306079 KB306079 February 12, 2007
• 268906 How to add the filter condition to the JOIN clause in a SELECT-SQL command in Visual FoxPro Q268906 KB268906 February 12, 2007
• 262572 BUG: The formset from a functional conversion closes unexpectedly in Visual FoxPro Q262572 KB262572 February 12, 2007
• 260526 No data is returned in Visual FoxPro when you use the TOP clause to retrieve data from a table in SQL Server 7.0 or in SQL Server 2000 Q260526 KB260526 February 12, 2007
• 260405 How to import table structures and data from Microsoft Access to Visual FoxPro Q260405 KB260405 February 12, 2007
• 259933 Use an MSChart control with Visual FoxPro Q259933 KB259933 February 12, 2007
• 259296 How to display a progress bar in the status bar in Visual FoxPro 9.0 and earlier versions Q259296 KB259296 February 12, 2007
• 253886 An ODBC error may occur when you update the DateTime data in Microsoft SQL Server 7.0 or later versions and in Visual FoxPro Q253886 KB253886 February 12, 2007
• 251236 How to programmatically set the number of copies for a report Q251236 KB251236 February 12, 2007
• 248608 How to determine SELECT-SQL optimization levels to affect performance in Visual FoxPro 6.0 and later versions Q248608 KB248608 February 12, 2007
• 245714 You cannot insert more than 250 KB of data in a SQL Server 7.0 or SQL Server 2000 Image field from Visual FoxPro Q245714 KB245714 February 12, 2007
• 243053 How to create an application role on SQL Server 2000 from within Visual FoxPro Q243053 KB243053 February 12, 2007
• 238518 The SELECT-SQL statement that uses an OUTER JOIN clause adds NULL values to the output in Visual FoxPro Q238518 KB238518 February 12, 2007
• 231894 How to update a SQL Server text field through a SQL Server view by using a remote view in Visual FoxPro 6.0 SP3 and later versions Q231894 KB231894 February 12, 2007
• 224525 After you use the SQL Server Upsizing Wizard, fields that are mapped to Char fields and to VarChar fields are padded with spaces to the end of the field in Visual FoxPro Q224525 KB224525 February 12, 2007
• 220157 The GETPRINTERS() function behaves differently based on the operating system in Visual FoxPro 5.0 and later versions Q220157 KB220157 February 12, 2007
• 195537 How to copy table structures and data from SQL Server into Visual FoxPro tables Q195537 KB195537 February 12, 2007
• 193304 The status bar displays the currently selected object in designers Q193304 KB193304 February 12, 2007
• 191639 You receive an error message when the REPORT FORM command is used in a Visual FoxPro COM DLL Q191639 KB191639 February 12, 2007
• 190069 How to show a Print Preview window as MDI child of Top-Level form Q190069 KB190069 February 12, 2007
• 188887 How to display the Print Preview window in a top-level form in Visual FoxPro Q188887 KB188887 February 12, 2007
• 186920 How to change the Report Designer ruler measurement Q186920 KB186920 February 12, 2007
• 186087 Various differences may appear when you view the information in a Word document that is embedded in a Visual FoxPro General field Q186087 KB186087 February 12, 2007
• 180901 How to create a categorized table in Word 97 or in Office Word 2003 from Visual FoxPro for Windows 5.0 and later versions Q180901 KB180901 February 12, 2007
• 178384 The report preview in a top-level form disables the system menu and the command window in Visual FoxPro Q178384 KB178384 February 12, 2007
• 176483 Computers that have lots of RAM installed seem to more slowly process data in Visual FoxPro Q176483 KB176483 February 12, 2007
• 168527 How to simulate a detail band that is longer than the length of one page in Visual FoxPro Q168527 KB168527 February 12, 2007
• 163030 The Report Wizard can generate detail bands that are too large in Visual FoxPro Q163030 KB163030 February 12, 2007
• 157947 How to create a report that is based on a query in Visual FoxPro Q157947 KB157947 February 12, 2007
• 157425 BUG: Quick report mixes detail and header bands Q157425 KB157425 February 12, 2007
• 157254 BUG: A SELECT-SQL error may occur when a parent table is joined to two child tables in Visual FoxPro Q157254 KB157254 February 12, 2007
• 156737 BUG: Disabled ListBox items can be accessed by using the keyboard in Visual FoxPro for Windows Q156737 KB156737 February 12, 2007
• 156642 You receive the "String too long to fit" error message after you change the format of a memo field to uppercase in Visual FoxPro Q156642 KB156642 February 12, 2007
• 156550 You receive a "Data Type Mismatch" error message when you set the ControlSource property of a combo box or a list box to a Date field type in Visual FoxPro Q156550 KB156550 February 12, 2007
• 156237 Report Designer and Report Preview need the Visual FoxPro desktop to display Q156237 KB156237 February 12, 2007
• 156034 How to retrieve information from SQL Server about affected rows in Visual FoxPro 7.0 and later versions Q156034 KB156034 February 12, 2007
• 155788 How to optimize SELECT-SQL commands by using the FORCE clause and SYS(3054) in Visual FoxPro 5.0 and later versions Q155788 KB155788 February 12, 2007
• 155388 CLEAR RESOURCE does not appear to work Q155388 KB155388 February 12, 2007
• 153199 How to use the SQL Server Bulk Copy Program to move lots of data to SQL Server from Visual FoxPro Q153199 KB153199 February 12, 2007
• 151090 How to create a stored procedure in Microsoft SQL Server 2000 to return a specific error message to the user in Visual FoxPro Q151090 KB151090 February 12, 2007
• 148724 How to fill a second list with values from a multi-select list box in Visual FoxPro Q148724 KB148724 February 12, 2007
• 147310 How to print a report that is based on selections in a list in Visual FoxPro Q147310 KB147310 February 12, 2007
• 145816 How to access a report's data environment while the report runs Q145816 KB145816 February 12, 2007
• 143401 Cannot shorten report bands of Wizard-generated reports Q143401 KB143401 February 12, 2007
• 142940 How to gain access to the View menu pad in an .exe file Q142940 KB142940 February 12, 2007
• 142567 How to filter a child grid by using a parent combo box in Visual FoxPro Q142567 KB142567 February 12, 2007
• 142191 You may receive error messages if you use a field name that starts with a tilde character in Visual FoxPro Q142191 KB142191 February 12, 2007
• 141140 How to create an SQL Server stored procedure in Visual FoxPro Q141140 KB141140 February 12, 2007
• 140489 One-to-many report prints first child if the scope is one Q140489 KB140489 February 12, 2007
• 140222 You cannot use the _PBPAGE or _PEPAGE system variables to control the pages for a Report Form Q140222 KB140222 February 12, 2007
• 139625 How to use and call the GetUserName API from Visual FoxPro Q139625 KB139625 February 12, 2007
• 139624 How to print pictures in a report by using an embedded path Q139624 KB139624 February 12, 2007
• 138777 How to create a report to print or to preview a graph that was created by using the Query Designer and the Graph Wizard in Visual FoxPro Q138777 KB138777 February 12, 2007
• 138758 How to print event procedures for a form in Visual FoxPro Q138758 KB138758 February 12, 2007
• 138473 BUG: Code window closes design tools when it is run from a program in Visual FoxPro Q138473 KB138473 February 12, 2007
• 138396 How to use the default Windows printer in Visual FoxPro Q138396 KB138396 February 12, 2007
• 137445 How to display the View properties and the Connection properties in Visual FoxPro Q137445 KB137445 February 12, 2007
• 137413 BUG: Report Designer creates child records in one-to-many report in Visual FoxPro Q137413 KB137413 February 12, 2007
• 136765 Description of how memory and disk space are used during a SELECT-SQL command in Visual FoxPro Q136765 KB136765 February 12, 2007
• 136620 Benefit of storing printer information in a report table (.FRX file) Q136620 KB136620 February 12, 2007
• 135286 BUG: You cannot use the keyboard to change the vertical size of an object Q135286 KB135286 February 12, 2007
• 134466 How to display multiple columns of the SQL-SELECT cursor in a combobox object in Visual FoxPro Q134466 KB134466 February 12, 2007
• 133023 How to list number of records in each group of a SQL-SELECT Group By Clause in Visual FoxPro Q133023 KB133023 February 12, 2007
• 131346 How to hide and restore (unhide) system toolbars in Visual FoxPro 3.0 and later versions Q131346 KB131346 February 12, 2007
• 131217 The REPORT FORM command uses a temp file for unsaved reports Q131217 KB131217 February 12, 2007
• 131213 A grid loses its data when a list box or combo box on a form uses the Requery method in Visual FoxPro Q131213 KB131213 February 12, 2007
• 131200 How to print a report when no records are involved Q131200 KB131200 February 12, 2007
• 130991 How to send a Windows print file to the printer Q130991 KB130991 February 12, 2007
• 130865 How to place totals or other information on the last page of the report in the page footer Q130865 KB130865 February 12, 2007
• 130707 How to display records that meet a given criteria in a grid on a form in Visual FoxPro Q130707 KB130707 February 12, 2007
• 130659 You receive a "The database must be opened exclusively" error message in Visual FoxPro Q130659 KB130659 February 12, 2007
• 130413 How to create an updatable view to update data in underlying tables in Visual FoxPro Q130413 KB130413 February 12, 2007
• 130122 How to add the SQL SELECT to the data environment of the REPORT FORM in FoxPro 3.0 and later versions Q130122 KB130122 February 12, 2007
• 128209 Description of design mode in screens, reports, and labels in Visual FoxPro 3.0 and later versions Q128209 KB128209 February 12, 2007
• 124402 How to call a user-defined function from the SELECT-SQL statement in FoxPro Q124402 KB124402 February 12, 2007
• 114865 BUG: The text specified by using the HEADING clause of the REPORT FORM command is printed over the column headings in Visual FoxPro Q114865 KB114865 February 12, 2007
• 113808 How to determine the number of records that are returned by a SELECT-SQL statement in Visual FoxPro Q113808 KB113808 February 12, 2007
• 113278 How to replace a string in a text file Q113278 KB113278 February 12, 2007
• 111991 You receive a "Compiled code for this line too long" error message in Visual FoxPro Q111991 KB111991 February 12, 2007
• 109580 Causes of common SELECT-SQL error messages Q109580 KB109580 February 12, 2007
• 109152 How create a data grouping that breaks after a certain number of records in Visual FoxPro Q109152 KB109152 February 12, 2007
• 106708 How to generate unique key field values in FoxPro and in Visual FoxPro Q106708 KB106708 February 12, 2007
• 102203 BUG: The print job is not released to the printer in Visual FoxPro Q102203 KB102203 February 12, 2007
• 101046 How to create a dynamic SELECT-SQL statement in an executable file in FoxPro Q101046 KB101046 February 12, 2007
• 100552 Total of report bands cannot exceed the page length in Visual FoxPro 3.0 and later versions Q100552 KB100552 February 12, 2007
• 98362 Description of the differences between the MIN function and the MAX function and differences between the SELECT-SQL MIN field function and the MAX field function in FoxPro Q98362 KB98362 February 12, 2007
• 888470 Another installation program starts when you try to install Visual FoxPro, Visual Studio .NET, Visual Studio 2005 or prerequisites Q888470 KB888470 February 2, 2007