<HTML><HEAD><TITLE>myOffice Email Message</TITLE>
<META content="text/html; charset=iso-8859-1" http-equiv=content-type>
<META name=date content=2002-11-01>
<STYLE type=text/css>
</STYLE>
</HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Verdana'; COLOR: #000080">
<DIV>TClientDataSet is the way I would go too – anything that processes data in
memory is a candidate to throw into a ClientDataSet in my mind. I
have used them to often add calculated columns, or use the locate function, or
filters, or filter events which adds a lot of power tools. In a
Clientdataset the data can be as closely connected or disconnected from the
datasource and the UI as you like – I have used it for reading in Excel
spreadsheets for instance.</DIV>
<DIV> </DIV>
<DIV>A ClientDataSet that is not connected to a Datasource or a UI control such
as DBGrid also has the advantage of being a lot faster – I learnt a lot of such
tricks from studying the recommended practices in the TKBMemTable which is a
fast superset of the ClientDataSet and is a free download, with a $5 help file
that was well worth the purchase.</DIV>
<DIV> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Verdana'; COLOR: #000080">John
Bird<BR>
<DIV
style="FONT-SIZE: small; FONT-FAMILY: 'Calibri'; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; TEXT-DECORATION: none; DISPLAY: inline"><B></B></DIV></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Verdana'; COLOR: #000080">
<DIV
style="FONT-SIZE: small; FONT-FAMILY: 'Calibri'; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; TEXT-DECORATION: none; DISPLAY: inline"><B>From:</B>
<A title=gary@benner.co.nz href="mailto:gary@benner.co.nz">Gary T. Benner</A>
</DIV>
<DIV style="FONT: 10pt tahoma">
<DIV style="BACKGROUND: #f5f5f5"><STRONG></STRONG> </DIV></DIV></DIV>
<DIV
style="FONT-SIZE: small; FONT-FAMILY: 'Calibri'; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; TEXT-DECORATION: none; DISPLAY: inline"><SPAN
style="COLOR: #ff0000"><B><SPAN
style="FONT-FAMILY: ms sans serif">[Reply]</SPAN></B></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #000000">HI
Jeremy,</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #000000">Is this
what an instance of a TClientDataSet could be used for? Then population could be
done with the DB Interface component set du jour, or other manual database layer
functionality.</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #000000">HTH</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #000000">cheers</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #000000">Gary</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #000000">A</SPAN><SPAN style="COLOR: #ff0000"><B>t 08:00 on
4/11/2013 you wrote </B></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>Hi
all.</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>I
am in the process of redeveloping an existing application that has
reached</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>the
end of its ability to add stuff nicely without breaking other bits
of</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>the
code. Admittedly best practice was not always followed :) but its
time</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>to
start version 2 of the app.</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>As
part of this I am splitting stuff up into database, business and
GUI</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>layers - on paper at the moment, and a thought
occurred to me. In .Net which</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>I
sometime work in, you uses datasets which are basically
connectionless,</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>and
I wondered if anyone can think why I would not take a similar
approach.</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>I
am using ADO, and at the moment I have a test procedure that calls
a</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>stored proc, then passes back a TADODataset which is
not connected to any</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>database, connectionless, then this procedure "does
something" with the</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>recordset, just looping it and printing stuff to a
listbox at the moment.</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>When its done, it frees the object etc.</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>Can
anyone see anything wrong with this approach? Or things I should
be</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>aware of etc?</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>
</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>Thanks, Jeremy</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>
</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">></SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>_______________________________________________</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN style="COLOR: #008000">>NZ
Borland Developers Group - Delphi mailing list</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>Post: delphi@listserver.123.net.nz</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>Admin:
http://delphi.org.nz/mailman/listinfo/delphi</SPAN></SPAN>
<P><SPAN style="FONT-FAMILY: ms sans serif"><SPAN
style="COLOR: #008000">>Unsubscribe: send an email to
delphi-request@listserver.123.net.nz with Subject: unsubscribe</SPAN></SPAN>
<P><FONT color=navy size=1 face=arial><FONT color=gray size=1
face=helvetica,verdana,arial><BR><FONT color=black size=2>Gary Benner
</FONT>MNZCS ITCP<BR>Information Technology Certified Professional <BR><A
style="COLOR: blue; TEXT-DECORATION: none"
href="http://www.onlearn.co.nz">Onlearn Limited</A> - Online Learning Hosting
& Support, Training & Content Development<BR><A
style="COLOR: blue; TEXT-DECORATION: none" href="http://www.123.net.nz">123
Internet Limited</A> - Managed Web Hosting, Virtualisation, High Availability
Systems & Cluster Technologies<BR><A
style="COLOR: teal; TEXT-DECORATION: none"
href="http://www.semantic.co.nz">Semantic Limited</A> - Software Development
& Systems Design, Online Education, e-Commerce<BR><A
style="COLOR: teal; TEXT-DECORATION: none" href="http://www.diwa.co.nz">Disaster
Warning Systems Limited</A> - Public Emergency Warning and Communication
Systems<BR><B>Mob:</B> 021 966 992<BR><B>DDI:</B> +64 7 543
1206<BR><B>Email:</B> <A
href="mailto:gary@benner.co.nz">gary@benner.co.nz</A><BR><B>Skype:</B>
garybenner<BR></FONT><BR><BR>Ref#: 41006<BR><BR>
<P>
<HR>
_______________________________________________<BR>NZ Borland Developers Group -
Delphi mailing list<BR>Post: delphi@listserver.123.net.nz<BR>Admin:
http://delphi.org.nz/mailman/listinfo/delphi<BR>Unsubscribe: send an email to
delphi-request@listserver.123.net.nz with Subject:
unsubscribe</FONT></DIV></DIV></DIV></BODY></HTML>