delphi 7 - asta v3.0 for delphi 7 - manual

8/2/2019 Delphi 7 - ASTA v3.0 for Delphi 7 - Manual

1/682

1997-2002 ASTA Technology Group Inc

ASTA 3 for Delphi


2/682

ASTA SkyWir

Wireless Enabled Web Services and Collaborative Tools

by ASTA Technology Group

ASTA Skywire supports cross platform clients and server toallow for developers to create fast, reliable and secureapplications that run over any network.


3/682

Table of Contents

Foreword 1

Part I ASTA 3 2................................................................................................................................... 41 ASTA 3 New Features

................................................................................................................................... 92 ASTA 2.6 to ASTA 3 Migration Issues

................................................................................................................................... 103 ASTA History

................................................................................................................................... 104 ASTA 3 Tutorials

. .......... ....... ................................................................. .......... ....... ....... ............................................... 11DataSets- In Memory

.......... ....... ................................................................. .......... ....... ....... ............................................... 11Master Detail

.......... ....... ................................................................. .......... ....... ....... ............................................... 12Indexes

.......... ....... ................................................................. .......... ....... ....... ............................................... 12Create Fields

.......................... ............................................................................................................... 13Add a Calculated Field at runtime

. .......... ....... ................................................................. .......... ....... ....... ............................................... 13Client Side SQL

.......... ....... ................................................................. .......... ....... ....... ............................................... 14Aggregates

.......... ....... ................................................................. .......... ....... ....... ............................................... 15CachedUpdates

.......... ....... ................................................................. .......... ....... ....... ............................................... 15Constraints

.......... ....... ................................................................. .......... ....... ....... ............................................... 16Indexes

.......... ....... ................................................................. .......... ....... ....... ............................................... 16MasterDetail

.......... ....... ................................................................. .......... ....... ....... ............................................... 16Sorting

.......... ....... ................................................................. .......... ....... ....... ............................................... 17SuitCase

.......... ....... ................................................................. .......... ....... ....... ............................................... 17Transactions

. .......... ....... ................................................................. .......... ....... ....... ............................................... 17Messaging

.......... ....... ................................................................. .......... ....... ....... ............................................... 19CodedParamList

.......... ....... ................................................................. .......... ....... ....... ............................................... 20CodedDBParamList

.......... ....... ................................................................. .......... ....... ....... ............................................... 20PackingUpData

.......................... ............................................................................................................... 21DataSetParamList

.......................... ............................................................................................................... 21DataSetPackup

.......... ....... ................................................................. .......... ....... ....... ............................................... 22Large FileTransfer

.......................... ............................................................................................................... 22Standard Messaging

.......................... ............................................................................................................... 23Server to Client

.......................... ............................................................................................................... 23Client to Server

. .......... ....... ................................................................. .......... ....... ....... ............................................... 25Server side Techniques

.......... ....... ................................................................. .......... ....... ....... ............................................... 25Provider Text file Updater

.......... ....... ................................................................. .......... ....... ....... ............................................... 27ServerMethod Param Example

.......... ....... ................................................................. .......... ....... ....... ............................................... 28Threaded Server with No Database

. .......... ....... ................................................................. .......... ....... ....... ............................................... 30Feature Testers

.......... ....... ................................................................. .......... ....... ....... ............................................... 30DataSetQA

.......... ....... ................................................................. .......... ....... ....... ............................................... 31ProviderTester

.......... ....... ................................................................. .......... ....... ....... ............................................... 32ServerMethodTester

.......... ....... ................................................................. .......... ....... ....... ............................................... 33SQLDemo and Http Tunneling

.......... ....... ................................................................. .......... ....... ....... ............................................... 34SQLExplorer

.......... ....... ................................................................. .......... ....... ....... ............................................... 35Stored Procedures Tester

. .......... ....... ................................................................. .......... ....... ....... ............................................... 35Security Issues

.......... ....... ................................................................. .......... ....... ....... ............................................... 36Servers and Security

................................................................................................................................... 365 ASTA and .NET

................................................................................................................................... 386 Building Applications with ASTA

. .......... ....... ................................................................. .......... ....... ....... ............................................... 38General Topics

IContents



4/682

.......... ....... ................................................................. .......... ....... ....... ............................................... 38ASTA Jump Start Tips

.......... ....... ................................................................. .......... ....... ....... ............................................... 38ASTA Compression

.......... ....... ................................................................. .......... ....... ....... ............................................... 39Registry Keys Used by ASTA

.......... ....... ................................................................. .......... ....... ....... ............................................... 39Useful Utility Methods

. .......... ....... ................................................................. .......... ....... ....... ............................................... 40Database Discussion

.......... ....... ................................................................. .......... ....... ....... ............................................... 40Client Side SQL vs Coding the Server

.......... ....... ................................................................. .......... ....... ....... ............................................... 40Packet Fetches

.......... ....... ................................................................. .......... ....... ....... ............................................... 41Client/Server Manners

.......... ....... ................................................................. .......... ....... ....... ............................................... 41Distributed Database Networks

.......... ....... ................................................................. .......... ....... ....... ............................................... 43Suitcase Model

.......... ....... ................................................................. .......... ....... ....... ............................................... 44Master Detail Support

.......... ....... ................................................................. .......... ....... ....... ............................................... 44Asyncronous Database Access

.......... ....... ................................................................. .......... ....... ....... ............................................... 46Multi Table Updates from Joins

.......... ....... ................................................................. .......... ....... ....... ............................................... 46SQL Generation

.......... ....... ................................................................. .......... ....... ....... ............................................... 47More on SQL Generation

. .......... ....... ................................................................. .......... ....... ....... ............................................... 49ASTA Clients

.......... ....... ................................................................. .......... ....... ....... ............................................... 49ASTA Jump Start Tips

