Microsoft KB Archive/105145: Difference between revisions
m (Text replacement - "<" to "<") |
m (Text replacement - ">" to ">") |
||
Line 12: | Line 12: | ||
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: | 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: | ||
<pre> UPDATE ON <field | <pre> UPDATE ON <field> FROM <expN> | <expC> ... | ||
</pre> | </pre> | ||
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: | 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: | ||
<pre> UPDATE ON <field | <pre> UPDATE ON <field> FROM 1 ... | ||
</pre> | </pre> | ||
To avoid this problem, specify the alias name of the table instead of the work area number, as follows: | To avoid this problem, specify the alias name of the table instead of the work area number, as follows: | ||
<pre> UPDATE ON <field | <pre> UPDATE ON <field> FROM customer ... | ||
</pre> | </pre> | ||
Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a workarea docerr KBCategory: kbprg kbdocerr KBSubcategory: FxprgGeneral | Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a workarea docerr KBCategory: kbprg kbdocerr KBSubcategory: FxprgGeneral |
Latest revision as of 17:45, 20 July 2020
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 |