<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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Cambria;
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;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</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=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>We centralise all data
responding to new field values into the TDatasource.OnDataChange event. If
Field is nil then some major change just happened (eg a new record being selected).
If Field is assigned then that is the field which just changed so you can check
if Field is one of the fields which should modify the price and if so call your
routine for recalculating the price.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>If you also need to initialise
your price for each record while opening the dataset then you will need logic
somewhere else as well (since OnDataChange is only called for the selected
record in certain situations or when a field value changes) but hopefully you
are storing the price in a field anyway so that isn’t an issue.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>David.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> delphi-bounces@delphi.org.nz
[mailto:delphi-bounces@delphi.org.nz] <b>On Behalf Of </b>Charlie<br>
<b>Sent:</b> Sunday, 18 October 2009 10:27 a.m.<br>
<b>To:</b> delphi@delphi.org.nz<br>
<b>Subject:</b> [DUG] Which event to use<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt'>I’m using BDS
2006, InfoPower dbGrid and InfoPower dbComboLookups. My application is for
orders that are placed to purchase the manufactured drawer boxes and uses
master-detail tables; namely orders and orderdetail. Some of the detail data is
entered in either dbEdits or dbLookups. These are used for data that is the
same for each detail record. The dbGrid is used for the particulars for the
items to be manufactured; namely, quantity, width, depth, height, and up to 7
options, the square foot price for the drawer box and the extended price
(computed as square foot price * quantity + cost of the options selected). To
determine the square foot price the program has to use the type of wood chosen
for the drawer boxes, the height of the box, the price table and determine if
the square feet for the box is greater than the minimum 1.5 square feet.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt'>Sometimes the
program finds the correct price and sometimes it doesn’t on the same order. I
have a procedure that ‘calculates’ the price. I think that perhaps I’m over
calling this procedure. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt;color:black'>The
fields for the order and orderdetail tables are persistent.</span><span
lang=EN-US style='font-size:14.0pt'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt'>Currently t<span
style='color:black'>here are several infopower lookup controls which have an
OnCloseUp event. Some of these are attached to the infopower grid. The
‘calculate’ procedure is called in this event. The persistent fields call the ‘</span>calculate’<span
style='color:black'> procedure in the OnValidate and/or the OnExit event. And
to top this off I have the dbGrid calling the ‘</span>calculate<span
style='color:black'>’ procedure for the OnCellChange event. I guess I wanted to
get the price figured out no matter what happened, lol. <o:p></o:p></span></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt;color:black'>So the
question is: What is the way I’m supposed to get the price figured out? Namely,
do I use the DataSet’s OnDataChange event, do I use the persistent fields’
OnValidate event or is it better to use the OnChange event, do I use the
dbGrid’s OnCellChange event, or do I use the controls OnExit or OnCloseUp
event. Or should I do something different?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt;color:black'>I’ve
learned that most folks recommend against using a dbGrid the way that I am; but
my bottom line is I need for each record to have the correct square foot price
and the corresponding total for that record.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt;color:black'>Thank
you for any help.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt;color:black'>Charlie</span><span
lang=EN-US style='font-size:10.0pt;color:black'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:14.0pt;font-family:"Cambria","serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>