.......... ....... ................................................................. .......... ....... ....... ............................................... 50ASTA SmartWait

.......... ....... ................................................................. .......... ....... ....... ............................................... 50ASTA State and Stateless Clients

.......... ....... ................................................................. .......... ....... ....... ............................................... 51Cached Updates

.......... ....... ................................................................. .......... ....... ....... ............................................... 53Parameterized Queries in a Transaction

.......... ....... ................................................................. .......... ....... ....... ............................................... 54Refetching Data on Inserts and Updates

.......... ....... ................................................................. .......... ....... ....... ............................................... 55Streaming Asta Datasets

. .......... ....... ................................................................. .......... ....... ....... ............................................... 55ASTA Servers

.......... ....... ................................................................. .......... ....... ....... ............................................... 56AstaServerFormat

.......................... ............................................................................................................... 57AstaServerFormat.RemoteAdmin

.......................... ............................................................................................................... 58AstaServerFormat.RemoteControl

.......................... ............................................................................................................... 59AstaServerFormat.CodingTheServer

.......................... ............................................................................................................... 59AstaServerFormat.Messaging

.......................... ............................................................................................................... 60AstaServerFormat.DatabaseSupport

.......................... ............................................................................................................... 60AstaServerFormat.NTService

.......... ....... ................................................................. .......... ....... ....... ............................................... 61ASTA Database Server Support

.......... ....... ................................................................. .......... ....... ....... ............................................... 62ASTA Middleware Triggers

.......... ....... ................................................................. .......... ....... ....... ............................................... 63ASTA Server Admin

.......... ....... ................................................................. .......... ....... ....... ............................................... 64ASTA Server Logging

.......... ....... ................................................................. .......... ....... ....... ............................................... 65ASTA Servers and Multiple DataSources

.......... ....... ................................................................. .......... ....... ....... ............................................... 67ASTA Servers and Visual Interfaces

.......... ....... ................................................................. .......... ....... ....... ............................................... 67Building ASTA Servers

.......... ....... ................................................................. .......... ....... ....... ............................................... 68Coding ASTA Servers

.......... ....... ................................................................. .......... ....... ....... ............................................... 69Command Line Switches

.......... ....... ................................................................. .......... ....... ....... ............................................... 69Data Modules on ASTA Servers

.......... ....... ................................................................. .......... ....... ....... ............................................... 70Login Process

.......... ....... ................................................................. .......... ....... ....... ............................................... 71Server Side Programming

.......... ....... ................................................................. .......... ....... ....... ............................................... 71Threading

.......................... ............................................................................................................... 71Threading ASTA Servers

.......................... ............................................................................................................... 72General Threading Tips

.......................... ............................................................................................................... 72Persistent Threading Model

.......................... ............................................................................................................... 74ASTA Smart Threading

.......... ....... ................................................................. .......... ....... ....... ............................................... 76UseRegistry

. .......... ....... ................................................................. .......... ....... ....... ............................................... 77ASTA Messaging

.......... ....... ................................................................. .......... ....... ....... ............................................... 78More on ASTA Messaging

.......... ....... ................................................................. .......... ....... ....... ............................................... 81ParamList Messaging

.......... ....... ................................................................. .......... ....... ....... ............................................... 84Transfering Large or Groups of Files

. .......... ....... ................................................................. .......... ....... ....... ............................................... 84ASTA Tools

ASTA 3 for DelphiII



5/682

.......... ....... ................................................................. .......... ....... ....... ............................................... 84Asta Anchor Server

.......... ....... ................................................................. .......... ....... ....... ............................................... 85ASTA Conversion Wizard

.......... ....... ................................................................. .......... ....... ....... ............................................... 86ASTA Proxy Server

.......... ....... ................................................................. .......... ....... ....... ............................................... 86AstaServerLauncher

.......... ....... ................................................................. .......... ....... ....... ............................................... 86AstaSeverLauncherNTS

.......... ....... ................................................................. .......... ....... ....... ............................................... 87AstaSQLExplorer

. .......... ....... ................................................................. .......... ....... ....... ............................................... 88Automatic Client Updates

.......... ....... ................................................................. .......... ....... ....... ............................................... 88Asta Remote Administrative API

. .......... ....... ................................................................. .......... ....... ....... ............................................... 90Firewalls

.......... ....... ................................................................. .......... ....... ....... ............................................... 90Using ASTA through a Firewall

.......................... ............................................................................................................... 91Maintain State

............. ....... ............................................................................................................... 91Solution #1: Open a Port

............. ....... ............................................................................................................... 91Solution #2: Run the ASTA Server on Port 80

............. ....... ............................................................................................................... 92Solution #3: SOCKS Support

............. ....... ............................................................................................................... 92Solution #4: ASTA Proxy Server

.......................... ............................................................................................................... 93Stateless Firewall

............. ....... ............................................................................................................... 93Solution #1: Use WinInet (Highly Recommended)

............. ....... ............................................................................................................... 93Solution #2: HTTP Stateless with IIS running remotely

............. ....... ............................................................................................................... 94Solution #3: Through a Proxy Server

.......... ....... ................................................................. .......... ....... ....... ............................................... 95Stateless Clients

.......... ....... ................................................................. .......... ....... ....... ............................................... 97ASTA HTTP Tunneling

.......... ....... ................................................................. .......... ....... ....... ............................................... 98Setting Up IIS

. .......... ....... ................................................................. .......... ....... ....... ............................................... 99Provider Broadcasts

.......... ....... ................................................................. .......... ....... ....... ............................................... 99Manual Provider Broadcasts

.......................... ....... ....... ................................................................................................................. 100Automatic Provider Broadcasts

.......................... ....... ....... ................................................................................................................. 101Provider Bite at the Apple

