ADVPL Course

Lesson 1 • Compiling and Running Programs

Explains the compile-link-run cycle specific to ADVPL. Students execute their first programs and interpret runtime output.

Lesson 2 • ADVPL Language Fundamentals

Introduces ADVPL syntax, data types, and basic constructs. Builds the vocabulary needed for all programming tasks ahead.

Lesson 3 • Overview of Totvs Protheus

Covers the Protheus ERP architecture and how ADVPL fits within it. Provides context for all subsequent development tasks.

Lesson 1 • Functions and Procedures

Defines user functions, static functions, and parameter passing conventions. Modular design principles are introduced here.

Lesson 2 • Operators and Expressions

Covers arithmetic, relational, logical, and string operators. Establishes expression evaluation rules used throughout all programs.

Lesson 3 • Conditional Structures

Teaches IF/ELSEIF/ELSE and DO CASE constructs for branching logic. Students implement decision-driven program flows.

Lesson 4 • Looping and Iteration

Introduces FOR, WHILE, and DO WHILE loops for repetitive processing. Students control iteration with EXIT and LOOP commands.

Lesson 1 • String Manipulation Functions

Covers SUBSTR, ALLTRIM, UPPER, LOWER, STRTRAN, and related functions. Students transform and validate text data reliably.

Lesson 2 • Type Conversion and Validation

Covers VAL, STR, VALTYPE, and input validation patterns. Students prevent runtime errors from mismatched data types.

Lesson 3 • Numeric Formatting and Math

Teaches ROUND, INT, MOD, and formatting functions for numeric output. Ensures accurate financial and statistical calculations.

Lesson 1 • Protheus Database Architecture

Explains the SX-table metadata system and alias-based table access. Provides the conceptual model for all database operations.

Lesson 2 • Inserting, Updating, and Deleting Records

Covers RECLOCK, DBAPPEND, field assignment, and DBDELETE. Students safely modify data with proper locking protocols.

Lesson 3 • Opening and Navigating Tables

Covers DBUSE, DBGOTO, DBSKIP, and index-based navigation commands. Students move through records efficiently and correctly.

Lesson 4 • Querying with SEEK and Filters

Teaches DBSEEK, DBSETFILTER, and DBSETORDER for targeted data retrieval. Students locate specific records without full table scans.

Lesson 1 • Dialog and Window Basics

Covers DEFINE DIALOG, ACTIVATE DIALOG, and window sizing. Establishes the container model for all UI components.

Lesson 2 • Grids and Browse Components

Introduces MSBROWSE and grid controls for tabular data display. Students present record sets in structured, navigable grids.

Lesson 3 • MVC Pattern in Protheus

Explains the Model-View-Controller architecture used in modern Protheus screens. Students separate data logic from presentation code.

Lesson 4 • Validation and User Feedback

Covers field-level validation, HELP messages, and ALERT dialogs. Students enforce data integrity at the UI layer.

Lesson 1 • Defining Headers and Footers

Covers HEADER, FOOTER, and page numbering commands. Students produce professional, consistently branded report pages.

Lesson 2 • Advanced Formatting with FWMSPrinter

Introduces the FWMSPrinter class for pixel-level layout control. Students build complex, multi-column business documents.

Lesson 3 • Detail Lines and Grouping

Teaches DETAIL, GROUP BY, and subtotal accumulation patterns. Students organize report data into meaningful sections.

Lesson 1 • Customizing Standard Screens

Teaches adding fields, changing validations, and modifying screen behavior via entry points. Students tailor standard forms to business requirements.

Lesson 2 • Implementing User Exits

Covers writing and registering user exit functions for standard routines. Students intercept standard processes to add business logic.

Lesson 3 • Customizing Business Rules

Covers intercepting save, delete, and process events to enforce custom rules. Students ensure data integrity beyond standard system behavior.

Lesson 4 • Testing and Maintaining Customizations

Introduces strategies for testing entry points and managing them across upgrades. Students keep customizations stable through system updates.

Lesson 1 • Scheduled Jobs and Background Processing

Teaches APSCHEDULER, STARTTALK, and multi-threading patterns for async tasks. Students offload long-running processes from the UI thread.

Lesson 2 • Consuming External Web Services

Covers HTTPCLIENT, SOAP calls, and XML parsing for third-party integrations. Students connect Protheus to external platforms reliably.

Lesson 3 • REST API Development with ADVPL

Introduces the FWRESTAREA framework for building and consuming REST endpoints. Students expose Protheus data to external systems securely.

Lesson 4 • Object-Oriented Programming in ADVPL

Covers CLASS, METHOD, DATA, and inheritance syntax. Students design reusable, encapsulated components for complex applications.