Introduction Microsoft Visual Fox Pro 5 0 Rainer

Introduction Microsoft Visual Fox. Pro 5. 0 Rainer Becker MSP, MCP, MVP, d. FPUG ISYS Gmb. H, W&B Gmb. H ™

Mission Visual Fox. Pro 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 Active. X Extensibility/Interoperability l Performance, Performance l Improved Connectivity Features l Enhanced Development Environment l

Active. X Extensibility l Automation n Great Client n Great Server n Custom Automation Servers n Remote Automation

Active. X Extensibility l Great Active. X Controls Host n Enhanced support for Sub. Classing Active. X Controls (. OBJECT) n ISimple. Frame

Great Performance l Client/Server Performance n Aggregating SQL Deletes n Fetch Performance n Pre-compile SQL pass-thru stmts/views l OLE Performance n Type libraries for faster lookup of properties/methods n Form Load/Refresh with OLE bound/unbound controls

Connectivity l Offline Views n Create ‘snapshot’ of VFP or remote datasources and disconnect n Reconnect, batch updates and resolve conflicts l ODBC 3. 0 support

Connectivity l VFP ODBC Driver n Fast Access to 2. x and 3. 0 Tables and 3. 0 Database Tables via ODBC API n Respects Rules, Triggers, Default Values n Thread Safe n Separate Threads for Query Processing and Results Fetching

Connectivity l Deploy Automation Servers on the Web n Remote automation n Foxisapi. dll n Bundled classes generate HTML n Sample app included

Enhanced Development Environment Visual Source. Safe l IDE l n Color coded editor n Debugger (Event Tracking, Call Stack) n Command Window

Enhanced Development Environment l Language n Parent. Class n Collections (For Each) n HIDDEN n ASSERT/SET ASSERT n DROP TABLE/VIEW n SQLPREPARE() n SET NULLDISPLAY

Enhanced Development Environment Multiuser DBC l Intelligent controls l n default/configurable caption n default/configurable control type n can associate a class with a field l Language n= and ? not required n Top. N and Ansi 92 Outer Join

What to Buy l Visual Fox. Professional n includes re-distribution tools, licensing n must acquire VSS separately l Visual Fox. Pro Standard eliminated n low volume n Visual Fox. Pro 3. 0 Std can upgrade to Visual Fox. Pro 5. 0 Pro l Competitive/Version Upgrade, Academic Edition also available

Visual Fox. Pro: The Future Next version (5. 5) is being started now l Continued development as full member of Visual Tools family (VB, VC, VJ, etc) l Building components for other Microsoft tools and the Internet l More info at European Visual Fox. Pro Dev. Con, Ce. BIT, d. FPUG l

Fragen? d. FPUG o 6173 -950903 CIS 100024, 1364