.......................... ....... ....... ................................................................................................................. 102Caching Provider MetaData

.......................... ....... ....... ................................................................................................................. 103What Data is Sent in Provider Broadcasts

.................................................... ....... ....... ....... ................................................................................. 104Security Issues

.................................................... ....... ....... ....... ................................................................................. 105Sockets and TCP/IP Issues

.......................... ....... ....... ................................................................................................................. 106ASTA Transports

.......................... ....... ....... ................................................................................................................. 107Asta and Blocking Sockets

.......................... ....... ....... ................................................................................................................. 108ASTA in an ISAPI DLL

.......................... ....... ....... ................................................................................................................. 109Early Connect

.......................... ....... ....... ................................................................................................................. 110Socket Errors

.......................... ....... ....... ................................................................................................................. 111TCustomWinSocket

.................................................... ....... ....... ....... ................................................................................. 111XML Support

.................................................... ....... ....... ....... ................................................................................. 113Cross Platform Support

................................................................................................................................... 1147 Developing for the Internet

.................................................... ....... ....... ....... ................................................................................. 114Database Application Development

.......................... ....... ....... ................................................................................................................. 114File Server

.......................... ....... ....... ................................................................................................................. 115Client Server

.......................... ....... ....... ................................................................................................................. 117Internet and Web Development

.................................................... ....... ....... ....... ................................................................................. 118Web Development and Application Servers

.................................................... ....... ....... ....... ................................................................................. 119Beyond the Browser

.................................................... ....... ....... ....... ................................................................................. 121Additional Tables and Features

.......................... ....... ....... ................................................................................................................. 121ASTA Framework

.......................... ....... ....... ................................................................................................................. 123TCP/IP and HTTP Clients

.......................... ....... ....... ................................................................................................................. 124ServerMethods as SOAP Services

.......................... ....... ....... ................................................................................................................. 125Business to Business

.......................... ....... ....... ................................................................................................................. 126Cross Platform/Device/Protocol

................................................................................................................................... 1268 ASTA Components

.................................................... ....... ....... ....... ................................................................................. 127Client Side

IIIContents



6/682

.......................... ....... ....... ................................................................................................................. 127TAstaDataset

.......... ....... ....... ................................................................................................................. 128Properties

.... ....... ....... ................................................................................................................. 129TAstaDataSet.Aggregates

.... ....... ....... ................................................................................................................. 129TAstaDataset.FieldsDefine

.... ....... ....... ................................................................................................................. 130TAstaDataset.Indexes

.... ....... ....... ................................................................................................................. 131TAstaDataSet.IndexFieldCount

.... ....... ....... ................................................................................................................. 131TAstaDataSet.IndexFieldNames

.... ....... ....... ................................................................................................................. 131TAstaDataSet.IndexFields

.... ....... ....... ................................................................................................................. 131TAstaDataSet.IndexName

.... ....... ....... ................................................................................................................. 132TAstaDataSet.KeyExclusive

.... ....... ....... ................................................................................................................. 132TAstaDataSet.KeyFieldCount

.... ....... ....... ................................................................................................................. 132TAstaDataSet.MasterFields

.... ....... ....... ................................................................................................................. 133TAstaDataSet.MasterSource

.... ....... ....... ................................................................................................................. 133TAstaDataSet.ReadOnly

.... ....... ....... ................................................................................................................. 133TAstaDataSet.StreamOptions

.......... ....... ....... ................................................................................................................. 135Methods

.... ....... ....... ................................................................................................................. 137TAstaDataSet.AddBookmarkIndex

.... ....... ....... ................................................................................................................. 137TAstaDataSet.AddIndex

.... ....... ....... ................................................................................................................. 137TAstaDataSet.AddIndexFields

.... ....... ....... ................................................................................................................. 137TAstaDataSet.ApplyRange

.... ....... ....... ................................................................................................................. 138TAstaDataSet.CancelRange

.... ....... ....... ................................................................................................................. 138TAstaDataSet.CleanCloneFromDataSet

.... ....... ....... ................................................................................................................. 138TAstaDataSet.CloneCursor

.... ....... ....... ................................................................................................................. 138TAstaDataSet.CloneFieldsFromDataSet

.... ....... ....... ................................................................................................................. 138TAstaDataSet.CloneFieldsFromDataSetPreserveFields

.... ....... ....... ................................................................................................................. 139TAstaDataSet.CompareFields

.... ....... ....... ................................................................................................................. 139TAstaDataSet.DataTransfer

.... ....... ....... ................................................................................................................. 139TAstaDataSet.DefineSortOrder

.... ....... ....... ................................................................................................................. 139TAstaDataSet.EditKey

.... ....... ....... ................................................................................................................. 140TAstaDataSet.EditRangeEnd

.... ....... ....... ................................................................................................................. 140TAstaDataSet.EditRangeStart

.... ....... ....... ................................................................................................................. 140TAstaDataSet.Empty

.... ....... ....... ................................................................................................................. 140TAstaDataSet.FastFieldDefine

.... ....... ....... ................................................................................................................. 140TAstaDataSet.FilterCount

.... ....... ....... ................................................................................................................. 141TAstaDataSet.FindKey

.... ....... ....... ................................................................................................................. 141TAstaDataSet.FindNearest

.... ....... ....... ................................................................................................................. 141TAstaDataSet.GetRecordSize

.... ....... ....... ................................................................................................................. 141TAstaDataSet.GotoKey

.... ....... ....... ................................................................................................................. 142TAstaDataSet.GoToNearest

.... ....... ....... ................................................................................................................. 142TAstaDataSet.IsBlobField

.... ....... ....... ................................................................................................................. 142TAstaDataSet.LastNamedSort

.... ....... ....... ................................................................................................................. 142TAstaDataSet.LoadFromFile

