DOCERR: TABLEUPDATE() Improperly Documented in VFP 5.0 Help (156087)



The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 5.0

This article was previously published under Q156087

SUMMARY

According to the syntax of the TABLEUPDATE() function in Visual FoxPro Help, in order to use the cTableAlias argument, you can supply either the nRows argument or the lForce argument.

This is incorrect; in order to use the cTableAlias argument, both the nRows argument and the lForce argument are required. If they are not supplied, an error appears.

MORE INFORMATION

The following syntax, as documented in the Help documentation, incorrectly indicates that either the nRows argument or the lForce argument is optional in order to use the cTableAlias argument:

TABLEUPDATE([nRows [, lForce]] [, cTableAlias | nWorkArea] [, cErrorArray])

  • nRows: Specifies which changes made to the table or cursor are committed. If nRows is 0 and row or table buffering is enabled, changes made only to the current record in the table or cursor are committed.
  • LForce: Determines whether changes made to the table or cursor by another user on a network are overwritten. If lForce is true (.T.), any changes made to the table or cursor by another user on a network are overwritten.
  • cTableAlias: Specifies the alias of the table or cursor in which the changes are committed.
Here are two examples that use the nRows = 1, lForce = .T., and cTableAlias = 'Customer' arguments:
   =TABLEUPDATE(.T.,'Customer')     && This generates an error
				
   =TABLEUPDATE(1, .T., 'Customer') && This works without an error
				

Modification Type:MajorLast Reviewed:8/17/1999
Keywords:KB156087