<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-NZ link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Hi all.<o:p></o:p></p><p class=MsoNormal>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 <span style='font-family:Wingdings'>J</span> but its time to start version 2 of the app.<o:p></o:p></p><p class=MsoNormal>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.<o:p></o:p></p><p class=MsoNormal>When its done, it frees the object etc.<o:p></o:p></p><p class=MsoNormal>Can anyone see anything wrong with this approach? Or things I should be aware of etc?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks, Jeremy<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>