Advanced Login

Shows some advanced techniques when logging into an ASTA server, like sending a message from within the server side OnClientLogin event.

AstaSQLExplorer

A client application that displays server side information in a TreeView application and includes Server Methods, Tables, Users, Fields and Index Information. Allows any SQL to be executed. Select statements on single tables are editable in a Delphi grid, as the PrimeKey fields and UpdateTableName are automatically set by the SQLExplorer. Shows advanced ASTA techniques.

AutoServer

ASTA servers and clients can be compiled in the same EXE to provide a single user ASTA application. The AutoServer shows this technique.

BDEMasterDetail

Master/detail example using the AstaBDEServer connected to DBDEMOS data

BDEMasterDetailLocal

Master/detail example that shows how to use filters for master/detail or parameterized queries, and gives an example of how to switch back and forth between these techniques at runtime.

BlobImage

Shows how to fetch a binary file from an ASTA server.

BlobMemo

Shows how to fetch a Memo Field from an ASTA server.

Chat

Chat example using ASTA messaging.

CloneCursor

Shows how to use the CloneCursor call to allow AstaClientDataSets to have copies of itself where all the copied Datasets update the original and stay in sync.

CodedParamList

SendCodedParamList and SendGetCodedParmList are the most flexible ASTA messaging calls. This example shows how to use them.

CompressDataSet

An example of compressing a dataset for faster transport. ASTA datasets are fully streamable, and with fairly static data it is often desirable to compress datasets on the server and transport them to remote clients when needed, without having to do a fresh Select.

ConflictManager

The AstaConflictManagement tutorial shows how to fetch current values from an ASTA server to see if the original fetched values may have changed before a user posts updates to a remote server.

Connect

Shows some advanced techniques on connecting to an ASTA server.

CyclopsSQL

ASTA allows multiple Select statements to be returned in one AstaClientDataSet. This tutorial shows how to return multiple selects from an ASTA server with TAstaDataSets stored in blob fields of a TAstaDataSet.

DataAwareControls

Shows how easy it is to use data aware controls with ASTA.

DataAwareMemo

Shows how to fetch and update blobs and memos with no code using the TAstaClientDataSet.SQLOptions of soFetchBlob and soFetchMemos.

DataSetQA

Test suite to demonstrate the abilities of the TAstaDataset.

DataSetSort

Shows how local sorts can be performed on ASTA datasets using one field or multiple fields.

DataSetTransactions

Shows how to send multiple datasets to an ASTA server and having all the cached updates applied in one transaction.

Disconnect

Shows how to disconnect and connect to an ASTA server.

Encryption

Shows how easy it is to fully encrypt ASTA servers and clients.

ExecParams

Shows how to call ExecSQL of the TAstaClientDataSet with a parameterized query.

ExpresswaySQL

Shows how to return multiple TAstaClientDataSets Selects in one server rournd trip using CyclopsSQL.

FileSend

Shows ASTA messaging techniques to send and get files from a remote server, and how to use the progress bar feature of the AstaClientSocket so that the progress can be visually displayed.

Firewall Isapi

Shows how ASTA clients can use HTTP tunneling to send HTTP formatted messages to a remote web server using the ASTAHTTP.DLL an Isapi DLL. Stateless example.

Firewall Proxy

Shows how ASTA clients can connect to a proxy and run stateless with the proxy relaying the ASTA stream to and from remote ASTA servers.

Firewall SOCKS

SOCKS5 example of using an ASTA client to be able to connect to an ASTA server through a SOCKS5 server with user name and password authentication. This method allows ASTA clients to maintain state yet still use the firewall.

InCodeEdits

Shows how to use the AfterPost EditMode with ASTA.

InMemMasterDetail

Shows a TAstaDataSet (in memory dataset) implementing a master/detail relationship with no code.

InMemoryDataSet

Shows an example of adding 1,000 rows to an ASTADataSet and then filtering and sorting the data locally.

Isapi Blocking Sockets

ASTA sockets are asynchronous and event driven and require a windows message pump in order to operate. Since the ProcessMessage call does not exist within ISAPI DLL’s, using non-blocking sockets is problematic. This tutorials shows how ASTA sockets can use blocking calls so they can operate within ISAPI DLL’s.

