myOffice Email MessageTClientDataSet 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.
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.
John Bird
From: Gary T. Benner
[Reply]
HI Jeremy,
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.
HTH
cheers
Gary
At 08:00 on 4/11/2013 you wrote
>Hi all.
>
>I am in the process of redeveloping an existing application that has reached
>the end of its ability to add stuff nicely without breaking other bits of
>the code. Admittedly best practice was not always followed :) but its time
>to start version 2 of the app.
>
>As part of this I am splitting stuff up into database, business and GUI
>layers - on paper at the moment, and a thought occurred to me. In .Net which
>I sometime work in, you uses datasets which are basically connectionless,
>and I wondered if anyone can think why I would not take a similar approach.
>I am using ADO, and at the moment I have a test procedure that calls a
>stored proc, then passes back a TADODataset which is not connected to any
>database, connectionless, then this procedure "does something" with the
>recordset, just looping it and printing stuff to a listbox at the moment.
>
>When its done, it frees the object etc.
>
>Can anyone see anything wrong with this approach? Or things I should be
>aware of etc?
>
>
>
>Thanks, Jeremy
>
>
>
>
>
>_______________________________________________
>NZ Borland Developers Group - Delphi mailing list
>Post: [email protected]
>Admin: http://delphi.org.nz/mailman/listinfo/delphi
>Unsubscribe: send an email to [email protected] with
>Subject: unsubscribe
Gary Benner MNZCS ITCP
Information Technology Certified Professional
Onlearn Limited - Online Learning Hosting & Support, Training & Content
Development
123 Internet Limited - Managed Web Hosting, Virtualisation, High Availability
Systems & Cluster Technologies
Semantic Limited - Software Development & Systems Design, Online Education,
e-Commerce
Disaster Warning Systems Limited - Public Emergency Warning and Communication
Systems
Mob: 021 966 992
DDI: +64 7 543 1206
Email: [email protected]
Skype: garybenner
Ref#: 41006
--------------------------------------------------------------------------------
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [email protected] with
Subject: unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [email protected] with
Subject: unsubscribe
