Error in Documentation for UPDATE CommandID: Q105145 The information in this article applies to:
The UPDATE command updates fields in the current table/.DBF with data from a table/.DBF open in another work area. A portion of the syntax, as stated on page L3-1104 of the "Language Reference," is as follows: UPDATE ON <field> FROM <expN> | <expC> ... As shown above, the FROM table can be specified with the work area number of the table. Doing this will, however, cause a syntax error. For example, if the CUSTOMER table has been opened into work area 1, the following command will result in a syntax error: UPDATE ON <field> FROM 1 ... To avoid this problem, specify the alias name of the table instead of the work area number, as follows: UPDATE ON <field> FROM customer ... Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a workarea docerr KBCategory: kbprg kbdocerr KBSubcategory: FxprgGeneral |
Last Reviewed: June 27, 1995 |