Click or drag to resize

SQLSelect.AppendRow Method

X#
Insert the row that has been created in the buffer since the last SQLSelect:Append() operation.

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
Syntax
 VIRTUAL METHOD AppendRow(
	lForce
) AS USUAL CLIPPER
Request Example View Source

Parameters

lForce (Optional)
Type: Usual
A logical value determining whether the update should occur. If omitted, the default is TRUE.

Return Value

Type: Usual
TRUE if successful; otherwise, FALSE.
Remarks
Tip Tip
The details of the implementation of this method, and how it interacts with other operations such as unique indexes and concurrency control, depend on the particular database.
This method is used to actually perform the insertion of a row into the table after the SQLSelect:Append() and SQLSelect:FieldPut() operations have been performed, which insert a blank row into the buffer and assign values into the buffer. It is not necessary to call SQLSelect:AppendRow() in all cases, since it will be called automatically when the position is changed (for example, using GoTop(), Skip(), etc.), using the values in the buffer. If the AutoCommit option is off, you may need to invoke the Commit() method to insert the row into the database.
Tip Tip
To cancel the pending update, call the SQLSelect:Delete() method.
See Also