Groups > dBase > Getting Started with dBase > Re: Force Display Field Contents




Force Display Field Contents

Force Display Field Contents
Sun, 13 Apr 2008 01:46:22 -040
Post Reply
Re: Force Display Field Contents
Sun, 13 Apr 2008 03:23:33 -040
In article <2krJ0mSnIHA.632@news-server>, bmckinney721@bellsouth.net 
says...
> Using dB+2.6 w/XP/pro.  How do you force a programmically changed numeric
field to immediately display the contents on a form?  Example: Exten =
Qty*Price.  As soon as I change either 'Price' or 'Qty' I want the 'exten' field
to 
show the changed results.  What and where would you place such code? Also, when
I close the LineItem form and return to the LineItem grid, I must click on the
last row button for it to show up in the grid.  I've tried several 
methods w/no luck.  Thanks....Bob
> 

Bob,

Is the extension field a regular field or a dBASE calculated field?

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
Post Reply
Re: Force Display Field Contents
Sun, 13 Apr 2008 03:58:38 -040
Geoff Wass [dBVIPS] Wrote:

> In article <2krJ0mSnIHA.632@news-server>, bmckinney721@bellsouth.net

> says...
> > Using dB+2.6 w/XP/pro.  How do you force a programmically changed
numeric field to immediately display the contents on a form?  Example: Exten =
Qty*Price.  As soon as I change either 'Price' or 'Qty' I want the 'exten' field
to 
> show the changed results.  What and where would you place such code? Also,
when I close the LineItem form and return to the LineItem grid, I must click on
the last row button for it to show up in the grid.  I've tried several 
> methods w/no luck.  Thanks....Bob
> > 
> Geoff wrote
> Bob,
> 
> Is the extension field a regular field or a dBASE calculated field?
> 
> -- 
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
> 
> Bob answered:
Post Reply
Re: Force Display Field Contents
Sun, 13 Apr 2008 08:10:59 -040
Bob:

    Why not set up an On_Change trigger that pushes the calculated amount into
the field.  You'd have to set up on for each entry that effects the results (or
have each point to the same function).

JM 

Bob McKinney Wrote:

> Geoff Wass [dBVIPS] Wrote:
> 
> > In article <2krJ0mSnIHA.632@news-server>,
bmckinney721@bellsouth.net 
> > says...
> > > Using dB+2.6 w/XP/pro.  How do you force a programmically changed
numeric field to immediately display the contents on a form?  Example: Exten =
Qty*Price.  As soon as I change either 'Price' or 'Qty' I want the 'exten' field
to 
> > show the changed results.  What and where would you place such code?
Also, when I close the LineItem form and return to the LineItem grid, I must
click on the last row button for it to show up in the grid.  I've tried several

> > methods w/no luck.  Thanks....Bob
> > > 
> > Geoff wrote
> > Bob,
> > 
> > Is the extension field a regular field or a dBASE calculated field?
> > 
> > -- 
> > Geoff Wass [dBVIPS]
> > Montréal, Québec, Canada
> > 
> > Bob answered:
> Geoff: Field is a MyEntryfield, regular entryfield, not a dB calculated
field....Bob
Post Reply
Re: Force Display Field Contents
Sun, 13 Apr 2008 11:09:46 -040
Bob replied:
John: I assume you are referring to code such as shown below.
  function EQUANTITY_onChange
      rs = form.InvoicesDataModule1.Lineitem1.rowset
      nQt = rs.fields["Quantity"].value 
      do case
      case nQT >1 and nLn >0 
           nPr := nPr*nLn         
           nEx := nQt*nPr
      case nQt >1
           nEx := nQt*nPr
   endCase
   // load rowset field w/mv
   rs.fields["Extension"].value := nEx
   rs.refreshControls()
      return
I have two similiar codeblocks with the same results, I must click on the form
face to cause the changed contents of 'extension' to be visable .  Am I leaving
something out?  Thanks for your reply.  Now for the Master's....Bob
>
>john marshall Wrote:

> 
> Bob:
> 
>     Why not set up an On_Change trigger that pushes the calculated amount
into the field.  You'd have to set up on for each entry that effects the results
(or have each point to the same function).
> 
> JM 
> 
> Bob McKinney Wrote:
> 
> > Geoff Wass [dBVIPS] Wrote:
> > 
> > > In article <2krJ0mSnIHA.632@news-server>,
bmckinney721@bellsouth.net 
> > > says...
> > > > Using dB+2.6 w/XP/pro.  How do you force a programmically
changed numeric field to immediately display the contents on a form?  Example:
Exten = Qty*Price.  As soon as I change either 'Price' or 'Qty' I want the
'exten' field to 
> > > show the changed results.  What and where would you place such
code? Also, when I close the LineItem form and return to the LineItem grid, I
must click on the last row button for it to show up in the grid.  I've tried
several 
> > > methods w/no luck.  Thanks....Bob
> > > > 
> > > Geoff wrote
> > > Bob,
> > > 
> > > Is the extension field a regular field or a dBASE calculated
field?
> > > 
> > > -- 
> > > Geoff Wass [dBVIPS]
> > > Montréal, Québec, Canada
> > > 
> > > Bob answered:
> > Geoff: Field is a MyEntryfield, regular entryfield, not a dB
calculated field....Bob
> 
Post Reply
<< Previous 1 2 Next >>
( Page 1 of 2 )
about | contact