ASTА. ASTA 3 for Delphi

684 Pages·4.141 MB·English

ASTA 3 for Delphi
1997-2002 ® ASTA Technology Group Inc
ASTA SkyWire
Wireless Enabled Web Services and Collaborative Tools
by ASTA Technology Group
ASTA Skywire supports cross platform clients and server to
allow for developers to create fast, reliable and secure
applications that run over any network.
Contents I
Table of Contents
Foreword 1
Part I ASTA 3 2
1 ASTA 3 New F.e..a..t..u..r.e..s.. ..................................................................................................................... 4
2 ASTA 2.6 to A.S..T..A... .3.. .M...i.g..r..a.t..i.o..n.. .I.s..s..u...e.s... .......................................................................................... 9
3 ASTA History.. ................................................................................................................................. 10
4 ASTA 3 Tuto.r.i.a..l.s.. ........................................................................................................................... 10
DataSets- In M...e..m...o..r.y.. ............................................................................................................................................. 11
Master De..t.a..i.l................................................................................................................................................... 11
Indexes ......................................................................................................................................................... 12
Create Fie..l.d..s.................................................................................................................................................... 12
Add a Calculated.. ..F.i.e...ld.. .a..t. .r.u..n..t.i.m...e............................................................................................................... 13
Client Side SQ...L.. ..................................................................................................................................................... 13
Aggregate..s....................................................................................................................................................... 14
CachedUp..d..a..t.e..s................................................................................................................................................ 15
Constrain.t.s....................................................................................................................................................... 15
Indexes ......................................................................................................................................................... 16
MasterDe.t.a..i.l.................................................................................................................................................... 16
Sorting ......................................................................................................................................................... 16
SuitCase......................................................................................................................................................... 17
Transactio..n..s..................................................................................................................................................... 17
Messaging .......................................................................................................................................................... 17
CodedPar..a.m....L.i.s..t.............................................................................................................................................. 19
CodedDB.P..a..r..a.m...L..i.s..t......................................................................................................................................... 20
PackingU.p..D..a..t.a................................................................................................................................................. 20
DataSetParamLi.s..t...................................................................................................................................... 21
DataSetPackup......................................................................................................................................... 21
Large File.T..r..a..n..s.f.e...r........................................................................................................................................... 22
Standard Messa.g..i.n..g................................................................................................................................... 22
Server to Client......................................................................................................................................... 23
Client to Server......................................................................................................................................... 23
Server side T.e..c.h...n..i.q..u..e..s.. ........................................................................................................................................ 25
Provider T..e..x..t. .f.i.le.. .U..p..d..a..t.e..r................................................................................................................................. 25
ServerMe.t.h..o..d.. .P..a..r.a..m... ..E..x..a.m...p..l.e......................................................................................................................... 27
Threaded. .S..e..r.v..e.r.. .w..i.t.h.. ..N..o.. .D..a..t.a..b..a..s..e.................................................................................................................. 28
Feature Teste.r..s. ...................................................................................................................................................... 30
DataSetQ.A........................................................................................................................................................ 30
ProviderT.e..s..t.e.r.................................................................................................................................................. 31
ServerMe.t.h..o..d..T..e..s..te...r........................................................................................................................................ 32
SQLDemo.. .a..n..d.. .H..t..tp.. ..T..u..n..n..e..li.n..g.......................................................................................................................... 33
SQLExplo..r.e..r.................................................................................................................................................... 34
Stored Pr.o..c.e..d..u..r.e..s.. .T..e..s..t.e..r................................................................................................................................ 35
Security Issu.e.s.. ...................................................................................................................................................... 35
Servers a.n..d.. .S..e..c..u..r.i.t.y........................................................................................................................................ 36
5 ASTA and .N.E..T.. .............................................................................................................................. 36
6 Building App..l.i.c..a..t.i.o..n..s.. .w...i.t.h.. ..A..S..T...A.. ................................................................................................ 38
General Topic..s.. ...................................................................................................................................................... 38
1997-2002 ® ASTA Technology Group Inc
I
II ASTA 3 for Delphi
ASTA Jum...p. ..S..t.a..r.t. .T..i.p..s...................................................................................................................................... 38
ASTA Com...p..r..e.s..s..i.o.n........................................................................................................................................... 38
Registry K..e..y..s. ..U..s..e..d.. .b..y. ..A..S..T..A............................................................................................................................ 39
Useful Uti.l.i.ty.. ..M..e..t.h..o..d..s....................................................................................................................................... 39
Database Dis.c.u..s...s.i.o..n... ............................................................................................................................................ 40
Client Sid.e.. .S..Q...L.. .v..s.. .C..o..d..i.n.g... t.h..e.. ..S..e..r.v..e.r.............................................................................................................. 40
Packet Fe..t.c.h...e.s................................................................................................................................................. 40
Client/Ser.v..e..r. .M...a..n..n..e..r.s...................................................................................................................................... 41
Distributed... .D..a..t.a..b..a..s..e.. .N..e..t.w...o.r..k.s......................................................................................................................... 41
Suitcase M...o..d..e..l................................................................................................................................................ 43
Master De..t.a..i.l. .S..u..p..p..o..r.t...................................................................................................................................... 44
Asyncrono..u..s.. .D...a..t.a.b...a.s..e.. .A..c..c..e..s.s......................................................................................................................... 44
Multi Tabl.e.. .U...p..d.a...t.e.s.. .f.r.o..m... .J..o..i.n.s......................................................................................................................... 46
SQL Gene..r.a..t.i.o..n................................................................................................................................................ 46
More on S..Q...L.. .G..e..n..e..r.a..t.i.o..n.................................................................................................................................. 47
ASTA Clients .......................................................................................................................................................... 49
ASTA Jum...p. ..S..t.a..r.t. .T..i.p..s...................................................................................................................................... 49
ASTA Sm.a..r.t.W...a..i.t.............................................................................................................................................. 50
ASTA Sta.t.e.. ..a.n..d.. .S..t.a..t.e..l.e..s..s. ..C..l.i.e..n..t.s.................................................................................................................... 50
Cached U.p..d..a..t.e..s............................................................................................................................................... 51
Paramete.r.i.z..e..d.. .Q...u.e...ri.e...s. .i.n.. .a. ..T..r.a..n..s..a.c..t.i.o..n........................................................................................................... 53
Refetching... .D..a..t.a.. .o..n.. .I.n..s.e...r.t.s.. .a..n.d... U...p..d..a..t.e.s........................................................................................................... 54
Streaming.. .A..s..t.a.. .D...a..t.a.s..e..t.s.................................................................................................................................. 55
ASTA Servers. ......................................................................................................................................................... 55
AstaServe..r.F..o..r.m...a..t............................................................................................................................................ 56
AstaServerForm.a..t...R..e..m...o..t.e..A..d..m...i.n................................................................................................................ 57
AstaServerForm.a..t...R..e..m...o..t.e..C..o...n.t..r.o..l............................................................................................................. 58
AstaServerForm.a..t...C..o..d..i.n..g..T..h..e..S..e..r.v..e..r.......................................................................................................... 59
AstaServerForm.a..t...M...e..s..s.a..g..i.n..g..................................................................................................................... 59
AstaServerForm.a..t...D..a..t.a..b..a..s..e..S..u..p..p..o..r.t.......................................................................................................... 60
AstaServerForm.a..t...N..T..S...e..r.v..i.c.e...................................................................................................................... 60
ASTA Dat.a..b..a..s..e.. .S..e..r.v..e..r. ..S..u..p..p..o..r.t...................................................................................................................... 61
ASTA Mid.d..l.e..w...a.r..e.. .T..r.i.g..g..e..r.s............................................................................................................................... 62
ASTA Ser.v..e..r. .A...d.m...i.n.......................................................................................................................................... 63
ASTA Ser.v..e..r. .L..o..g..g..i.n..g....................................................................................................................................... 64
ASTA Ser.v..e..r.s.. .a..n..d.. .M...u..lt..ip..l.e.. .D...a..t.a.S...o..u..r.c..e..s......................................................................................................... 65
ASTA Ser.v..e..r.s.. .a..n..d.. .V..i.s..u..a..l ..I.n.t.e..r..f.a.c..e..s................................................................................................................. 67
Building A..S..T..A.. ..S..e..r.v..e.r..s..................................................................................................................................... 67
Coding AS...T..A.. .S..e..r..v.e..r.s....................................................................................................................................... 68
Command.. .L..i.n.e... .S..w...it.c..h..e..s.................................................................................................................................. 69
Data Mod.u..le...s. ..o.n.. ..A..S..T..A.. ..S..e..r.v..e.r..s....................................................................................................................... 69
Login Pro.c..e.s..s................................................................................................................................................... 70
Server Sid..e.. .P..r..o.g..r..a..m..m...i.n..g................................................................................................................................. 71
Threading......................................................................................................................................................... 71
Threading ASTA. ..S..e..r.v..e..r.s............................................................................................................................ 71
General Threadi.n..g.. .T..i.p..s.............................................................................................................................. 72
Persistent Threa.d..i.n..g.. .M...o..d..e..l....................................................................................................................... 72
ASTA Smart Thr.e..a..d..i.n..g............................................................................................................................... 74
UseRegis.t.r.y...................................................................................................................................................... 76
ASTA Messag.i.n..g... ................................................................................................................................................... 77
More on A..S..T...A.. .M...e..s..s.a..g..i.n..g................................................................................................................................ 78
ParamList.. .M...e..s..s.a..g..i.n..g....................................................................................................................................... 81
Transferin..g. ..L..a.r..g..e.. .o..r. .G..r.o...u.p..s.. .o..f. .F..i.l.e.s................................................................................................................. 84
ASTA Tools .......................................................................................................................................................... 84
1997-2002 ® ASTA Technology Group Inc
Contents III
Asta Anch..o.r.. .S..e..r.v..e..r.......................................................................................................................................... 84
ASTA Con..v..e..r.s..i.o..n.. .W...i.z..a.r..d................................................................................................................................. 85
ASTA Pro.x..y.. .S..e..r.v..e..r.......................................................................................................................................... 86
AstaServe..r.L..a..u..n..c..h.e...r........................................................................................................................................ 86
AstaSeve.r.L..a..u..n..c.h...e.r..N..T..S.................................................................................................................................... 86
AstaSQLE..x..p..l.o..r.e..r............................................................................................................................................. 87
Automatic Cli.e..n..t. ..U..p..d..a..t.e..s.. ..................................................................................................................................... 88
Asta Rem.o..t.e.. .A...d.m...i.n..i.s..t.r.a..t.iv..e.. ..A..P..I...................................................................................................................... 88
Firewalls .......................................................................................................................................................... 90
Using AST...A.. .t.h..r.o..u..g..h.. .a.. .F..i.r.e..w..a..l.l........................................................................................................................ 90
Maintain State ......................................................................................................................................... 91
Solution #1: Op.e..n.. .a.. .P..o..r.t..................................................................................................................... 91
Solution #2: Ru.n.. .t.h..e.. .A..S..T...A.. .S...e.r..v..e.r.. o..n.. ..P..o..r.t. .8..0..................................................................................... 91
Solution #3: SO..C..K..S... .S..u..p..p..o..r.t.............................................................................................................. 92
Solution #4: AS.T..A... .P..r.o..x..y.. .S..e..r.v..e..r......................................................................................................... 92
Stateless Firewa..ll....................................................................................................................................... 93
Solution #1: Us.e.. .W...i.n..I.n..e.t.. .(.H..i.g..h..l.y.. .R..e..c..o..m...m...e..n.d...e.d..)............................................................................... 93
Solution #2: HT.T..P... .S..t.a..t.e..l.e.s..s.. ..w..i.t.h.. .I.IS... .r.u..n..n..in...g. ..r.e..m..o...te..l.y........................................................................ 93
Solution #3: Th.r.o..u..g..h.. .a.. .P..r.o..x..y.. .S..e..r.v..e.r................................................................................................... 94
Stateless ..C..l.i.e.n...ts............................................................................................................................................... 95
ASTA HTT...P.. ..T.u..n..n..e..l.i.n..g..................................................................................................................................... 97
Setting Up.. .I.I.S.................................................................................................................................................... 98
Provider Broa..d..c..a..s..t.s.. ............................................................................................................................................. 99
Manual Pr..o.v..i.d..e..r. ..B..r.o..a..d..c..a.s..t.s............................................................................................................................. 99
Automat.ic.. ..P..r.o..v..id..e..r. ..B..r.o..a..d..c..a.s..t.s....................................................................................................................... 100
Provider. .B..i.t.e.. .a..t. .t.h.e... .A..p..p..l.e............................................................................................................................... 101
Caching. .P..r.o..v..i.d..e..r. .M...e..t.a.D...a..t.a............................................................................................................................ 102
What Da.t.a.. ..is.. .S...e.n..t. ..in.. .P..r..o.v..i.d..e..r. .B..r..o.a..d..c..a..s..t.s...................................................................................................... 103
Security Issu..e..s.. .................................................................................................................................................... 104
Sockets and. .T..C...P../.I.P.. ..I.s.s...u..e..s. ................................................................................................................................. 105
ASTA Tr.a..n..s..p.o...r.t.s............................................................................................................................................ 106
Asta and. ..B..l.o..c.k..i.n..g.. .S..o..c..k..e..t.s............................................................................................................................. 107
ASTA in. .a..n. ..I.S..A..P...I ..D..L..L.................................................................................................................................... 108
Early Co.n..n..e..c..t................................................................................................................................................ 109
Socket E..r.r.o..r.s.................................................................................................................................................. 110
TCustom..W...i.n..S..o..c..k..e..t....................................................................................................................................... 111
XML Suppor.t. ........................................................................................................................................................ 111
Cross Platfo.r.m.... .S..u..p..p...o.r..t. ...................................................................................................................................... 113
7 Developing ..f.o..r.. .t.h..e.. .I.n..t.e..r..n..e..t. ........................................................................................................ 114
Database Ap..p..l.i.c..a.t..i.o..n.. .D...e..v..e..l.o..p..m...e..n..t. ................................................................................................................... 114
File Serv.e..r...................................................................................................................................................... 114
Client Se..r.v..e..r.................................................................................................................................................. 115
Internet .a..n..d.. .W...e..b.. .D..e..v..e..l.o.p...m...e.n..t...................................................................................................................... 117
Web Develop..m....e.n..t.. .a..n..d.. ..A..p..p..l.i.c..a..t.i.o..n.. .S..e..r..v..e..r.s.. ...................................................................................................... 118
Beyond the .B..r.o..w...s..e..r.. ........................................................................................................................................... 119
Additional Ta..b...l.e.s.. ..a..n..d.. .F..e..a..t.u..r.e..s.. .......................................................................................................................... 121
ASTA Fr.a..m...e..w..o..r..k........................................................................................................................................... 121
TCP/IP a..n..d.. .H..T...T..P.. .C..l.i.e..n..t.s............................................................................................................................... 123
ServerM.e..t.h..o..d..s.. .a..s. .S..O...A..P... .S..e..r.v..i.c..e..s................................................................................................................. 124
Business.. .t.o.. .B..u..s..i.n..e..s.s...................................................................................................................................... 125
Cross Pl.a..t.f.o..r.m.../.D..e..v..i.c..e../P...r.o..t.o..c.o...l..................................................................................................................... 126
8 ASTA Comp..o..n..e..n...t.s.. ..................................................................................................................... 126
Client Side .......................................................................................................................................................... 127
1997-2002 ® ASTA Technology Group Inc
III
IV ASTA 3 for Delphi
TAstaDa.t.a..s..e..t................................................................................................................................................. 127
Properties ......................................................................................................................................... 128
TAstaDataSet...A..g..g..r.e..g..a..t.e..s................................................................................................................. 129
TAstaDataset..F..i.e..l.d..s..D..e..f.i.n.e................................................................................................................. 129
TAstaDataset..I.n..d..e..x..e.s........................................................................................................................ 130
TAstaDataSet...I.n.d...e.x..F..i.e..l.d..C..o..u..n..t......................................................................................................... 131
TAstaDataSet...I.n.d...e.x..F..i.e..l.d..N..a..m...e..s........................................................................................................ 131
TAstaDataSet...I.n.d...e.x..F..i.e..l.d..s................................................................................................................. 131
TAstaDataSet...I.n.d...e.x..N...a..m...e................................................................................................................. 131
TAstaDataSet...K..e..y..E..x..c..lu..s..i.v..e.............................................................................................................. 132
TAstaDataSet...K..e..y..F..i.e.l.d..C...o..u..n..t........................................................................................................... 132
TAstaDataSet...M..a...s.t.e..r.F...ie..l.d..s............................................................................................................... 132
TAstaDataSet...M..a...s.t.e..r.S...o..u.r..c..e............................................................................................................. 133
TAstaDataSet...R..e..a..d..O...n..ly.................................................................................................................... 133
TAstaDataSet...S..t.r.e..a..m...O...p..ti.o..n..s............................................................................................................ 133
Methods ......................................................................................................................................... 135
TAstaDataSet...A..d..d..B..o..o..k..m...a..r.k..I.n.d...e.x..................................................................................................... 137
TAstaDataSet...A..d..d..I.n..d..e..x.................................................................................................................... 137
TAstaDataSet...A..d..d..I.n..d..e..x.F..i.e..l.d..s........................................................................................................... 137
TAstaDataSet...A..p..p..l.y..R..a..n..g..e................................................................................................................ 137
TAstaDataSet...C..a..n..c..e..lR...a..n..g..e.............................................................................................................. 138
TAstaDataSet...C..l.e..a..n..C..l.o..n..e..F..r.o..m...D...a..ta...S..e..t........................................................................................... 138
TAstaDataSet...C..l.o..n..e..C..u..r.s..o..r............................................................................................................... 138
TAstaDataSet...C..l.o..n..e..F..i.e..ld..s..F..r.o...m..D...a..t.a..S..e..t........................................................................................... 138
TAstaDataSet...C..l.o..n..e..F..i.e..ld..s..F..r.o...m..D...a..t.a..S..e..t.P..r.e...s.e..r.v..e..F..i.e..l.d..s.................................................................... 138
TAstaDataSet...C..o..m...p..a..r.e..F..i.e..l.d..s........................................................................................................... 139
TAstaDataSet...D..a..t.a..T..r.a..n..s..f.e..r.............................................................................................................. 139
TAstaDataSet...D..e..f.i.n..e..S..o..r.t.O...r.d..e..r......................................................................................................... 139
TAstaDataSet...E..d..i.t.K..e..y....................................................................................................................... 139
TAstaDataSet...E..d..i.t.R..a..n..g..e..E..n..d............................................................................................................. 140
TAstaDataSet...E..d..i.t.R..a..n..g..e..S..t.a..r..t.......................................................................................................... 140
TAstaDataSet...E..m...p..t.y......................................................................................................................... 140
TAstaDataSet...F..a..s..tF...ie..l.d..D..e...f.in..e........................................................................................................... 140
TAstaDataSet...F..il.t.e..r.C...o..u..n..t................................................................................................................. 140
TAstaDataSet...F..in...d.K...e..y...................................................................................................................... 141
TAstaDataSet...F..in...d.N...e..a..r.e..s..t............................................................................................................... 141
TAstaDataSet...G..e..t.R...e..c..o.r..d.S...i.z.e............................................................................................................ 141
TAstaDataSet...G..o..t.o..K..e...y..................................................................................................................... 141
TAstaDataSet...G..o..T..o...N..e..a..r.e..s..t............................................................................................................. 142
TAstaDataSet...I.s.B...l.o.b..F...ie..l.d.................................................................................................................. 142
TAstaDataSet...L..a.s..t.N...a..m...e..d.S...o..r.t.......................................................................................................... 142
TAstaDataSet...L..o.a...d.F..r..o..m...F..i.le.............................................................................................................. 142
TAstaDataSet...L..o.a...d.F..r..o..m...F..i.le..W...i.t.h..F...ie..l.d..s............................................................................................. 143
TAstaDataSet...L..o.a...d.F..r..o..m...S..t.r.e..a..m......................................................................................................... 143
TAstaDataSet...L..o.a...d.F..r..o..m...S..t.r.e..a..m...w...it.h..F..i.e..l.d..s........................................................................................ 143
TAstaDataSet...L..o.a...d.F..r..o..m...S..t.r.i.n..g.......................................................................................................... 144
TAstaDataSet...N..u..k..e..A..l.l.F..i.e.l.d..I.n..f.o.......................................................................................................... 144
TAstaDataSet...R..e..m...o..v..e..S..o..r.t.O...r.d..e..r...................................................................................................... 144
TAstaDataSet...S..a..v..e..T..o..F..i.l.e................................................................................................................. 144
TAstaDataSet...S..a..v..e..T..o..S..t.r.e..a..m............................................................................................................. 145
TAstaDataSet...S..a..v..e..T..o..S..t.r.i.n..g.............................................................................................................. 145
TAstaDataSet...S..a..v..e..T..o..X..M...L................................................................................................................ 145
TAstaDataSet...S..e..t.K..e..y........................................................................................................................ 145
TAstaDataSet...S..e..t.R..a..n..g..e.................................................................................................................... 146
1997-2002 ® ASTA Technology Group Inc
Contents V
TAstaDataSet...S..e..t.R..a..n..g..e..E..n...d............................................................................................................. 146
TAstaDataSet...S..e..t.R..a..n..g..e..S..t..a.r..t........................................................................................................... 146
TAstaDataSet...S..o..r.t.D...a.t..a.S...e..t.B..y..F..i.e..ld...N..a..m...e........................................................................................... 147
TAstaDataSet...S..o..r.t.D...a.t..a.S...e..t.B..y..F..i.e..ld...N..a..m...e..s......................................................................................... 147
TAstaDataSet...S..o..r.t.O...r.d..e..r.S..o..r.t............................................................................................................. 147
TAstaDataSet...U..n..R...e..g.i.s..t.e..r.C...lo...n.e......................................................................................................... 147
TAstaDataSet...V..a..l.i.d.B...o..o..k..M..a..r.k............................................................................................................ 147
Events ......................................................................................................................................... 148
TAstaDataset..O...n..S..t.r.e..a..m...E..v..e..n..t.......................................................................................................... 148
Functions for W..o..r.k..i.n..g.. .W...i.t.h.. .T..A...s..ta..D...a..t.a..S..e..t.s.............................................................................................. 148
FilteredDataSe..t.T..o..S...t.r.in...g.................................................................................................................... 149
DataSetToStri.n..g..W...i.t.h..F..i.e..l.d.P...r.o..p..e..r.t.i.e.s.................................................................................................. 149
StringToStrea.m.................................................................................................................................. 149
StringToDataS..e..t.W...i.t.h..F..i.e..l.d.P...r.o..p..e..r.t.i.e.s.................................................................................................. 149
Sorting Datase..t.s................................................................................................................................ 150
DataSetToStri.n..g................................................................................................................................ 150
CloneDataSet.T..o..S..t.r.i.n..g....................................................................................................................... 150
StringToDataS..e..t............................................................................................................................... 150
TAstaCli.e..n..t.D..a..t.a..S..e...t....................................................................................................................................... 151
Properties ......................................................................................................................................... 151
TAstaClientDa.t.a..S...e..t...A..g..g..r.e..g..a..t.e..s........................................................................................................ 153
TAstaClientDa.t.a..S...e..t...A..s..c.e..n..d..i.n..g.......................................................................................................... 153
TAstaClientDa.t.a..S...e..t...A..s..t.a..C..l.i.e..n..tS...o..c..k.e..t............................................................................................... 153
TAstaClientDa.t.a..S...e..t...A..u..t.o..F..e..t.c..h.P...a..c..k.e..t.s.............................................................................................. 154
TAstaClientDa.t.a..S...e..t...A..u..t.o..I.n..c.r..e..m...e.n...tF...ie..l.d............................................................................................ 155
TAstaClientDa.t.a..S...e..t...D..a..t.a..B..a..s..e........................................................................................................... 155
TAstaClientDa.t.a..S...e..t...E..d..i.t.M..o...d.e............................................................................................................ 156
TAstaClientDa.t.a..S...e..t...E..x..t.r.a..P..a..r.a..m...s...................................................................................................... 156
TAstaClientDa.t.a..S...e..t...In...d.e...x.e..s.............................................................................................................. 156
TAstaClientDa.t.a..S...e..t...In...d.e...x.F..i.e..l.d..C..o..u..n..t................................................................................................ 157
TAstaClientDa.t.a..S...e..t...In...d.e...x.F..i.e..l.d..N..a..m...e..s............................................................................................... 157
TAstaClientDa.t.a..S...e..t...In...d.e...x.F..i.e..l.d..s........................................................................................................ 158
TAstaClientDa.t.a..S...e..t...In...d.e...x.N...a..m..e......................................................................................................... 158
TAstaClientDa.t.a..S...e..t...In...d.e...x.P...r.im...e..K...e..y.................................................................................................. 158
TAstaClientDa.t.a..S...e..t...K..e..y..E..x..c.l.u..s..i.v.e...................................................................................................... 158
TAstaClientDa.t.a..S...e..t...K..e..y..F..ie...ld..C...o..u..n..t.................................................................................................. 159
TAstaClientDa.t.a..S...e..t...M...a.s..t.e..r.F..i.e..l.d..s...................................................................................................... 159
TAstaClientDa.t.a..S...e..t...M...a.s..t.e..r.S...o..u..r.c.e..................................................................................................... 159
TAstaClientDa.t.a..S...e..t...M...e.t.a..D...a..t.a..R..e..q..u..e..s..t............................................................................................. 159
TAstaClientDa.t.a..S...e..t...N..o..S...Q..L..F..i.e..l.d..s..................................................................................................... 160
TAstaClientDa.t.a..S...e..t...O..l.d..V..a..l.u..e..s..D..a..t.a..S..e...t............................................................................................ 160
TAstaClientDa.t.a..S...e..t...O..r..a.c..l.e..S..e..q..u..e..n..c..e................................................................................................ 160
TAstaClientDa.t.a..S...e..t...O..r..d.e..r.B...y............................................................................................................. 162
TAstaClientDa.t.a..S...e..t...P..a..r.a..m...s.............................................................................................................. 162
TAstaClientDa.t.a..S...e..t...P..r.i.m...e..F..i.e..l.d.s........................................................................................................ 163
TAstaClientDa.t.a..S...e..t...P..r.o..v..id...e.r..B..r.o..a..d..C...a.s..t............................................................................................ 163
TAstaClientDa.t.a..S...e..t...P..r.o..v..id...e.r..B..r.o..a..d..C...a.s..t...B..r..o..a..d.C...a..s..t.A..c..t.i.o.n.................................................................. 163
TAstaClientDataSet.ProviderBroadCast.CachedBroadCastsWhenE
dit ................................................................................................................................... 164
TAstaClientDa.t.a..S...e..t...P..r.o..v..id...e.r..B..r.o..a..d..C...a.s..t...M...e..r.g..e..E...d.i.t.R...o.w...B...r.o..a..d..C..a..s..t.s.................................................. 164
TAstaClientDa.t.a..S...e..t...P..r.o..v..id...e.r..B..r.o..a..d..C...a.s..t...P..r..o..v.i.d..e..r.F..i.l.t.e..r...................................................................... 165
TAstaClientDa.t.a..S...e..t...P..r.o..v..id...e.r..B..r.o..a..d..C...a.s..t...R...e..g.i.s..t.e..r.F..o..r..B..r.o..a..d..c..a.s..t......................................................... 165
TAstaClientDa.t.a..S...e..t...P..r.o..v..id...e.r..B..r.o..a..d..C...a.s..t...R...e..t.r.i.e.v..e..P...r.im...e..K...e..y.F...ie..l.d..s...................................................... 165
TAstaclientDa.t.a..S..e..t...P..r.o..v..i.d..e..r.N...a.m...e..................................................................................................... 165
1997-2002 ® ASTA Technology Group Inc
V
VI ASTA 3 for Delphi
TAstaClientDa.t.a..S...e..t...R..e..a..d..O...n..l.y.......................................................................................................... 166
TAstaClientDa.t.a..S...e..t...R..e..f.e..t.c..h..O...n.I.n..s..e..r.t................................................................................................ 166
TAstaClientDa.t.a..S...e..t...R..e..s..e..t.F..i.e..l.d.s..O...n..S..Q...L..C..h..a..n..g..e..s.............................................................................. 167
TAstaClientDa.t.a..S...e..t...R..o..w...s.A...f.f.e..c.t.e..d..................................................................................................... 167
TAstaClientDa.t.a..S...e..t...R..o..w...s.T...o.R...e..t.u..r.n................................................................................................... 167
TAstaClientDa.t.a..S...e..t...S..e..r.v..e..r.D..a...ta..S...e..t.................................................................................................. 167
TAstaClientDa.t.a..S...e..t...S..e..r.v..e..r.M...e..t.h..o..d.................................................................................................... 169
TAstaClientDa.t.a..S...e..t...S..h..o..w..Q...u..e..r.y..P..r..o.g..r.e...s.s.......................................................................................... 170
TAstaClientDa.t.a..S...e..t...S..Q...L................................................................................................................... 170
TAstaClientDa.t.a..S...e..t...S..Q...L..G..e..n..e..r.a..t.e..L..o..c..a..t.i.o.n........................................................................................ 170
TAstaClientDa.t.a..S...e..t...S..Q...L..O..p..t.i.o..n..s....................................................................................................... 171
TAstaClientDa.t.a..S...e..t...S..Q...L..W...o..r.k..B..e..n..c..h................................................................................................. 171
TAstaClientDa.t.a..S...e..t...S..t.o..r.e..d..P..r..o.c..e..d..u..r.e................................................................................................ 172
TAstaClientDa.t.a..S...e..t...S..t.r.e..a..m...O...p.t..io..n..s................................................................................................... 172
TAstaClientDa.t.a..S...e..t...S..u..i.t.C..a..s..e..D..a..t.a..................................................................................................... 173
TAstaClientDa.t.a..S...e..t...T..a..b..l.e.N...a..m...e........................................................................................................ 173
TAstaClientDa.t.a..S...e..t...U..p..d..a..t.e..M...e..t.h..o..d................................................................................................... 173
TAstaClientDa.t.a..S...e..t...U..p..d..a..t.e..M...o..d..e...................................................................................................... 174
TAstaClientDa.t.a..S...e..t...U..p..d..a..t.e..O...b.j.e..c..t.................................................................................................... 174
TAstaClientDa.t.e..S...e..t...U..p..d..a..t.e..T..a..b..l.e..N..a..m...e............................................................................................. 174
Methods ......................................................................................................................................... 175
TAstaClientDa.t.a..S...e..t...A..d..d..B..o..o..k..m...a..r.k..In...d.e...x........................................................................................... 177
TAstaClientDa.t.a..S...e..t...A..d..d..I.n..d..e..x........................................................................................................... 178
TAstaClientDa.t.a..S...e..t...A..d..d..I.n..d..e..x..F..ie..l.d..s.................................................................................................. 178
TAstaClientDa.t.a..S...e..t...A..d..d..P..a..r.a..m...e..t.e..r.i.z..e..d..Q..u..e..r.y.................................................................................... 178
TAstaClientDa.t.a..S...e..t...A..p..p..l.y.B...u..l.k.U...p..d..a..t.e.s.............................................................................................. 178
TAstaClientDa.t.a..S...e..t...A..p..p..l.y.R...a..n..g..e....................................................................................................... 179
TAstaClientDa.t.a..S...e..t...A..p..p..l.y.U...p..d..a..t.e..s.................................................................................................... 179
TAstaClientDa.t.a..S...e..t...C..a..n..c..e..l.R..a..n..g..e..................................................................................................... 179
TAstaClientDa.t.a..S...e..t...C..a..n..c..e..l.U..p..d..a..t.e..s.................................................................................................. 179
TAstaClientDa.t.a..S...e..t...C..l.e..a..n..C..l.o..n..e..F..r.o..m...D...a..t.a.S...e..t.................................................................................. 180
TAstaClientDa.t.a..S...e..t...C..l.e..a..r.P..a..r..a.m...e..t.e..r.i.z..e..d..Q..u...e.r..y................................................................................. 180
TAstaClientDa.t.a..S...e..t...C..l.o..n..e..C..u..r..s.o..r...................................................................................................... 180
TAstaClientDa.t.a..S...e..t...C..l.o..n..e..F..i.e..l.d.s..F..r..o.m...D...a..t.a..S..e..t.................................................................................. 180
TAstaClientDa.t.a..S...e..t...C..l.o..n..e..F..i.e..l.d.s..F..r..o.m...D...a..t.a..S..e..t.P..r..e.s..e..r.v..e..F..i.e..l.d..s........................................................... 180
TAstaClientDa.t.a..S...e..t...C..l.o..s..e.Q...u..e..r.y..O...n..S..e..r.v..e..r........................................................................................ 181
TAstaClientDa.t.a..S...e..t...C..o..m...p..a..r.e..F..i.e..l.d..s.................................................................................................. 181
TAstaClientDa.t.a..S...e..t...D..a..t.a..T..r.a..n..s..f.e..r..................................................................................................... 181
TAstaClientDa.t.a..S...e..t...D..e..l.e..t.e..N..o..C...a..c..h.e.................................................................................................. 181
TAstaClientDa.t.a..S...e..t...D..e..l.t.a..A..s..S..Q...L....................................................................................................... 181
TAstaClientDa.t.a..S...e..t...D..e..l.t.a..C..h..a..n..g..e..d.................................................................................................... 182
TAstaClientDa.t.a..S...e..t...E..d..i.t.K..e..y.............................................................................................................. 182
TAstaClientDa.t.a..S...e..t...E..d..i.t.R..a..n..g..e..E..n..d.................................................................................................... 182
TAstaClientDa.t.a..S...e..t...E..d..i.t.R..a..n..g..e..S..t.a..r.t.................................................................................................. 183
TAstaClientDa.t.a..S...e..t...E..m...p..t.y................................................................................................................ 183
TAstaClientDa.t.a..S...e..t...E..m...p..t.y..C..a..c..h..e...................................................................................................... 183
TAstaClientDa.t.a..S...e..t...E..x..e..c.Q...u..e..r.y..I.n..T..r.a..n..s..a..c.t.i.o..n.................................................................................... 183
TAstaClientDa.t.a..S...e..t...E..x..e..c.S...Q..L............................................................................................................ 183
TAstaClientDa.t.a..S...e..t...E..x..e..c.S...Q..L...S..t.r.i.n..g.................................................................................................. 184
TAstaClientDa.t.a..S...e..t...E..x..e..c.S...Q..L...T..r.a..n..s.a..c..t.i.o..n......................................................................................... 184
TAstaClientDa.t.a..S...e..t...E..x..e..c.S...Q..L...W...it.h...In..p..u..t.P...a.r..a.m...s................................................................................. 184
TAstaClientDa.t.a..S...e..t...E..x..e..c.S...Q..L...W...it.h...P..a..r.a..m...s........................................................................................ 184
TAstaClientDa.t.a..S...e..t...F..a..s.t..F.i.e..l.d..D...e.f.i.n..e.................................................................................................. 185
TAstaClientDa.t.a..S...e..t...F..e..t.c..h.B...lo...b.......................................................................................................... 185
1997-2002 ® ASTA Technology Group Inc
Contents VII
TAstaClientDa.t.a..S...e..t...F..e..t.c..h.B...lo...b.S...t.r.i.n.g.................................................................................................. 185
TAstaClientDa.t.a..S...e..t...F..i.e.l.d..N...a..m...e..S..e..n..d..B..l.o..b..T..o..S..e..r.v..e..r........................................................................... 186
TAstaClientDa.t.a..S...e..t...F..i.lt.e..r.C...o..u..n..t........................................................................................................ 186
TAstaClientDa.t.a..S...e..t...F..i.n.d...K..e..y............................................................................................................. 186
TAstaClientDa.t.a..S...e..t...F..i.n.d...N..e..a..r.e..s..t...................................................................................................... 186
TAstaClientDa.t.a..S...e..t...F..o..r.m...a..t.F..i.e.l.d..f.o..r.S...Q...L............................................................................................ 187
TAstaClientDa.t.a..S...e..t...G..e..t.N...e..x.t.P...a..c.k..e..t.................................................................................................. 187
TAstaClientDa.t.a..S...e..t...G..e..t.N...e..x.t.P...a..c.k..e..t.L..o..c..a..t.e........................................................................................ 187
TAstaClientDa.t.a..S...e..t...G..e..t.R...e..f.e..t.c.h..S...t.a.t..u.s............................................................................................... 188
TAstaClientDa.t.a..S...e..t...G..o..t.o..K...e.y............................................................................................................. 188
TAstaClientDa.t.a..S...e..t...G..o..T...o.N...e..a..r.e..s..t.................................................................................................... 188
TAstaClientDa.t.a..S...e..t...L.a...s.t.N...a..m...e.d...S..o..r.t................................................................................................. 188
TAstaClientDa.t.a..S...e..t...L.o...a.d..F...r.o..m..F...il.e..................................................................................................... 189
TAstaClientDa.t.a..S...e..t...L.o...a.d..F...r.o..m..F...il.e..W....it.h..F..i.e..l.d..s.................................................................................... 189
TAstaClientDa.t.a..S...e..t...L.o...a.d..F...r.o..m..S...t.r.e..a..m................................................................................................ 189
TAstaClientDa.t.a..S...e..t...L.o...a.d..F...r.o..m..S...t.r.e..a..m...W...i.t.h..F..i.e..ld...s.............................................................................. 189
TAstaClientDa.t.a..S...e..t...L.o...a.d..F...r.o..m..S...t.r.i.n..g................................................................................................. 189
TAstaClientDa.t.a..S...e..t...L.o...a.d..F...r.o..m..X...M...L................................................................................................... 190
TAstaClientDa.t.a..S...e..t...N..u..k..e..A..l.l.F..i.e..ld..I.n..f.o................................................................................................. 190
TAstaClientDa.t.a..S...e..t...O..p..e..n..N...o..F..e..t.c.h..................................................................................................... 190
TAstaClientDa.t.a..S...e..t...O..p..e..n..W...i.t.h..B...lo..c..k..i.n.g...S..o..c..k.e..t.................................................................................. 190
TAstaClientDa.t.a..S...e..t...P..a..r.a..m...B..y..N...a.m....e.................................................................................................. 191
TAstaClientDa.t.a..S...e..t...P..a..r.a..m...Q...u..e..r.y.C...o..u..n..t............................................................................................ 191
TAstaClientDa.t.a..S...e..t...P..o..p..S..Q...L..F..r.o..m...P..a..r.s..e..r.......................................................................................... 192
TAstaClientDa.t.a..S...e..t...P..r.e..p..a..r.e.............................................................................................................. 192
TAstaClientDa.t.a..S...e..t...P..r.i.m...e..F..i.e..l.d.s..W....h.e..r.e...S..t.r.i.n..g.................................................................................... 192
TAstaClientDa.t.a..S...e..t...P..u..s..h.S...Q...L..T..o..P..a..r.s..e..r............................................................................................ 192
TAstaClientDa.t.a..S...e..t...R..e..a..d..F..i.e..l.d.......................................................................................................... 193
TAstaClientDa.t.a..S...e..t...R..e..f.i.r.e..S..Q...L.......................................................................................................... 193
TAstaClientDa.t.a..S...e..t...R..e..F..i.r.e..S..Q...L..B..o...o.k..M...a..r.k......................................................................................... 193
TAstaClientDa.t.a..S...e..t...R..e..f.r.e..s..h..F..r.o..m...S..e..r.v..e..r........................................................................................... 193
TAstaClientDa.t.a..S...e..t...R..e..g..i.s.t..e.r..P..r.o..v..i.d.e...r.F..o..r.U..p...d.a..t.e..s.............................................................................. 193
TAstaClientDa.t.a..S...e..t...R..e..m...o..v..e..S..o..r.t.O...r.d..e..r............................................................................................. 194
TAstaClientDa.t.a..S...e..t...R..e..s..e..t.F..i.e..l.d.s..O...n..S..Q...L..C..h..a..n..g..e..s.............................................................................. 194
TAstaClientDa.t.a..S...e..t...R..e..v..e..r.t.R..e...c.o..r.d..................................................................................................... 194
TAstaClientDa.t.a..S...e..t...S..a..v..e.S...u..i.t.C..a..s..e..D..a..t.a............................................................................................. 194
TAstaClientDa.t.a..S...e..t...S..a..v..e.T...o..F..i.le......................................................................................................... 194
TAstaClientDa.t.a..S...e..t...S..a..v..e.T...o..S..t.r.e..a..m.................................................................................................... 195
TAstaClientDa.t.a..S...e..t...S..a..v..e.T...o..S..t.r.i.n..g..................................................................................................... 195
TAstaClientDa.t.a..S...e..t...S..a..v..e.T...o..X..M...L....................................................................................................... 195
TAstaClientDa.t.a..S...e..t...S..e..n..d..B..l.o..b..T..o..S..e..r.v..e..r............................................................................................ 195
TAstaClientDa.t.a..S...e..t...S..e..n..d..P..a..r.a..m...e..t.e..r.i.z..e..d..Q..u..e..r.i.e..s............................................................................... 196
TAstaClientDa.t.a..S...e..t...S..e..n..d..S..Q...L..S..t.r.i.n..g..T..r.a..n..s..a..c.t..io..n................................................................................ 196
TAstaClientDa.t.a..S...e..t...S..e..n..d..S..Q...L..T..r.a..n..s..a..c..t.io..n......................................................................................... 196
TAstaClientDa.t.a..S...e..t...S..e..n..d..S..t.r.i.n..g..A..s..B..l.o..b..T..o..S...e.r..v.e..r............................................................................... 196
TAstaClientDa.t.a..S...e..t...S..e..n..d..S..t.r.i.n..g..L..i.s..tT...o.S...e..r.v..e..r.................................................................................... 197
TAstaClientDa.t.a..S...e..t...S..e..t.E..d..i.t.M...o..d..e...................................................................................................... 197
TAstaClientDa.t.a..S...e..t...S..e..t.K..e..y............................................................................................................... 197
TAstaClientDa.t.a..S...e..t...S..e..t.P..r.i.m...e..K..e..y..F..i.e..l.d..s.F...r.o..m...P..r.o..v..i.d.e...r...................................................................... 198
TAstaClientDa.t.a..S...e..t...S..e..t.R..a..n..g..e........................................................................................................... 198
TAstaClientDa.t.a..S...e..t...S..e..t.R..a..n..g..e..E...n.d..................................................................................................... 198
TAstaClientDa.t.a..S...e..t...S..e..t.R..a..n..g..e..S...ta...r.t.................................................................................................. 199
TAstaClientDa.t.a..S...e..t...S..e..t.S..Q...L..S..t.r.i.n..g..................................................................................................... 199
TAstaClientDa.t.a..S...e..t...S..e..t.T..o..C..o...n.n..e..c..t.e..d..M...a..s.t.e...rD...e..t.a..i.l........................................................................... 199
1997-2002 ® ASTA Technology Group Inc
VII
VIII ASTA 3 for Delphi
TAstaClientDa.t.a..S...e..t...S..e..t.T..o..D..i.s..C...o.n...n.e..c..t.e..d..M...a..s..t.e.r..D..e..t.a..i.l...................................................................... 200
TAstaClientDa.t.a..S...e..t...S..o..r.t.D..a...ta...S..e..t.B..y..F..i.e..l.d.N...a..m...e.................................................................................. 200
TAstaClientDa.t.a..S...e..t...S..o..r.t.D..a...ta...S..e..t.B..y..F..i.e..l.d.N...a..m...e..s................................................................................ 201
TAstaClientDa.t.a..S...e..t...S..o..r.t.O...r.d..e..r.S..o..r..t................................................................................................... 201
TAstaClientDa.t.a..S...e..t...U..n..R...e.g...is..t.e..r.C...l.o.n..e................................................................................................ 201
TAstaClientDa.t.a..S...e..t...U..n..R...e.g...is..t.e..r.P..r..o.v..i.d..e..r.F..o..r..U..p..d..a..t.e..s......................................................................... 201
TAstaClientDa.t.a..S...e..t...U..p..d..a..t.e..s..P..e..n..d..i.n..g................................................................................................ 201
TAstaClientDa.t.a..S...e..t...V..a..l.id..B...o..o..k.m...a..r..k.................................................................................................. 202
Events ......................................................................................................................................... 203
TAstaClientDa.t.a..S...e..t...A..f.t.e..r.R...e.f.e...tc..h..O...n..I.n..s..e.r..t........................................................................................ 203
TAstaClientDa.t.a..S...e..t...O..n..A...ft.e...r.B..r.o..a..d..c..a..s.t..H..a..n..d..li.n..g................................................................................. 204
TAstaClientDa.t.a..S...e..t...O..n..A...ft.e...r.P..o..p..u..l.a.t..e................................................................................................ 204
TAstaClientDa.t.a..S...e..t...O..n..B...e.f..o.r..e..B..r.o..a..d..c..a..s.t.H...a..n..d..li.n..g.............................................................................. 204
TAstaClientDa.t.a..S...e..t...O..n..C...o..m...m...it.A...n..y.S...u..c..e.s..s..E..r.r..o.r................................................................................ 204
TAstaClientDa.t.a..S...e..t...O..n..C...u..s..to...m..S...e..r.v..e.r..A..c..t.io...n..................................................................................... 205
TAstaClientDa.t.a..S...e..t...O..n..P...r.o..v.i.d..e..r.B...r.o..a..d..C..a..s..t....................................................................................... 205
TAstaClientDa.t.a..S...e..t...O..n..P...r.o..v.i.d..e..r.B...r.o..a..d..C..a..s..t.A..f.t.e..r.A..p...p.l.y..R...o.w.................................................................. 206
TAstaClientDa.t.a..S...e..t...O..n..P...r.o..v.i.d..e..r.B...r.o..a..d..C..a..s..t.B..e..f.o..r.e..A...p..p.l.y..R...o.w............................................................... 206
TAstaClientDa.t.a..S...e..t...O..n..P...r.o..v.i.d..e..r.B...r.o..a..d..C..a..s..t.D..e..l.e..t.e..E...d.i.t.R...o.w.................................................................. 206
TAstaClientDa.t.a..S...e..t...O..n..P...r.o..v.i.d..e..r.B...r.o..a..d..c..a.s..t.E...d.i.t.R...o.w............................................................................. 206
TAstaClientDa.t.a..S...e..t...O..n..R...e..c..e.i.v..e..B..l.o..b..S..t.r..e.a..m........................................................................................ 207
TAstaClientDa.t.a..S...e..t...O..n..R...e..c..e.i.v..e..P..a..r.a..m...s............................................................................................. 207
TAstaClientDa.t.a..S...e..t...O..n..S...tr..e..a..m..E...v..e..n..t................................................................................................ 207
TAstaCli.e..n..t.S..o..c..k..e.t.......................................................................................................................................... 208
Properties ......................................................................................................................................... 208
TAstaClientSo.c..k..e..t...A..c..t.i.v.e................................................................................................................... 209
TAstaClientSo.c..k..e..t...A..d..d..r.e..s..s............................................................................................................... 210
TAstaClientSo.c..k..e..t...A..n..c..h..o.r..S..t.a..t.u..s....................................................................................................... 210
TAstaClientSo.c..k..e..t...A..p..p..l.ic..a..t.i.o..n..N..a..m...e.................................................................................................. 210
TAstaClientSo.c..k..e..t...A..p..p..l.ic..a..t.i.o..n..V..e..r.s..i.o..n............................................................................................... 211
TAstaClientSo.c..k..e..t...A..s..t.a..S..e..r.v..e..r.V..e..r..s.i.o..n............................................................................................... 211
TAstaClientSo.c..k..e..t...A..u..t.o..L..o..g..in...D..l.g....................................................................................................... 211
TAstaclientSo.c.k..e..t...C...li.e..n..t.S..o..c..k..e.t..P..a..r.a..m...s............................................................................................. 212
TAstaClientSo.c..k..e..t...C..l.i.e..n..t.T..y..p.e............................................................................................................ 212
TAstaClientSo.c..k..e..t...C..o..m...p..r.e..s..s..i.o.n........................................................................................................ 212
TAstaClientSo.c..k..e..t...C..o..n..n..e..c..t.A..c..t.i.o.n...................................................................................................... 213
TAstaClientSo.c..k..e..t...C..o..n..n..e..c..t.e..d........................................................................................................... 214
TAstaClientSo.c..k..e..t...C..o..n..n..e..c..t.io...n.S...t.r.i.n.g.................................................................................................. 214
TAstaClientSo.c..k..e..t...C..u..r.s..o..r.O...n..Q..u...e.r..i.e.s................................................................................................. 214
TAstaClientSo.c..k..e..t...D..a..t.a..S..e..t.C...o..u..n..t..................................................................................................... 214
TAstaClientSo.c..k..e..t...D..a..t.a..S..e..t.s.............................................................................................................. 215
TAstaClientSo.c..k..e..t...D..T..P...a..s.s..w...o..r.d........................................................................................................ 215
TAstaClientSo.c..k..e..t...D..T..U...s..e.r..N..a..m...e....................................................................................................... 215
TAstaClientSo.c..k..e..t...E..n..c..r.y..p.t..io..n............................................................................................................ 216
TAstaClientSo.c..k..e..t...H..o..s..t.................................................................................................................... 216
TAstaClientSo.c..k..e..t...K..e..e..p..A..l.i.v.e...P..i.n.g...................................................................................................... 217
TAstaClientSo.c..k..e..t...L..o.g...in..M...a..x..A..t.t.e..m...p..t.s............................................................................................... 217
TAstaClientSo.c..k..e..t...P..a..s..s.w...o..r.d............................................................................................................. 217
TAstaClientSo.c..k..e..t...P..o..r.t..................................................................................................................... 217
TAstaClientSo.c..k..e..t...P..r.o..g..r.e..s..s..B..a..r........................................................................................................ 218
TAstaClientSo.c..k..e..t...S..o..c..k.s..S...e.r..v..e.r..A..d..d..r.e..s..s........................................................................................... 218
TAstaClientSo.c..k..e..t...S..o..c..k.s..S...e.r..v..e.r..P..o..r.t................................................................................................. 218
TAstaClientSo.c..k..e..t...S..o..c..k.s..U...s.e...r.N..a..m...e.................................................................................................. 218
TAstaClientSo.c..k..e..t...S..Q...L..D..i.a..l.e..c..t......................................................................................................... 219
1997-2002 ® ASTA Technology Group Inc