Arca incorporates a customized version of the SQLite database engine, adapted to work with Director native types, binary values and Lingo, and offering additional features as UTF8 translation, compression and encryption. However it still maintains almost all SQL functionality offered by the SQLite engine, which includes the majority of SQL92 features. SQLite support for standards is considered one of the best in the software industry, including advanced features like transactions, which are not available on any other database solution for Director at this time.
We recommend that you check the SQL resources page at our site periodically for updated links to SQL tutorials and articles, related to Arca, generic SQL and SQLite specific commands.
Below is a partial list containing the main SQL keywords and functions supported in Arca:
BEGIN TRANSACTION COMMIT TRANSACTION CREATE INDEX CREATE TABLE DELETE DROP INDEX DROP TABLE END TRANSACTION INSERT ROLLBACK TRANSACTION SELECT UPDATE |