|
One of ASTA's design goals was to relieve the developer from the task of writing update, insert or delete
SQL. This tutorial shows the first step in the process: using ASTA's client side SQL to create a thin
client application that can execute a select statement from a remote ASTA server with no code. With ASTA
you need only write SQL Select statements and your can fetch data from across the internet with NO DLL's
or setup of any kind on the client. |
1. Run an ASTA server.
2. Pull an AstaClientSocket on a form.
3. Set the IPAddress and Port to that of the ASTA server started in Step #1. If running the client
and server on the same machine you may use the 127.0.0.1 "loop back" default address.
4. Pull an AstaclientDataSet on a form along with a DataSource and DBGrid.
5. Pull down the TableName property of the AstaClientDataSet to a table that doesn't have a million
rows.
6. Click on the SQL property and see that the TableName property acted as a shortcut to writing SQL.
If your table is very large write a Where Predicate to limit the result set.
7. Set the AstaClientDataSet.Active property to true. This should design time populate the DataSet.
8. Compile and run the Application. You should see a dialog appear that allows you to add the IPAdress
of your ASTA server. Put in the IPAddress and click Ok.
9. You can run this same application across your lan, wan or the Internet. |
