Portable SQL
/documentation/pages/Ref/Portable SQL/index.xml

Portable SQL

Portable SQL
/documentation/pages/Guides/Databases/Working with SQL/Portable SQL.xml
This page contains a general overview of portable SQL and the SQL::Query and SQL::Connection Objects.
SQL Events
/documentation/pages/Ref/Api/Functions/SQL Helper Functions/SQL Events/index.xml
SQL Event functions can be used when performing SQL operations, such Create, Update, and Delete operations and DatabaseSnapshots.
SQL Namespace
Classes to connect to and work with SQL data sources.
SQL Events
/documentation/pages/Ref/Api/Functions/SQL Helper Functions/SQL Events/SQL Events.xml
Three SQL events are available when peforming create, update, and delete operations with Xbasic: UpdateBegin(), UpdateEnd(), UpdateProgress().
SQL Genie
/documentation/pages/Guides/Desktop/Design/Data/SQL/SQL Genie.xml
The SQL Genie creates SQL SELECT statements using Portable SQL.
About SQL
/documentation/pages/Guides/Databases/Working with SQL/About SQL.xml
The language that you use to talk to an AlphaDAO back-end database is SQL. The two most common types of SQL commands that you will want to send to your database are commands that returns a set of records (do not confuse the use of the word "set" here with Alpha Anywhere's Set object) and commands that update, delete, or insert records into the database.
SQL in Desktop
Working with SQL in desktop applications.
SQL::List::Item Method
/documentation/pages/Ref/Api/Namespace/SQL/List/Item Method.xml
The SQL::List::Item() method
SQL::List::Remove Method
/documentation/pages/Ref/Api/Namespace/SQL/List/Remove Method.xml
The SQL::List::Remove() method