[DUG] Connectionless recordsets

[John Bird]

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: delphi at listserver.123.net.nz 

>Admin: http://delphi.org.nz/mailman/listinfo/delphi 

>Unsubscribe: send an email to delphi-request at listserver.123.net.nz 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: gary at benner.co.nz
Skype: garybenner


Ref#: 41006





--------------------------------------------------------------------------------
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at listserver.123.net.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20131104/73450b5f/attachment.html