Neven
I'm using a softtouch DBLookupCombo to lookup the size from the grid on the
id.
Database is MS Access and connecting through MDAC/ADO.
regards
Chris
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Neven MacEwan
> Sent: Wednesday, 18 October 2000 15:05
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Calculated fields
>
>
> Chris
>
> Several Options
>
> 1/ Do it at the server with a view (if using SQL)
> 2/ Use a Master Detail to the size table and pick it up onCalcFields
> 3/ Use a DBLookupCombo (like softouch) that has the option to
> synch lookup
> table
>
> It is easier to direct you if I knew the databae and connection method
>
> HTH
> Neven
>
>
> ----- Original Message -----
> From: Chris Wallis <[EMAIL PROTECTED]>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Sent: Wednesday, 18 October 2000 14:16
> Subject: [DUG]: Calculated fields
>
>
> > Hi
> >
> > I have a dbgrid that looks as follows:
> >
> > Size 0.9 1.2 1.5 Cubed
> > 100x50 1 5 2 0.0495
> >
> > Size is extracted from another table by using an id key and a lookup
> > combobox that saves the sizeid in the table that makes up
> each line in
> grid.
> > Size table has these fields:
> > id Size LinealFactor
> > e.g. 15 100x50 0.005
> >
> > GridTable has these fields:
> > id Sizeid 0.9 1.2 1.5
> > egg 2154 15 1 5 2
> >
> > How can do extract the lineal factor from the size table
> and use it to
> > calculate the cubed?
> > Cubed=(0.9*1)+(1.2*5)+(1.5*2)*100x50 lineal conversion factor
> > Cubed=9.9*0.005
> > Cubed=0.0495 cubic metres
> >
> > regards
> >
> > Chris Wallis
> >
> >
> --------------------------------------------------------------
> ------------
> -
> > New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
>
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
