readme
Visual FoxPro "Sedna" Community Technology Preview - February 2007
==================================================================
This CTP of Sedna contains add-ons to Visual FoxPro 9.0 SP1. Please uninstall previous CTPs from your machine before installing this CTP. The Sedna CTP Setup will install the CTP onto your disk. By default the CTP will be installed to the "Microsoft Visual FoxPro 9\Sedna February CTP" folder under your Program Files folder.
This installation contains five components: VistaDialogs4COM, Upsizing Wizard, Data Explorer, NET4COM and MY
The following sections describe these components and provide guidance on how to get started.
VistaDialogs4COM
================
The VistaDialogs4COM is a collection of COM-visible classes that wrap the functionality provided by the Microsoft VistaBridgeLibrary. VistaDialogs4COM provides Visual FoxPro developers access to the Windows Vista TaskDialog and Common Dialogs.
The setup for the February CTP will install the VistaDialogs4COM assembly, the VistaBridgeLibrary and other required DLLs, the VistaDialogs4COM source. A sample VFP project demonstrating use of different features of VistaDialogs4COM is also included.
The VistaDialogs4COM folder contains the following:
VistaDialogs4COM.dll -- DLL for the COM components that wrap VistaBridgeLibrary.
VistaDialogs4COM -- Folder containing the VB.NET source code for VistaDialogs4COM
VFP Sample -- Folder containing a VFP sample project that illustrates the use VistaDialogs4COM
A few additional notes on VistaDialogs4COM:
VistaLibrary4COM requires Windows Vista. The API used are not available on earlier versions of Windows. The VFP Sample folder contains images that show the different dialogs and how they differ from the corresponding dialogs in earlier versions.
SQL Server Upsizing Wizard
==========================
This is an update to the Visual FoxPro 9.0 SP1 Upsizing Wizard. In this CTP the Upsizing Wizard will install to the "Microsoft Visual FoxPro 9\Sedna February CTP\UpsizingWizard folder under Program Files. To launch the new wizard run the 'UpsizingWizard.app' from this location.
This update includes:
* Updated, cleaner look and feel
* Streamlined, simpler steps
* Step 5 allows the user to decide whether to use bulk insert or not. This can improve upload performance.
* Allows you to specify the connection as a DBC, a DSN, one of the existing connections or a new connection string.
* Fields using names with reserved SQL keywords are now delimited.
* If lQuiet is set to true when calling the wizard, no UI is displayed. It uses RAISEEVENT() during the progress of the upsizing so the caller can show progress.
* Performance improvement when upsizing to Microsoft SQL Server 2005.
* Trims all Character fields being upsized to Varchar.
* BlankDateValue property available. It specifies that blank dates should be upsized as nulls. (Old behavior was to set them to 01/01/1900).
* Support for an extension object. This allows developers to hook into every step of the upsizing process and change the behavior. Another way is to subclass the engine.
* Support for table names with spaces.
* UpsizingWizard.APP can be started with default settings (via params) for source name and path, target db, and a Boolean indicating if the target database is to be created.
Database Explorer
=================
This is an update to the Visual FoxPro 9.0 SP1 Data Explorer. In this CTP the Upsizing Wizard will install to the "Microsoft Visual FoxPro 9\Sedna February CTP\DataExplorer folder under Program Files. To launch the new wizard run the 'DataExplorer.app' from this location.
This update includes:
* Fixed drag and drop of VFP table from Data Explorer to a form.
* Fixed issue: "Drag/drop of VFP table/view from the Data Explorer to a form does not set the RecordSource."
* Fixed issue with free tables not showing their columns when expanding the node.
* Drag and drop operations now respect Field Mapping settings for SQL Server data
* Allows sorting to apply to specific objects, not all.
* Display SQL ShowPlan for local views
* Display ShowPlan information for VFP table/view queries in the query results
* Add Showplan parameter setting to the Options dialog, use in showplan features
* Context menu item to launch the new UpsizingWizard.
NET4COM
=======
The NET4COM library is a collection of COM classes that wrap a subset of the .NET Framework 2.0. The .NET Framework is a rich collection of namespaces and API that provides a comprehensive set of functionality that developers can use to build applications that run on the .NET platform. While VFP does have a rich library of API, there are some features that either do not exist in the VFP libraries or are harder to use than in the Framework. NET4COM brings together a small subset of the .NET Framework ?a collection of commonly used API that brings to VFP functionality that does not exist.
The setup for the June CTP will install the NET4COM DLL along with some sample files to disk. Setup will also register the COM components in NET4COM.dll. The NET4COM folder contains the following:
NET4COM.dll -- The DLL for the COM components that wrap a subset of the .NET Framework 2.0.
Source -- Folder containing project file and source code for NET4COM
VFPSamples -- Folder containing VFP sample code that uses NET4COM
VB6Samples -- Folder containing VB6 sample code that uses NET4COM
FFC -- FFC wrappers for NET4COM
The samples demonstrate use of NET4COM from Visual FoxPro or Visual Basic 6.0.
MY for VFP
==========
The MY library for Visual FoxPro is similar to NET4COM. MY is implemented natively for Visual FoxPro and, similar to NET4COM, exposes commonly used functionality in a hierarchy that is easy to discover and navigate.
Sedna CTP Setup will install the MY library and related files in the "MY" folder under the selected install destination. To install MY into Visual FoxPro:
* Browse to the MY folder
* Run MY.APP
The MY folder contains a help file: MY.CHM that describes, setup and usage of MY and includes the API reference for the different APIs.
List of Fixes in Visual FoxPro 9.0 SP2 February 2007 CTP
Classes
VFP8: DataEnvironment doesn't release object stored in DataSource property.
VFP7: Custom MousePointer not working for controls in grid
VFP9 - Grid - "INDEX internal consistency error." on GRID with _SCREEN.ShowTips = .T. No crash in VFP8, or in 9 if you turn off the memo tips.
VFP9: Listbox - Fatal exception closing tables which are listbox rowsources
VFP8: Form - Private DataSession of form get orhpaned. Leads to buffer overflow
VFP9: Grid - Memo tips do not refresh as well as they do in a standard BROWSE window as you move your mouse.
VFP8: CursorAdapter.Flags property is read-only
VFP8: Form - Close button and "CLOSE" control box menu item are not refershing properly on top-level form when modal "child" forms run
VFP7: C5 is thrown when Grid's RecordSource is closed in BeforeRowColChange/AfterRowColChange (VFP should be started from the debugger)
VFP8: Textbox - Decimal portion of numeric value reset to 0 when TextBox with Alignment = 0 or 2 and ReadOnly = .T. loses focus
VFP7: Form - Hang after alt+tab to scrollable toplevel form from modal in-screen desktop form after combo opened in toplevel form
VFP8: Classes - Fatal exception closing Class Designer if focus is on grid column contained in toolbar container
VFP9: Crash on GetObject on Vista
CRASH: removeproperty of a binded property
With a spinner or a combobox the form can become unmanageable
_VFP.ServerName (or Application.ServerName, respectively) is empty if the full path and file name of the EXE/DLL/MT-DLL exceeds 128 characters.
PictureVal not accepting PNG images
COM
VFP9: Access violation getting Accessible object name
VFP9: IAccessible empty grid value returns invalid data
VFP9: intellisense for .NET obj doesn't show unless instantiated
VFP9: CVConvertVariantToCType converts UI4 to UI2
VFP9: COM doesn't preserve precision of Real numbers
VFP9: sys(3097) of non-com object causes crash
Data
DCR - VFP8: OLEDB Provider - Provider should read CODEPAGE = from config.fpw
VFP9: Engine - CreateOffline() returns .F. with error "View definition has changed" if view references table with long field name
VFP7: Index matching code fails to match UDF calls due to "possibly passed by ref" tag.
AV in vfpoledb.dll!CSchema_Proc::Execute
DCR: VFP OLEDB Provider - Need a way to configure SET DELETED in connection or via language
VFP8: It is possible to force update of an AUTOINC field in appended record.
VFP7: VFP allows to create structural CDX for a table opened in shared mode, which may cause header corruption.
VFP9 DEBUG BUILD: Crash after doing rollback in form's private DataSession after the form is closed.
VFP7: Functions from T_FUNCTION3 bucket can cause C5 when VFP tries to determine return type for expression.
VFP9: Unexpected “File is not open” error reported by INDEX ON command after DELETE TAG ALL for a structural CDX on a View.
VFP7: Engine - Fatal exception with LOCATE using LIKE with long 2nd expression
VFP9: buffer overrun in ExtractsubExp
VFP7: Null propagation for Double type doesn't work for arithmetic operations.
VFP6: A table doesn't match DBC when ALTER TABLE adds 99 fields and fields' names are longer than 10 characters.
VFP6: Internal Consistency Error (ICE) after closing BROWSE for a table with very long field names.
VFP9: INDEX ON for view does not create CDX after DELETE TAG ALL
VFP6: SPT removes "!" following parameter name, which replaces != with = comparison.
VFP7: Result of ISNULL(), EMPTY() functions is treated as nullable (affects BINARY indexes in VFP9).
VFP7: Index on ISNULL() isn't used for optimization by SQL engine.
VFP8: OLE DB Provider - Bogus error message displayed by Data Link Properties dialog when configuring a UDL to a non-existant DBC using provider.
VFP8: Engine - Fatal exception resizing browse window when filter UDF has a local variable declared
VFP8: OLE DB Provider - Use of underscore system variables (_SCREEN for instance) generate "too many variables" error message in OLE DB provider
VFP7: SPT passes NULL values as char, might cause type mismatch error for certain data types (affects CursorAdapter as well).
VFP7 SPT: Unexpected "Type conversion is not supported for output parameters." error trying to pass NULL variable of Date/DateTime type as an output parameter for an SP
VFP9 SP2: Unexpected error trying to pass "untyped" NULL value to an SP
Reporting
VFP8: Report Designer - Group headers will not print on a page where the group footer is continued from the previous page if a page break occurs in the middle of group footer
VFP9: Variable VPOS is not found when modifying field of report with SET COMPATIBLE on
VFP9: Report Designer - Memory leak modifying or previewing report with items marked as protected
VFP9: Report fields are not printed in long group headers
VFP9 : Cancelling print closes the print preview
In Xbase code in either of the dynamic ReportListener events (EvaluateContents and AdjustObjectSize), Report Variables that contain object references can't be used properly
VFP9: ReportBuilder.app: Error "At least one required index tag is missing from the configuration table...." on "DO ( _REPORTOUTPUT ) WITH 5, <oLsnr>" when SET( "FIXED" ) == ON
VFP9: XMLListener code doesn't account for CREATE REPORT ... FROM (DBF(ALIAS())) 's behavior when SET FULLPATH is OFF
VFP9: ReportListener AdjustObjectSize returns inaccurate Top and MaxHeightAvailable for objects in Page Footers
IDE
VFP8: Access keys in RTL environment bugs (BIDI)
VFP9: IDE - Error "Invalid BROWSE setup -- default setup used" browsing a cursor with name >35 chars when a cursor with same name up to the 35 char point has settings stored in resource file
VFP8: Engine - Fatal exception with EVL(,(TTOC()) in field list
C5 exception after closing BROWSE window
VFP9: Error Reading File infinite loop if drive disabled while file open and data session window open
Language
VFP9: Unbindevent from within BoundEvent causes invalid memory access
VFP6: "Subquery returned more than one record." error is not reported if result of the sub-query is compared with == operator (works as expected for = operator)
VFP9: name table overflow during load of large number of procedures causes incorrect behavior
VFP8: Private Datesession causes editbox to overwrite existing data
VFP9: Language - Fatal exception with JUST*() and FORCE*() functions when passing certain strings
VFP9 SP1: Behavior of FSEEK() is changed in VFP9 SP1 for files opened using mode 10,11,12.
VFP6: COUNT(*) returns incorrect result when tables are joined using GENERAL collate.
VFP9: SQL-DELETE command doesn't respect OUTER modifier for a join with the target table
COUNT(*) can return wrong results under some conditions when SET COLLATE is not MACHINE
SQL internal error
Projects
TFS MSSCCI Provider crashes in VFP 9
http://download.microsoft.com/download/f/3/9/f391f668-a6b9-403c-a390-c9bfb5b49497/VFP9SP2_Feb07CTP_FixList.htm