.... ....... ....... ................................................................................................................. 143TAstaDataSet.LoadFromFileWithFields

.... ....... ....... ................................................................................................................. 143TAstaDataSet.LoadFromStream

.... ....... ....... ................................................................................................................. 143TAstaDataSet.LoadFromStreamwithFields

.... ....... ....... ................................................................................................................. 144TAstaDataSet.LoadFromString

.... ....... ....... ................................................................................................................. 144TAstaDataSet.NukeAllFieldInfo

.... ....... ....... ................................................................................................................. 144TAstaDataSet.RemoveSortOrder

.... ....... ....... ................................................................................................................. 144TAstaDataSet.SaveToFile

.... ....... ....... ................................................................................................................. 145TAstaDataSet.SaveToStream

.... ....... ....... ................................................................................................................. 145TAstaDataSet.SaveToString

.... ....... ....... ................................................................................................................. 145TAstaDataSet.SaveToXML

.... ....... ....... ................................................................................................................. 145TAstaDataSet.SetKey

.... ....... ....... ................................................................................................................. 146TAstaDataSet.SetRange

ASTA 3 for DelphiIV



7/682

.... ....... ....... ................................................................................................................. 146TAstaDataSet.SetRangeEnd

.... ....... ....... ................................................................................................................. 146TAstaDataSet.SetRangeStart

.... ....... ....... ................................................................................................................. 147TAstaDataSet.SortDataSetByFieldName

.... ....... ....... ................................................................................................................. 147TAstaDataSet.SortDataSetByFieldNames

.... ....... ....... ................................................................................................................. 147TAstaDataSet.SortOrderSort

.... ....... ....... ................................................................................................................. 147TAstaDataSet.UnRegisterClone

.... ....... ....... ................................................................................................................. 147TAstaDataSet.ValidBookMark.......... ....... ....... ................................................................................................................. 148Events

.... ....... ....... ................................................................................................................. 148TAstaDataset.OnStreamEvent

.......... ....... ....... ................................................................................................................. 148Functions for Working With TAstaDataSets

.... ....... ....... ................................................................................................................. 149FilteredDataSetToString

.... ....... ....... ................................................................................................................. 149DataSetToStringWithFieldProperties

.... ....... ....... ................................................................................................................. 149StringToStream

.... ....... ....... ................................................................................................................. 149StringToDataSetWithFieldProperties

.... ....... ....... ................................................................................................................. 150Sorting Datasets

.... ....... ....... ................................................................................................................. 150DataSetToString

.... ....... ....... ................................................................................................................. 150CloneDataSetToString

.... ....... ....... ................................................................................................................. 150StringToDataSet

.......................... ....... ....... ................................................................................................................. 151TAstaClientDataSet

.......... ....... ....... ................................................................................................................. 151Properties

.... ....... ....... ................................................................................................................. 153TAstaClientDataSet.Aggregates

.... ....... ....... ................................................................................................................. 153TAstaClientDataSet.Ascending

.... ....... ....... ................................................................................................................. 153TAstaClientDataSet.AstaClientSocket

.... ....... ....... ................................................................................................................. 154TAstaClientDataSet.AutoFetchPackets

.... ....... ....... ................................................................................................................. 155TAstaClientDataSet.AutoIncrementField

.... ....... ....... ................................................................................................................. 155TAstaClientDataSet.DataBase

.... ....... ....... ................................................................................................................. 156TAstaClientDataSet.EditMode

.... ....... ....... ................................................................................................................. 156TAstaClientDataSet.ExtraParams

.... ....... ....... ................................................................................................................. 156TAstaClientDataSet.Indexes

.... ....... ....... ................................................................................................................. 157TAstaClientDataSet.IndexFieldCount

.... ....... ....... ................................................................................................................. 157TAstaClientDataSet.IndexFieldNames

.... ....... ....... ................................................................................................................. 158TAstaClientDataSet.IndexFields

.... ....... ....... ................................................................................................................. 158TAstaClientDataSet.IndexName

.... ....... ....... ................................................................................................................. 158TAstaClientDataSet.IndexPrimeKey

.... ....... ....... ................................................................................................................. 158TAstaClientDataSet.KeyExclusive

.... ....... ....... ................................................................................................................. 159TAstaClientDataSet.KeyFieldCount

.... ....... ....... ................................................................................................................. 159TAstaClientDataSet.MasterFields

.... ....... ....... ................................................................................................................. 159TAstaClientDataSet.MasterSource

.... ....... ....... ................................................................................................................. 159TAstaClientDataSet.MetaDataRequest

.... ....... ....... ................................................................................................................. 160TAstaClientDataSet.NoSQLFields

.... ....... ....... ................................................................................................................. 160TAstaClientDataSet.OldValuesDataSet

.... ....... ....... ................................................................................................................. 160TAstaClientDataSet.OracleSequence

.... ....... ....... ................................................................................................................. 162TAstaClientDataSet.OrderBy

.... ....... ....... ................................................................................................................. 162TAstaClientDataSet.Params

.... ....... ....... ................................................................................................................. 163TAstaClientDataSet.PrimeFields

.... ....... ....... ................................................................................................................. 163TAstaClientDataSet.ProviderBroadCast

.... ....... ....... ................................................................................................................. 163TAstaClientDataSet.ProviderBroadCast.BroadCastAction

.... ....... ....... ................................................................................................................. 164TAstaClientDataSet.ProviderBroadCast.CachedBroadCastsWhenEdit

.... ....... ....... ................................................................................................................. 164TAstaClientDataSet.ProviderBroadCast.MergeEditRowBroadCasts

.... ....... ....... ................................................................................................................. 165TAstaClientDataSet.ProviderBroadCast.ProviderFilter

