Proposed Timetable , Speakers and List of Topics
[/size]
[size=150]LIST OF TOPICS / CONTENTSAntonioHistory of Fivewin and Harbour
Then and Now
FiveWebFiveTouchOverall support and supervision
Cirstobal
Fivedit
FiveWin's program editor and Project Builder
-Configuration
-ANSI and all standards of Unicode
-Editing, syntax highlighting
-Funtions, methods list
-Context sensitive help
-Running single module application without building exe
-Project configuration
-Bulding and running project with different compilers
-More"
Richedit- TRichEdit
- TRichEdit5
Menu System
Google API, REST APIGoogle Maps- and alternatives to Google Maps
Google Cloud APIReinaldo ADS
Advantage Database
* ISAM vs. SQL and how you can still do both with ADS
* ADT, VFP, Extended field types
* Data Dictionaries
* Field defaults and constraints
* SQL scripting language and some query tools
* Triggers
* Stored procedures and User defined functions
* Referential integrity (RI)
* Transactions
* Fast Text Search indexes (FTS)
* Database Event Notifications
* Enhanced DB security and Encryption
* Replication
* Online Backup
DanielTCalex
RibbonBar
Otto
Easy Report
- a Walk-through
Autocode
- Programming help tool
G.Nageswara RaoXBROWSE(as a browser)
- Recommended ways to create and cofigure. Comparision of alternatives. Merits of using command syntax.
- Parametrized creation of xbrowse.
- Recommended ways to create columns, alternative methods and when to use / not to use alterntiave methods.
- Styles: Legacy, 200? styles, Flat Style for Metro-look.
- Compatibility issues with some RDDs and limitations.
- Configuring the browse.
- Excel like
- MarqueeStyles and Lines
- Configuring columns
- Editing Cells, edit types (more on listbox and editbutton)
- Edit functions for memo fields
- Formula Edit like Excel. (Eg "=234/456*12%" )
- Power of Xbrowse copy and paste methods. Exporting data by copying and importing data by pasting including images and blobs into any database being browsed
- Deprecated and discouraged methods and datas
- Important DO's AND DONT's
- How to use minimal code to avail the full power of XBrowse
- Advantages of using XBrowse's built-in defaults and when only to over-ride with programmers' own settings.
- What to avoid. Based on examples taken from several postings of code snippets in the forums.
- Images, bitmaps, brushes, Progress-bars, Charts, etc in Cells.
- Reading and saving of images and blobs
- Cell formattig, like positioning of various elements inside the cell, usage of multiple fonts.
- Additional formatting available in xbrowse.
- Ownerdraw of cells, rows, headers and footers
- Issues when browsing slow access datasources.
- Fastdraw
- Auto-calculation of columns, user defined computation of columns, group computations and other inbuilt computational capabilities
- MakeTotals(). Programming considerations.
- Pivot table browses and swapping.
- Getbars and Seekbars
- Built-in incremental seek/filters
- Exporting data Excel, Calc, Report, Word, DBF, PDF
- Grouped rows as Merged Columns and Trees
- Forgotten and less known switches, methods and features and their uses.
Inheriting and extending XBrowse- Template for Inheriting XBrowse
- Adding new datas and methods on the fly, to individual browses and columns without effecting other browses/column objects
XBROWSE and TDATAROW(for Database maintenance)
XBrowse, along with integrated datarow, is a lot more than simple data display tool. It provides a complete database maintaienace system, which is simple to use yet robust.
- Using methods Edit(), EditSource(), Delete() etc for total maintenance of tables providing browsing with add/edit/delete facilities.
- Advantages of using these methods compared to alternatives.
- Customization of these methods for user requirements.
- Using custom edit dialogs
- Template for custom dialogs
- Combining browse and edit dialog in the same dialog
- How datarow works with all datasources and even makes easy to handle blob fields like images and other binary data.
Portable Code:
XBrowse and DataRow classes are carefully designed to create highly portable code across different databases, eg dbf, ado, various rdbms, mysql, etc.
Discussion as to how to write portable code that works with all different databases without any change. Limitations, do's and dont's.
XBROWSER(function XBrowse())
- Purpose of XBrowser
- Usage, syntax.
- Extending with setup clause
- Using as pick-list for selection
- As Object browser
- Debug tool during development
- More
OTHER CONTROLS--------------
Unfamilar features of familiar controlsButtonbar
ButtonBmp
TBtnBmp
TXImage
Metro-Look Controls
Translucent backgrounds and usage of alpha colors.
GDI+
TOUCH AND TABLET CAPABILITIES PROVIDED.- Touch and gesture functions already provided in FWH and usage
- Touch friendly controls, like listboxes and comboboxes
- Controls that automatically recognize touch gestures and their behavior.
- Extending touch functionality by the programmer using the functions provided.
- Detecting form-factor: PC or tablet
- Recognition of Tablet mode and Desktop mode switching. Programming considerations
- Recognition of Portait/Landscape Orientation switching. Programming issues
- Hardware change events
- FWH automatic switching between desktop look and universal look
- Event notifications
- Issues to the considered by the programmer while programming for touch enabled
devices including touch keyboards.
- Issues for designing applications to work on different form-factors viz., desktop,
tablet and mobile phone.
- Related issues.
RDBMS=====
RDBMS
SQL
Ansi SQL
Database Design
Data Normalisation
Data Integrity
Optimization
Reduction of load on Server and Network
Query Optimization
Indexes
ADO Connection Object
RecordSet object
Command Object
FWH Classes
TRecSet
TCommand
FWH support for ADO & SQL
Advantages of using FWH functions
FWH-MYSQL/MARIADB LIBRARY=========================
- Introduction
- Benefits in comparision with other alternatives including ADO.
- Choice of Servers: MySql and MariaDB
- Hybrid applications. How applications mainly using others like ADO, Dolphin, etc
can also take benefit of FWHMYSQL, without changing the present code.
Connection Class datas and methods
Rowset Class datas and methods
Backup and Restore( normal and encrypted)
===================
We request participants and users to suggest and propose any new topics to be included as well as modifications to the above proposals.
