Programming with TROIA

This is an open and unofficial book to learn TROIA Platform and Programming Language. Although it targets the programmers who are new to TROIA, it also contains useful information for experienced programmers, consultants and system administrators.

• Platform Basics
  • Understanding the Purpose
  • What Does The Platform Offer?
  • Components and Network Architecture Overview
  • Software Architecture Overview
  • About Deployment
• Language Basics
  • Basic Language Elements
  • Some Key Terms
  • Development Tools
  • Hotline
  • Comments in TROIA
• Built-in Data Types
  • Built-in Data Types
  • StringBuilder & String
  • Table
  • Vector
  • Keywords and Identifiers
• Variables and Scope
  • Scope
  • Defining Variables
  • Variable Definition Commands
  • System Variables
  • Some Facts About Defining Variables
• Operators and Expressions
  • Operators
  • Assignment
  • Expressions
  • Type Conversion and Casting
  • Exercise 1: Integer Arithmetic
• Flow Control
  • IF Statement
  • SWITCH Statement
  • WHILE Loop
  • LOOP Command
  • Other Looping Options
  • BREAK & CONTINUE Statements
  • Exercise 1: Fibonacci Numbers
  • Exercise 2: Factorial
• Strings / String Manipulation
  • Some Facts About Strings
  • Escaping & Special Characters
  • Basic String Functions
  • String Concatenation
  • Looping on Strings: PARSE Command
  • Exercise 1: Basic String Functions
  • Exercise 2: List Numeric Tokens
• Dialog Basics
  • Introduction
  • Basic Dialog Events
  • Basics of Controls
  • Switching Between Dialogs
  • Functions & Right Click Menu
  • Timers on Dialog
  • Exercise 1: Counting Words
  • Exercise 2: Defining a Clock with Timer
• Transactions
  • Defining Transactions
  • Transactions and Scope
  • Running & Calling Transactions
  • Input Parameters & TRANSCALLED Event
  • Scheduled Tasks and Batch Transactions
  • Reading Transaction Info
  • Exercise 1: Defining Transaction
• Messages and Alerts
  • MESSAGE Command
  • Message on Batch/Server Transactions
  • Message on Database Transactions
  • Other Alerting Options
  • Exercise 1: Reading Message Text/Answer
• Classes
  • Introduction
  • Basic Class Methods
  • Defining Class Instances
  • Calling Class Methods
  • Accessing Class Members
  • Class Inheritance
  • Exercise 1: Scope of Class Member (Math)
  • Exercise 2: Defining Unexisting Class Instances
• Basics of Table
  • Introduction
  • Defining/Filling Tables
  • Adding Rows To Tables
  • Accessing Table Data
  • Table Flags
  • Looping on Tables
  • Locating on Table
  • Sorting Table Data
  • Working on Tables
  • Data Transfer Between Tables
  • Exercise 1: Compare LOOP Options
  • Exercise 2: Locating Using Hash Index
  • Exercise 3: Sort Users Like a Tree
  • Exercise 4: Copying Rows
• Selecting Data From Database
  • SELECT Command
  • Complex Select Statements
  • Fetching Manually
  • Database Specific Syntax & Functions
  • Application Performance and Database Operations
• Database Connections
  • Basics of DB Connection In TROIA
  • Connecting Different Databases
  • Managing DB Transactions on Mulptiple Connections
  • Dedicated Database Connections for Transactions
• Working With Date/Datetime
  • Date Data Types
  • Type Conversion & Casting on Date Types
  • Some Useful Functions and Variables
  • What is NULLDATE?
  • Min Date & Max Date Concepts
  • Basic Date Formatting/Parsing
  • Database & Date Format
  • Timezone
  • Work Calendar
• Inheritance & Cross
  • What is “Inheritance”?
  • Inheritance on TROIA
  • Using SUPER() Keyword
  • Using SUPER Object
  • What is “Cross”?
  • Cross Levels & Loading Order
  • How to Define Crosses
  • Example 1: Inheriting Class and Overriding Methods
  • Example 2: Understanding Cross Order
• File Operations
  • Introduction
  • Opening/Closing Files
  • Writing Files & Reading Files
  • Copying Files
  • Other File & Directory Operations
  • File Compression
  • Example 1: Read Image in BASE64 Encoding
  • Example 2: Writing Files
  • Example 3: Working With Multiple Files
  • Example 4: Prepare Zip Content
• Custom TROIA Components
  • How Components Stored?
  • Nested Components
  • Accessing Variables Which Defined in Component
  • Calling Dialogs from Components
• Working with FTP Servers
  • Introduction
  • Connection to FTP Server
  • Working Directory
  • Transferring Files
  • Listing Files
  • Creating/Deleting Folders and Files
• Concurrency (Multithreading)
  • What is Concurrency?
  • Concurrency Concepts in TROIA
  • Creating TROIA Threads
  • Defining Semaphores
• Web Services
  • Introduction
  • Service Definition & Permissions
  • Log-in/Log-out over Web Service
  • Listing Available Services
  • Calling Services
  • Encryption
  • Compression
• Parsing XML & JSON
  • Conversion Between XML & JSON
  • Reading XML Structure
  • Some Useful XML Functions
  • Validating XML Documents
  • Parsing XML Documents
  • XML Parsing Examples
  • Exercise 1: Parse using READXMLSTRUCTURE
  • Exercise 2: Parsing Simple XML Documents
  • Exercise 3: Parsing Complex XML Documents
  • Exercise 4: Validation
• HTTP Operations & Calling Web Services
  • Sending data over HTTP Post Method
  • Calling Web Services
• Port Communication (Serial & TCP)
  • Introduction
  • Opening/Closing Serial Ports
  • Opening/Closing TCP Ports
  • Reading Data From Port
  • Writing Data To Port
  • Example 1: Transfering File through Socket
• Shared Libraries & Running Other Programs
  • Introduction to Shared Libraries
  • Using Shared Libraries in TROIA
  • Opening Files with Default App
  • Invoking Other Programs
  • Exercise 1: Checking domain availability
• Appendix I - Related Technologies
• Appendix II - International Promotion Text
• Appendix III - What’s new in the book?