SQLSelect.AppendRow Method | |
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.19
Syntax VIRTUAL METHOD AppendRow(
lForce
) AS USUAL CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public virtual Usual AppendRow(
Usual lForce = default
)
Request Example
View SourceParameters
- 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 |
---|
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 |
---|
To cancel the pending update, call the SQLSelect:Delete() method. |
See Also