Visual Extend 9.0 Rapid Application Development

1
Visual Extend 9.0Rapid Application Development
Venelina Jordanova, Uwe Habermann Venelina_at_mnet.bg
, Uwe_at_habermann-leu.de
2
Who is talking?

• Venelina Jordanova
• Working with FoxPro since 12 years
• MCP
• J.E.I.-Varna
• Custom development
• Visual ExtendSoftware Development Leader

• Uwe Habermann
• Working with FoxPro since 12 years
• MCP for VFP
• Freelancer since 1986
• Consultant of ProLib, ISYS and other companies
• Visual ExtendProduct Manager

• Venelina Jordanova
• Working with FoxPro since 12 years
• MCP
• J.E.I.-Varna
• Custom development
• Visual ExtendSoftware Development Leader

• Uwe Habermann
• Working with FoxPro since 12 years
• MCP for VFP
• Freelancer since 1986
• Consultant of ProLib, ISYS and other companies
• Visual ExtendProduct Manager

3
VFX 9.0 - What is this?

• Rapid Application Development Framework for VFP 9
• VFX 9.0 comes with
• Template Application
• Many Builders and Wizards
• Task Pane

4
Lets create a Sample Application
enelinas
V
antastic
F
izzas
P
5
VFX - Application Wizard

• Create new Projects
• Enter the folder and database
• Enter texts for the about dialog
• Make settings for the application object
• Enter project information
• Compile all files
• Lets go!
• Czech available!

6
At Runtime

• Splash-Screen
• Login dialog
• Menu and Toolbar
• XP style open dialog
• User management
• Database Maintenance
• and much more features...

7
What to do now?

• Create a database
• Using the VFP database designer
• Or using xCase
• Or using SDT

8
Our Data Model
9
Our first FormVFX Form Wizard

• Create forms based on VFX form classes
• cDataFormPage
• cTreeViewForm
• cTableForm
• cOneToMany
• cTreeViewOneToMany
• cAskViewArg
• cWizard
• Based on own form classes

ExampleProducts.scx
10
The Form at Runtime

• Autoedit
• New
• Delete
• Incremental search in the grid
• Multi-Column-Sort

11
Goal Work on DBC or SQL

• Use CursorAdapters
• Switch data source at runtime
• Store data source information in an encoded file

12
VFX CursorAdapter Wizard

• Create CursorAdapter Classes for all Tables of a
  database
• for VFP database
• for SQL Server

13
VFX cDataFormPage Builder

• Reentrant Builder
• Controls on pages of a pageframe
• Search grid includes many features ?
• Setting of form properties
• Usage of own classes for controls
• Corresponding to the DBC settings
• Corresponding to the VFX project properties
• Example Customers.scx

14
The Form at Runtime

• Saving settings per user
• Size and Position of the form on the desktop
• Column width, column order and sort order of grids

15
Printing, PDF Export, E-Mail

• Printing possible in all forms without creating
  any report
• Save as
• PDF,HTML, XML, TIFF, BMP
• PDF generation
• Postscript printer driver
• Ghostscript
• Send all file types by E-Mail
• MAPI

16
VFX - cOneToMany Builder

• cOneToMany
• Edit and search of parent data similar to
  cDataFormPage
• Edit child data in a grid
• Edit child data in edit page
• Support of multiple children
• Example Orders.scx

17
Pickfields

• Select a customer for an order
• VFX CPickAlternate Builder
• Example pick Customer
• Select a product for an order detail
• VFX CPickTextbox Builder
• Example pick Product

18
VFX Parent/Child Builder

• Call a Child Form
• Support of multiple Children
• Hierarchical linking possible
• Properties for control
• lCloseChildformOnExit
• lAutoSyncChildform
• Example Customers.scx Orders.scx

19
VFX Manage Config.vfx

• Manage Data Access
• Dialog available for end-customers
• Switch between DBC and SQL
• Usage of connection strings recommended
• Password protected file

20
Goal reached!

• Generated application
• Generated forms
• No coding
• Works on DBC and SQL

21
VFX AFP Wizard

• Create web forms with a mouse click!
• Requirements
• VFX 9.0 und VFP 9.0
• AFP - Active FoxPro Pages
• Similar to ASP but based on VFP
• IIS
• For now
• works on DBC only

22
VFX - LangSetup Builder

• Localization
• At design time
• At runtime

23
More Examples in Sample Apps

• VFX90Test
• VFX90Traders
• VFPizza

24
Much more Features

• Search Dialog
• Many conditions possible
• Save search settings per user
• Many Classes
• Date picker
• Send e-mails
• Calculator
• OLE Drag Drop

25
Product Activation

• Integrated Product Activation
• For up to 32 rights or modules
• Define activation rules
• The developer can decide about the activation
  rules
• Create Activation Key
• Create activation keys for customers
• Support of time limited keys

26
Product Update

• Update customers application via the Internet
• Automatic download and installation at the
  customer

27
Links

• Download and Information about VFX
• www.visualextend.com
• More information about VFX
• portal.dfpug.de/dokumente/visualextend
• Free Support for VFX in English and German
• http//forum.dfpug.de OR news//news.dfpug.de

28
Thank you very much andHave fun with VFX!

• Venelina Jordanova Uwe Habermann