The following example opens the customer
table in the testdata
database. UPDATE -SQL is used to set all of the values in the maxordamt
field to 25.
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE Customer && Open customer table
* Set and display amounts for customers
UPDATE customer SET maxordamt = 25
BROWSE FIELDS company,maxordamt