Asta Logo AstaIO Tutorials - 3 of 3

Title Tutorial 
Servers AstaIO Cross Platform Servers are available for DbExpress, ADO,BDE, IBExpress with more being added all the time.


SimpleServerMethod
Simple AstaIO Server with some TAstaIOServerMethodExec's on a DataModule. Shows how little code is necessary to write remote procedure calls.

SQLExplorer Client application using a TreeView/ListView that shows all server side information including Database metadata, connected users, providers and Server Methods.


SQLGenerator
Example of how AstaIO generates SQL for server side or client side support. This examples uses an InMemory TAstaIOAuditDataSet to demonstrate how the AstaIOSQLGenerator works.


SQLParser
Demonstrates how to use the AstaIOSQL parser.


UpdateSQL
All of the AstaIO datasets that can modify data, use a TAstaIOSQLGenerator component internally to generate the SQL statements for INSERT / UPDATE / DELETE instructions.

Even though there are many options available for the SQL generation, there is sometimes a need to create a different SQL statement, for example to update multiple tables. TAstaIOUpdateSQL was developed to make that possible.


Asta Technology Group, Inc.
Tel : (208)342-7800