.... ....... ....... ................................................................................................................. 165TAstaClientDataSet.ProviderBroadCast.RegisterForBroadcast

.... ....... ....... ................................................................................................................. 165TAstaClientDataSet.ProviderBroadCast.RetrievePrimeKeyFields

.... ....... ....... ................................................................................................................. 165TAstaclientDataSet.ProviderName

VContents



8/682

.... ....... ....... ................................................................................................................. 166TAstaClientDataSet.ReadOnly

.... ....... ....... ................................................................................................................. 166TAstaClientDataSet.RefetchOnInsert

.... ....... ....... ................................................................................................................. 167TAstaClientDataSet.ResetFieldsOnSQLChanges

.... ....... ....... ................................................................................................................. 167TAstaClientDataSet.RowsAffected

.... ....... ....... ................................................................................................................. 167TAstaClientDataSet.RowsToReturn

.... ....... ....... ................................................................................................................. 167TAstaClientDataSet.ServerDataSet

.... ....... ....... ................................................................................................................. 169TAstaClientDataSet.ServerMethod

.... ....... ....... ................................................................................................................. 170TAstaClientDataSet.ShowQueryProgress

.... ....... ....... ................................................................................................................. 170TAstaClientDataSet.SQL

.... ....... ....... ................................................................................................................. 170TAstaClientDataSet.SQLGenerateLocation

.... ....... ....... ................................................................................................................. 171TAstaClientDataSet.SQLOptions

.... ....... ....... ................................................................................................................. 171TAstaClientDataSet.SQLWorkBench

.... ....... ....... ................................................................................................................. 172TAstaClientDataSet.StoredProcedure

.... ....... ....... ................................................................................................................. 172TAstaClientDataSet.StreamOptions

.... ....... ....... ................................................................................................................. 173TAstaClientDataSet.SuitCaseData

.... ....... ....... ................................................................................................................. 173TAstaClientDataSet.TableName

.... ....... ....... ................................................................................................................. 173TAstaClientDataSet.UpdateMethod

.... ....... ....... ................................................................................................................. 174TAstaClientDataSet.UpdateMode

.... ....... ....... ................................................................................................................. 174TAstaClientDataSet.UpdateObject

.... ....... ....... ................................................................................................................. 174TAstaClientDateSet.UpdateTableName

.......... ....... ....... ................................................................................................................. 175Methods

.... ....... ....... ................................................................................................................. 177TAstaClientDataSet.AddBookmarkIndex

.... ....... ....... ................................................................................................................. 178TAstaClientDataSet.AddIndex

.... ....... ....... ................................................................................................................. 178TAstaClientDataSet.AddIndexFields

.... ....... ....... ................................................................................................................. 178TAstaClientDataSet.AddParameterizedQuery

.... ....... ....... ................................................................................................................. 178TAstaClientDataSet.ApplyBulkUpdates

.... ....... ....... ................................................................................................................. 179TAstaClientDataSet.ApplyRange

.... ....... ....... ................................................................................................................. 179TAstaClientDataSet.ApplyUpdates

.... ....... ....... ................................................................................................................. 179TAstaClientDataSet.CancelRange

.... ....... ....... ................................................................................................................. 179TAstaClientDataSet.CancelUpdates

.... ....... ....... ................................................................................................................. 180TAstaClientDataSet.CleanCloneFromDataSet

.... ....... ....... ................................................................................................................. 180TAstaClientDataSet.ClearParameterizedQuery

.... ....... ....... ................................................................................................................. 180TAstaClientDataSet.CloneCursor

.... ....... ....... ................................................................................................................. 180TAstaClientDataSet.CloneFieldsFromDataSet

.... ....... ....... ................................................................................................................. 180TAstaClientDataSet.CloneFieldsFromDataSetPreserveFields

.... ....... ....... ................................................................................................................. 181TAstaClientDataSet.CloseQueryOnServer

.... ....... ....... ................................................................................................................. 181TAstaClientDataSet.CompareFields

.... ....... ....... ................................................................................................................. 181TAstaClientDataSet.DataTransfer

.... ....... ....... ................................................................................................................. 181TAstaClientDataSet.DeleteNoCache

.... ....... ....... ................................................................................................................. 181TAstaClientDataSet.DeltaAsSQL

.... ....... ....... ................................................................................................................. 182TAstaClientDataSet.DeltaChanged

.... ....... ....... ................................................................................................................. 182TAstaClientDataSet.EditKey

.... ....... ....... ................................................................................................................. 182TAstaClientDataSet.EditRangeEnd

.... ....... ....... ................................................................................................................. 183TAstaClientDataSet.EditRangeStart

.... ....... ....... ................................................................................................................. 183TAstaClientDataSet.Empty

.... ....... ....... ................................................................................................................. 183TAstaClientDataSet.EmptyCache

.... ....... ....... ................................................................................................................. 183TAstaClientDataSet.ExecQueryInTransaction

.... ....... ....... ................................................................................................................. 183TAstaClientDataSet.ExecSQL

.... ....... ....... ................................................................................................................. 184TAstaClientDataSet.ExecSQLString

.... ....... ....... ................................................................................................................. 184TAstaClientDataSet.ExecSQLTransaction

.... ....... ....... ................................................................................................................. 184TAstaClientDataSet.ExecSQLWithInputParams

.... ....... ....... ................................................................................................................. 184TAstaClientDataSet.ExecSQLWithParams

.... ....... ....... ................................................................................................................. 185TAstaClientDataSet.FastFieldDefine

.... ....... ....... ................................................................................................................. 185TAstaClientDataSet.FetchBlob

ASTA 3 for DelphiVI



9/682

.... ....... ....... ................................................................................................................. 185TAstaClientDataSet.FetchBlobString