ISQLDemo

ISQLDemo shows a simple example to send interactive SQL to ASTA servers. It is recommended that this tutorial be compiled and used to test ASTA servers as SQL selects and execs can be easily executed on remote ASTA servers.

ISQLDemo Multi DataSource

SQL demo that shows multiple data sources on a remote ASTA server if they have been defined. ASTA servers can be coded to handle any number of databases and the AstaClientDataSet.DataBase property can be used to map remote clients to multiple databases on remote ASTA servers.

Login

Shows login techniques with a client and server example.

Messaging

Shows simple ASTA messaging techniques.

MetaData

ASTA servers are capable of returning any and all kind of metadata information. This tutorials shows how to make use of this ability using the TAstaClientDataSet.MetaDataRequest property.

MultiTableSQL

AstaClientDataSets can be made updatable by using the EditMode property. With client SQL, joined tables can also be configured to generate multiple SQL update, insert and delete statements when calling ApplyUpdates. This tutorial shows an example of how to configure an AstaClientDataSet to update multiple tables from a join on the server.

NoCodeThinClient

The first tutorial every ASTA user should run. Shows how an internet enabled ASTA client can be created with no code.

Oracle Long Raw

Shows an example of using the AstaDOAServer (Direct Oracle Access) to use a server method supporting Long Raws.

OracleSequence

ASTA supports refetches of auto increment fields on inserts, but Oracle handles this a different way using Oracle Sequences. This tutorial shows how to use Oracle Sequences with ASTA.

Packet Locates

Shows how to use the new GetNextPacketLocate call of the AstaClientDataSet to call server side open cursors using their Locate method on the server, and to efficiently stream back results.

Packet Queries

When ASTA servers are run in the PersisentSessions threading model, AstaClientDataSets can be set up to do “packet” fetches. This is essentially executing a query on the server and then keeping a cursor open on the server. This tutorial shows how to setup an AstaclientDataSet to do packet fetches.

ParameterizedQuery Transactions

Demonstrates how to create and send any number of parameterized queries from an AstaclientDataSet to a remote ASTA server and have them all execute in one Transaction. The parameters are returned to the AstaClientDataset with either an error message or the number of rows affected in the ParamValue.

Params

Shows how to create and execute a simple parameterized Select query with the AstaClientDataSet.

ProviderBroadcast

Shows how to use TAstaProvider broadcasts where remote AstaClientDataSets can register to be notified when any other client inserts, updates or deletes a row from a particular provider or table.

PublishDirectory

Shows techniques to get a result set containing the published directories as defined on an ASTA server and even to be able to modify them remotely.

Reconnect

Shows how to have an AstaClientSocket automatically reconnect to an ASTA server.

Refetch

Demonstrates how AstaClientDataSets can refetch auto increment fields with no code.

RemoteDirectory

Shows how to use the RemoteDirectory components to define a server Directory Alias so that the ASTA OpenDialog can be used remotely like the normal Delphi OpenDialog.

RunTimeEdit

Shows how the AstaClientDataSet EditMode can be set at runtime.

ServerDataSets

Shows how to access any TDataSet on a remote ASTA server.

Stored Procedure Tester

Shows all the storedprocedures available on a remote ASTA server and then allows the params of any stored proc to be return so that they can be set and then executed.

Stored Procedures

Shows how to use the StoredProcedure property of the TAstaClientDataSet.

Streams

Shows how to send and receive streams with ASTA messaging.

SuitCase

Shows how the ASTA suitcase model works and also shows how to load data from a file, work disconnected and save to a suitcase file.

Transactions

Shows how easy it is to use the Cached EditMode with TAstaClientDatasets.

UpgradeAdmin

Demonstrates how a remote client can manage remote directories and upgrade information that relates to the ASTA AutoClientUpdate mechanism.

UserList

Server side example showing how to manipulate the AstaServerSocket.UserList.

XML

Shows how ASTA supports XML with any TDataSet.

XMLSQL

ASTA SQL demo that also brings back XML from an ASTA XML enabled server.