ADXUPREC

Summary


Adxuprec is used to identify the number of records updated by an Update instruction.

Class, type and dimension

Long integer [S]Adxuprec  

Examples

   # Update of the FLGACTIF field in the CLIENT file for all the
   # records where the DEBIT and CREDIT fields are at 0.
    File CLIENT [CLI]
    Update [CLI] Where DEBIT = 0 and CREDIT = 0 and FLGACTIF <> 1
    & With FLGACTIF = 1
   # number of modified records
    Infbox "number of modified records"-num$(Adxuprec)
   # verification that there are no more
    For [CLI]
      N += 1
    Next
    If N : Errbox num$(N)-"records not modified" :     Endif
 

Description and comments

The variable Adxupreccontains the number of records updated in a table by the Update instruction .

 The Adxuprec number is significant on the conditions that fstat is null (that is to say if at least one record has been modified).

Associated errors

No associated errors.

Associated keywords

UPDATE - FSTAT


SUMMARY


Copyright © Sage 1999 - 2007