.... ....... ....... ................................................................................................................. 186TAstaClientDataSet.FieldNameSendBlobToServer

.... ....... ....... ................................................................................................................. 186TAstaClientDataSet.FilterCount

.... ....... ....... ................................................................................................................. 186TAstaClientDataSet.FindKey

.... ....... ....... ................................................................................................................. 186TAstaClientDataSet.FindNearest

.... ....... ....... ................................................................................................................. 187TAstaClientDataSet.FormatFieldforSQL

.... ....... ....... ................................................................................................................. 187TAstaClientDataSet.GetNextPacket

.... ....... ....... ................................................................................................................. 187TAstaClientDataSet.GetNextPacketLocate

.... ....... ....... ................................................................................................................. 188TAstaClientDataSet.GetRefetchStatus

.... ....... ....... ................................................................................................................. 188TAstaClientDataSet.GotoKey

.... ....... ....... ................................................................................................................. 188TAstaClientDataSet.GoToNearest

.... ....... ....... ................................................................................................................. 188TAstaClientDataSet.LastNamedSort

.... ....... ....... ................................................................................................................. 189TAstaClientDataSet.LoadFromFile

.... ....... ....... ................................................................................................................. 189TAstaClientDataSet.LoadFromFileWithFields

.... ....... ....... ................................................................................................................. 189TAstaClientDataSet.LoadFromStream

.... ....... ....... ................................................................................................................. 189TAstaClientDataSet.LoadFromStreamWithFields

.... ....... ....... ................................................................................................................. 189TAstaClientDataSet.LoadFromString

.... ....... ....... ................................................................................................................. 190TAstaClientDataSet.LoadFromXML

.... ....... ....... ................................................................................................................. 190TAstaClientDataSet.NukeAllFieldInfo

.... ....... ....... ................................................................................................................. 190TAstaClientDataSet.OpenNoFetch

.... ....... ....... ................................................................................................................. 190TAstaClientDataSet.OpenWithBlockingSocket

.... ....... ....... ................................................................................................................. 191TAstaClientDataSet.ParamByName

.... ....... ....... ................................................................................................................. 191TAstaClientDataSet.ParamQueryCount

.... ....... ....... ................................................................................................................. 192TAstaClientDataSet.PopSQLFromParser

.... ....... ....... ................................................................................................................. 192TAstaClientDataSet.Prepare

.... ....... ....... ................................................................................................................. 192TAstaClientDataSet.PrimeFieldsWhereString

.... ....... ....... ................................................................................................................. 192TAstaClientDataSet.PushSQLToParser

.... ....... ....... ................................................................................................................. 193TAstaClientDataSet.ReadField

.... ....... ....... ................................................................................................................. 193TAstaClientDataSet.RefireSQL

.... ....... ....... ................................................................................................................. 193TAstaClientDataSet.ReFireSQLBookMark

.... ....... ....... ................................................................................................................. 193TAstaClientDataSet.RefreshFromServer

.... ....... ....... ................................................................................................................. 193TAstaClientDataSet.RegisterProviderForUpdates

.... ....... ....... ................................................................................................................. 194TAstaClientDataSet.RemoveSortOrder

.... ....... ....... ................................................................................................................. 194TAstaClientDataSet.ResetFieldsOnSQLChanges

.... ....... ....... ................................................................................................................. 194TAstaClientDataSet.RevertRecord

.... ....... ....... ................................................................................................................. 194TAstaClientDataSet.SaveSuitCaseData

.... ....... ....... ................................................................................................................. 194TAstaClientDataSet.SaveToFile

.... ....... ....... ................................................................................................................. 195TAstaClientDataSet.SaveToStream

.... ....... ....... ................................................................................................................. 195TAstaClientDataSet.SaveToString

.... ....... ....... ................................................................................................................. 195TAstaClientDataSet.SaveToXML

.... ....... ....... ................................................................................................................. 195TAstaClientDataSet.SendBlobToServer

.... ....... ....... ................................................................................................................. 196TAstaClientDataSet.SendParameterizedQueries

.... ....... ....... ................................................................................................................. 196TAstaClientDataSet.SendSQLStringTransaction

.... ....... ....... ................................................................................................................. 196TAstaClientDataSet.SendSQLTransaction

.... ....... ....... ................................................................................................................. 196TAstaClientDataSet.SendStringAsBlobToServer

.... ....... ....... ................................................................................................................. 197TAstaClientDataSet.SendStringListToServer

.... ....... ....... ................................................................................................................. 197TAstaClientDataSet.SetEditMode

.... ....... ....... ................................................................................................................. 197TAstaClientDataSet.SetKey

.... ....... ....... ................................................................................................................. 198TAstaClientDataSet.SetPrimeKeyFieldsFromProvider

.... ....... ....... ................................................................................................................. 198TAstaClientDataSet.SetRange

.... ....... ....... ................................................................................................................. 198TAstaClientDataSet.SetRangeEnd

.... ....... ....... ................................................................................................................. 199TAstaClientDataSet.SetRangeStart

.... ....... ....... ................................................................................................................. 199TAstaClientDataSet.SetSQLString

.... ....... ....... ................................................................................................................. 199TAstaClientDataSet.SetToConnectedMasterDetail

VIIContents



10/682

.... ....... ....... ................................................................................................................. 200TAstaClientDataSet.SetToDisConnectedMasterDetail

.... ....... ....... ................................................................................................................. 200TAstaClientDataSet.SortDataSetByFieldName

.... ....... ....... ................................................................................................................. 201TAstaClientDataSet.SortDataSetByFieldNames

.... ....... ....... ................................................................................................................. 201TAstaClientDataSet.SortOrderSort

.... ....... ....... ................................................................................................................. 201TAstaClientDataSet.UnRegisterClone

