New call-to-action
Results 1 to 2 of 2

Thread: Update Recalculate Fields

  1. #1
    Member
    Real Name
    Mark Willard
    Join Date
    Dec 2012
    Posts
    279

    Default Update Recalculate Fields

    Hi,

    I am wondering if I can use a5_recalc_calc_fields() to update specific rows in the table.

    Example:

    1|123|CALFIELD
    1|567|CALFIELD
    3|876|CALFIELD

    Here I would like to update only the record whose id=1 when I open the form.

    It is possible?

    Thanks.
    Mark

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Update Recalculate Fields

    No, that function recalculates all calculated fields.

    tbl = table.open("yourtablename")
    'if id field is numeric
    tbl.query_create("N","id = 1")
    'if id field is character
    tbl.query_create("N","id = '1' ")
    tbl.fetch_first()
    while .not. tbl.fetch_eof()
    tbl.change_begin()
    tbl.change_end(.T.)
    end while
    tbl.close()
    end
    There can be only one.

Similar Threads

  1. RE: Issue: Recalculate Calc Fields (Field Rules)
    By markbwillard in forum Alpha Five Version 11 - Desktop Applications
    Replies: 2
    Last Post: 01-14-2013, 10:48 AM
  2. Calculated fields update - fails to update the dbf
    By kartik in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 05-29-2012, 02:28 PM
  3. How to recalculate calculated fields of one record within a grid?
    By René Stout in forum Application Server Version 8
    Replies: 0
    Last Post: 12-29-2007, 12:29 PM
  4. How to Recalculate
    By walhoney in forum Alpha Five Version 5
    Replies: 7
    Last Post: 11-23-2004, 03:51 AM
  5. Forcing calc fields to recalculate
    By drgarytraub in forum Alpha Five Version 5
    Replies: 10
    Last Post: 09-23-2003, 03:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •