SEM 20 Visual Extend Power for VFP Developers

1
SEM 20Visual ExtendPower for VFP Developers
Venelina Jordanova Venelina_at_OutsourcingITservices
.net
Uwe Habermann Uwe.Habermann_at_dFPUG.de
2
Visual Extend 10.0

• 11 years VFX
• dFPUG c/o ISYS GmbH
• Market leader in Europe
• More developers than all other frameworks
  together
• Only framework with full support of cursoradapters

3
Visual Extend 10.0

• Available for download
• www.visualextend.com
• 3 demo applications
• 20 hours video tutorials
• 9.0? A new book will come soon!

4
Visual Extend 10.0

• Homepagehttp//www.visualextend.de
• Documentshttp//portal.dfpug.de/dFPUG/Portal/VFX
  
• Supporthttp//forum.dfpug.denews//news.dfpug.d
  e
• Newshttp//newsletter.dfpug.de

5
Who is talking?

• Venelina Jordanova
• Master degree in CSfrom TU of Varna
• FoxPro developer since FPD 2.0
• MCP for SQL Server and other
• Visual ExtendSoftware DevelopmentTeam Leader
• Owner of JEI Varna, BulgariaOutsourcing Center

• Uwe Habermann
• Master degree in CSfrom TU of Berlin
• FoxPro developer since FPW 2.5
• MCP für VFP
• Visual ExtendProduct Manager
• Freelancer working for ISYS, Wizards Builders,
  ProLib
• Uwe Habermann Kathrin Leu GbR

• Venelina Jordanova
• Master degree in CSfrom TU of Varna
• FoxPro developer since FPD 2.0
• MCP for SQL Server and other
• Visual ExtendSoftware DevelopmentTeam Leader
• Owner of JEI Varna, BulgariaOutsourcing Center

• Uwe Habermann
• Master degree in CSfrom TU of Berlin
• FoxPro developer since FPW 2.5
• MCP für VFP
• Visual ExtendProduct Manager
• Freelancer working for ISYS, Wizards Builders,
  ProLib,
• Uwe Habermann Kathrin Leu GbR

Frankfurt 2003, Praha 2004, Frankfurt 2004, Praha
2005, Frankfurt 2005, Bucharest 2006, Praha 2006,
Frankfurt 2006, Utrecht 2006, Paris 2006, Praha
2007


6
VFX What is this?

• Rapid Application Development Framework
• Template project
• Task pane
• Many builders and wizards
• Projects for
• PDF Output
• Modify Report
• Customer Management
• Web Service for product activation
• and much more

7
Installation

• VFX100Setup.exe
• Run Vfxmnu.app via desktop icon
• Register online and get a free activation key
  valid for 30 days!
• At the 1. start of Vfxmnu.app the VFP Task Pane
  gets opened and the VFX Task Pane gets added
• No path settings in VFP required

8
Our Mission

• Create an application within 75 minutes
• 3 forms
• Products
• Customers
• 1n Orders
• 2 Pick list
• Parent/Child relation
• For DBC and SQL Server

9
Our Sample Application
enelinas
V
pace
S
hop
S
10
VFX Application Wizard

• Create a new project

1. Select the folder andthe database 2. Text for
about dialog 3. Settings for theapplication
object 4. Text for project info dialog 5. Compile
all files and go... Czech and Slovak available!
11
The generated VFX Application

• Splash-Screen
• Login dialog
• Menu and toolbar
• Windows XP style open dialog
• User management
• User rights
• Database maintenance
• About dialog
• and much more...

12
What to do now?

• Development of the database
• with VFP Database Designer
• with SQL Server Management Studio
• with xCase
• with SDT

13
Our Data Model
14
VFX Cursoradapter Wizard

• Automatic Generation of CursorAdapter Classes for
  all tables and views of a database
• for VFP databases
• for SQL Server
• Select the data source
• Select the classes and class libraries
• Settings for updatable fields

15
ProductsVFX CTableForm Builder

• Select form class
• Setup data environment
• Search grid and edit controlsare side by side
• Reentrant builder (reusable)
• Use own classes

16
The Form at Runtime

• Autoedit, New, Delete
• Incremental search in grid
• Multi column sort
• User specific settings
• Size and position of forms at the desktop
• Column width, column order, and sort order of
  grids
• Search criteria

17
CustomersVFX CDataFormPage Builder

• Select form class
• Setup data environment
• Search grid and edit controls are placed on a
  pageframe
• Reentrant builder

18
The Form at Runtime

• Print in all forms without creating reports
• Reports are created at runtime
• Save as
• HTML, XML, TIF, BMP, PDF
• Installation of Ghostscript not required
• E-Mail
• MAPI
• Fax
• Fritzfax, Winfax

19
OrdersVFX COneToMany Builder

• cOneToMany
• Edit and search in parent data similar to
  cDataFormPage
• Edit child data in a grid
• Edit child data in with any othercontrol type
• Support of multiple children
• Foreign keys? VFX does it for you ?
• orderid ?caorders.orderid

20
Pick CustomersVFX CPickAlternate Builder

• Select a customer for an order
• Enter the customer name
• Select a customer by list
• All search options available

21
Pick ProductsVFX CPickTextbox Builder

• Select a product for an order detail
• Enter the product number
• Select a product by list
• All search options available

22
Parameter for Orders

• Optimized data access
• Add controls in VFX Form Builder
• Add Where clause
• customerid ?thisform.tCustomerid
• Done!

23
RelationsVFX Parent/Child Builder

• Call a child form
• Multiple children possible
• Hierarchical children possible
• Many control options
• Example Customers Orders

24
VFX Upsizing Wizard

• No DSN required
• All connection types supported
• Keep ID values
• No codepage conflicts
• Bulk Insert works
• Supported of protected field names
• Allow NULL values
• Create a new database

25
VFX Manage Config.vfx

• Manage data access
• Client database selection for end-users
• Compatible to Vfxpath
• Switch between DBC and SQL
• Use of ConnectionString recommended
• cConfigPassword Password for encryption of the
  file Config.vfx

26
Mission completed

• Generated application
• Generated forms
• Many features
• No code
• High quality pleased customers

27
Test VFX now!

• Free activation key for 30 days!
• Demo application VFX100Test
• Demo application VFX100Traders
• Demo application VFPizza100
• User manual in German and English
• Huge amount of information
• Newsgroup 20000 messages
• Portal 50 documents

28
Thank you very much andhave fun with VFX!

• Venelina Uwe