.... ....... ....... ................................................................................................................. 201TAstaClientDataSet.UnRegisterProviderForUpdates

.... ....... ....... ................................................................................................................. 201TAstaClientDataSet.UpdatesPending

.... ....... ....... ................................................................................................................. 202TAstaClientDataSet.ValidBookmark

.......... ....... ....... ................................................................................................................. 203Events

.... ....... ....... ................................................................................................................. 203TAstaClientDataSet.AfterRefetchOnInsert

.... ....... ....... ................................................................................................................. 204TAstaClientDataSet.OnAfterBroadcastHandling

.... ....... ....... ................................................................................................................. 204TAstaClientDataSet.OnAfterPopulate

.... ....... ....... ................................................................................................................. 204TAstaClientDataSet.OnBeforeBroadcastHandling

.... ....... ....... ................................................................................................................. 204TAstaClientDataSet.OnCommitAnySucessError

.... ....... ....... ................................................................................................................. 205TAstaClientDataSet.OnCustomServerAction

.... ....... ....... ................................................................................................................. 205TAstaClientDataSet.OnProviderBroadCast

.... ....... ....... ................................................................................................................. 206TAstaClientDataSet.OnProviderBroadCastAfterApplyRow

.... ....... ....... ................................................................................................................. 206TAstaClientDataSet.OnProviderBroadCastBeforeApplyRow

.... ....... ....... ................................................................................................................. 206TAstaClientDataSet.OnProviderBroadCastDeleteEditRow

.... ....... ....... ................................................................................................................. 206TAstaClientDataSet.OnProviderBroadcastEditRow

.... ....... ....... ................................................................................................................. 207TAstaClientDataSet.OnReceiveBlobStream

.... ....... ....... ................................................................................................................. 207TAstaClientDataSet.OnReceiveParams

.... ....... ....... ................................................................................................................. 207TAstaClientDataSet.OnStreamEvent

.......................... ....... ....... ................................................................................................................. 208TAstaClientSocket

.......... ....... ....... ................................................................................................................. 208Properties

.... ....... ....... ................................................................................................................. 209TAstaClientSocket.Active

.... ....... ....... ................................................................................................................. 210TAstaClientSocket.Address

.... ....... ....... ................................................................................................................. 210TAstaClientSocket.AnchorStatus

.... ....... ....... ................................................................................................................. 210TAstaClientSocket.ApplicationName

.... ....... ....... ................................................................................................................. 211TAstaClientSocket.ApplicationVersion

.... ....... ....... ................................................................................................................. 211TAstaClientSocket.AstaServerVersion

.... ....... ....... ................................................................................................................. 211TAstaClientSocket.AutoLoginDlg

.... ....... ....... ................................................................................................................. 212TAstaclientSocket.ClientSocketParams

.... ....... ....... ................................................................................................................. 212TAstaClientSocket.ClientType

.... ....... ....... ................................................................................................................. 212TAstaClientSocket.Compression

.... ....... ....... ................................................................................................................. 213TAstaClientSocket.ConnectAction

.... ....... ....... ................................................................................................................. 214TAstaClientSocket.Connected

.... ....... ....... ................................................................................................................. 214TAstaClientSocket.ConnectionString

.... ....... ....... ................................................................................................................. 214TAstaClientSocket.CursorOnQueries

.... ....... ....... ................................................................................................................. 214TAstaClientSocket.DataSetCount

.... ....... ....... ................................................................................................................. 215TAstaClientSocket.DataSets

.... ....... ....... ................................................................................................................. 215TAstaClientSocket.DTPassword

.... ....... ....... ................................................................................................................. 215TAstaClientSocket.DTUserName

.... ....... ....... ................................................................................................................. 216TAstaClientSocket.Encryption

.... ....... ....... ................................................................................................................. 216TAstaClientSocket.Host

.... ....... ....... ................................................................................................................. 217TAstaClientSocket.KeepAlivePing

.... ....... ....... ................................................................................................................. 217TAstaClientSocket.LoginMaxAttempts

.... ....... ....... ................................................................................................................. 217TAstaClientSocket.Password

.... ....... ....... ................................................................................................................. 217TAstaClientSocket.Port

.... ....... ....... ................................................................................................................. 218TAstaClientSocket.ProgressBar

.... ....... ....... ................................................................................................................. 218TAstaClientSocket.SocksServerAddress

.... ....... ....... ................................................................................................................. 218TAstaClientSocket.SocksServerPort

.... ....... ....... ................................................................................................................. 218TAstaClientSocket.SocksUserName

.... ....... ....... ................................................................................................................. 219TAstaClientSocket.SQLDialect

ASTA 3 for DelphiVIII



11/682

.... ....... ....... ................................................................................................................. 219TAstaClientSocket.SQLErrorHandling

.... ....... ....... ................................................................................................................. 219TAstaClientSocket.SQLOptions

.... ....... ....... ................................................................................................................. 220TAstaClientSocket.SQLTransactionEnd

.... ....... ....... ................................................................................................................. 220TAstaClientSocket.SQLTransactionStart

.... ....... ....... ................................................................................................................. 220TAstaClientSocket.StatusBar

.... ....... ....... ................................................................................................................. 220TAstaClientSocket.UpdateSQLSyntax

.... ....... ....... ................................................................................................................. 221TAstaClientSocket.UserName

.... ....... ....... ................................................................................................................. 221TAstaClientSocket.WebServer

.......... ....... ....... ................................................................................................................. 222Methods

.... ....... ....... ................................................................................................................. 222TAstaClientSocket.AddDataSet

.... ....... ....... ................................................................................................................. 222TAstaClientSocket.CloseTheSocket

.... ....... ....... ................................................................................................................. 223TAstaClientSocket.CommandLinePortcheck

