150 likes | 452 Views
™. Introduction Microsoft Visual FoxPro 5.0 Rainer Becker MSP, MCP, MVP, dFPUG ISYS GmbH, W&B GmbH. Mission. Visual FoxPro 5.0 is the high performance, object-oriented development environment for creating state-of-the-art desktop and client/server database applications. Key Themes.
E N D
™ Introduction Microsoft Visual FoxPro 5.0Rainer BeckerMSP, MCP, MVP, dFPUGISYS GmbH, W&B GmbH
Mission Visual FoxPro 5.0 is the high performance, object-oriented development environment for creating state-of-the-art desktop and client/server database applications
Key Themes • Powerful ActiveX Extensibility/Interoperability • Performance, Performance, Performance • Improved Connectivity Features • Enhanced Development Environment
ActiveX Extensibility • Automation • Great Client • Great Server • Custom Automation Servers • Remote Automation
ActiveX Extensibility • Great ActiveX Controls Host • Enhanced support for SubClassing ActiveX Controls (.OBJECT) • ISimpleFrame
Great Performance • Client/Server Performance • Aggregating SQL Deletes • Fetch Performance • Pre-compile SQL pass-thru stmts/views • OLE Performance • Type libraries for faster lookup of properties/methods • Form Load/Refresh with OLE bound/unbound controls
Connectivity • Offline Views • Create ‘snapshot’ of VFP or remote datasources and disconnect • Reconnect, batch updates and resolve conflicts • ODBC 3.0 support
Connectivity • VFP ODBC Driver • Fast Access to 2.x and 3.0 Tables and 3.0 Database Tables via ODBC API • Respects Rules, Triggers, Default Values • Thread Safe • Separate Threads for Query Processing and Results Fetching
Connectivity • Deploy Automation Servers on the Web • Remote automation • Foxisapi.dll • Bundled classes generate HTML • Sample app included
Enhanced Development Environment • Visual SourceSafe • IDE • Color coded editor • Debugger (Event Tracking, Call Stack) • Command Window
Enhanced Development Environment • Language • ParentClass • Collections (For Each) • HIDDEN • ASSERT/SET ASSERT • DROP TABLE/VIEW • SQLPREPARE() • SET NULLDISPLAY
Enhanced Development Environment • Multiuser DBC • Intelligent controls • default/configurable caption • default/configurable control type • can associate a class with a field • Language • = and ? not required • TopN and Ansi 92 Outer Join
What to Buy • Visual FoxPro Professional • includes re-distribution tools, licensing • must acquire VSS separately • Visual FoxPro Standard eliminated • low volume • Visual FoxPro 3.0 Std can upgrade to Visual FoxPro 5.0 Pro • Competitive/Version Upgrade, Academic Edition also available
Visual FoxPro: The Future • Next version (5.5) is being started now • Continued development as full member of Visual Tools family (VB, VC, VJ, etc) • Building components for other Microsoft tools and the Internet • More info at European Visual FoxPro DevCon, CeBIT, dFPUG
Fragen? dFPUG o6173-950903CIS 100024,1364