Difference between revisions of "Category:Grids"

Revision as of 07:39, 15 April 2024

Under Construction

Overview

Split Grid

Data Summaries

Searching Data

Querying Data

Sorting Data

Dynamic Badges

Dynamic Spark Line Charts

Dynamic Spark Bar Charts

Dynamic Ratings

StringList Editor

Data Mapping

Business Rules

MetaData

When you associate metadata with tables or columns, you typically define UI attribute names and values. Wherever the table or column is used in any App when the table is opened, the metadata is read and the attributes are then applied to the UI element.

Changes to the metadata are automatically applied across all Apps. No code changes are required.

This provides a powerful means of data binding with associated business logic all without coding. You define metadata for databases, tables, and columns using the MetaData Editor which is integrated into the Table Designer.

Desktop Browse

The browse command is a favorite with Visual FoxPro developers for building desktop applications.

LianjaScript has an enhanced version of browse with split grid editing and many of the features described in above. With business rules defined in the data dictionary for a table and its columns, browse can be used in desktop applications without compromising data integrity.

Example usage:

browse table southwind!employees splitbar title "Employees" ;
properties "showsplitedit=true;splitmemolist=notes;splitimagelist=photo"

Embedding Desktop Browse in a Custom Section

In desktop Apps you can embed a browse command in a custom section.

Add a custom section to a page then in the custom BROWSE command attribute type:

browse table southwind!employees title "Employees"