.... ....... ....... ................................................................................................................. 223TAstaClientSocket.ExpressWayDataSetSelect

.... ....... ....... ................................................................................................................. 223TAstaClientSocket.FastConnect

.... ....... ....... ................................................................................................................. 224TAstaClientSocket.FastConnectCombo

.... ....... ....... ................................................................................................................. 224TAstaClientSocket.FieldIsRegisteredForTrigger

.... ....... ....... ................................................................................................................. 224TAstaClientSocket.GetCodedParamList

.... ....... ....... ................................................................................................................. 224TAstaClientSocket.GetDataSet

.... ....... ....... ................................................................................................................. 224TAstaClientSocket.HostToIPAddress

.... ....... ....... ................................................................................................................. 225TAstaClientSocket.IsBlocking

.... ....... ....... ................................................................................................................. 225TAstaClientSocket.IsHTTP

.... ....... ....... ................................................................................................................. 225TAstaClientSocket.IsStateless

.... ....... ....... ................................................................................................................. 225TAstaClientSocket.Loaded

.... ....... ....... ................................................................................................................. 225TAstaClientSocket.OpenTheSocket

.... ....... ....... ................................................................................................................. 226TAstaClientSocket.RegisterTrigger

.... ....... ....... ................................................................................................................. 226TAstaClientSocket.RequestUtilityInfo

.... ....... ....... ................................................................................................................. 227TAstaClientSocket.SendAndBlock

.... ....... ....... ................................................................................................................. 228TAstaClientSocket.SendAndBlockException

.... ....... ....... ................................................................................................................. 228TAstaClientSocket.SendBlobMessage

.... ....... ....... ................................................................................................................. 228TAstaClientSocket.SendChatEvent

.... ....... ....... ................................................................................................................. 229TAstaClientSocket.SendChatPopup

.... ....... ....... ................................................................................................................. 229TAstaClientSocket.SendCodedMessage

.... ....... ....... ................................................................................................................. 231TAstaClientSocket.SendCodedParamList

.... ....... ....... ................................................................................................................. 232TAstaClientSocket.SendCodedStream

.... ....... ....... ................................................................................................................. 232TAstaClientSocket.SendDataSetTransactions

.... ....... ....... ................................................................................................................. 233TAstaClientSocket.SendDataSetTransactionsList

.... ....... ....... ................................................................................................................. 233TAstaClientSocket.SendGetCodeDBParamList

.... ....... ....... ................................................................................................................. 234TAstaClientSocket.SendGetCodedParamList

.... ....... ....... ................................................................................................................. 234TAstaClientSocket.SendMasterDetailAutoIncTransaction

.... ....... ....... ................................................................................................................. 235TAstaClientSocket.SendMasterDetailOrderedTransactions

.... ....... ....... ................................................................................................................. 235TAstaClientSocket.SendNamedUserCodedParamList

.... ....... ....... ................................................................................................................. 235TAstaClientSocket.SendProviderTransactions

.... ....... ....... ................................................................................................................. 236TAstaClientSocket.SendUserNameCodedParamList

.... ....... ....... ................................................................................................................. 236TAstaClientSocket.ServerHasResponded

.... ....... ....... ................................................................................................................. 236TAstaClientSocket.SetAESKeys

.... ....... ....... ................................................................................................................. 237TAstaClientSocket.SetDESStringKey

.... ....... ....... ................................................................................................................. 237TAstaClientSocket.SetForIsapiUse

.... ....... ....... ................................................................................................................. 237TAstaClientSocket.SetForNormalTCPIP

.... ....... ....... ................................................................................................................. 237TAstaClientSocket.SetForProxyUse

.... ....... ....... ................................................................................................................. 237TAstaClientSocket.SetupForSocks5Server

.... ....... ....... ................................................................................................................. 238TAstaClientSocket.SocksConnect

.... ....... ....... ................................................................................................................. 238TAstaClientSocket.TimerReconnect

.... ....... ....... ................................................................................................................. 238TAstaClientSocket.UnRegisterTrigger

.... ....... ....... ................................................................................................................. 238TAstaClientSocket.WaitingForServer

IXContents



12/682

.... ....... ....... ................................................................................................................. 239TAstaClientSocket.WebServerCheck

.... ....... ....... ................................................................................................................. 239TAstaClientSocket.WinINetActive

.......... ....... ....... ................................................................................................................. 239Events

.... ....... ....... ................................................................................................................. 240TAstaClientSocket.OnChatMessage

.... ....... ....... ................................................................................................................. 240TAstaClientSocket.OnCodedMessage

.... ....... ....... ................................................................................................................. 240TAstaClientSocket.OnCodedParamList

.... ....... ....... ................................................................................................................. 241TAstaClientSocket.OnCodedStream

.... ....... ....... ................................................................................................................. 242TAstaClientSocket.OnCompress

.... ....... ....... ................................................................................................................. 242TAstaClientSocket.OnConnect

.... ....... ....... ................................................................................................................. 242TAstaClientSocket.OnConnecting

.... ....... ....... ................................................................................................................. 242TAstaClientSocket.OnConnectStatusChange

.... ....... ....... ................................................................................................................. 243TAstaClientSocket.OnCustomConnect

.... ....... ....... ................................................................................................................. 243TAstaClientSocket.OnCustomParamSyntax

.... ....... ....... ................................................................................................................. 244TAstaClientSocket.OnCustomSQLError

.... ....... ....... ................................................................................................................. 244TAstaClientSocket.OnCustomSQLSyntax

.... ....... ....... ................................................................................................................. 244TAstaClientSocket.OnDecompress

.... ....... ....... ................................................................................................................. 245TAstaClientSocket.OnDecrypt

..

delphi 7 - asta v3.0 for delphi 7 - manual

Documents