UPDATE - SQL Command Example

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