X# Runtime and VO SDK Reference
X# Runtime and VO SDK Reference
XSharp.VO.SDK Namespace
SQLSelect Class (Typed)
SQLSelect Methods (Typed)
SQLSelect.AddDateVal Method (Typed)
SQLSelect.AddTimeString Method (Typed)
SQLSelect.Append Method (Typed)
SQLSelect.AppendRow Method (Typed)
SQLSelect.BindColumn Method (Typed)
SQLSelect.Close Method (Typed)
SQLSelect.Column Method (Typed)
SQLSelect.ColumnAttributes Method (Typed)
SQLSelect.Commit Method (Typed)
SQLSelect.DataField Method (Typed)
SQLSelect.Delete Method (Typed)
SQLSelect.DirectSkip Method (Typed)
SQLSelect.Error Method (Typed)
SQLSelect.Execute Method (Typed)
SQLSelect.ExtendedFetch Method (Typed)
SQLSelect.Fetch Method (Typed)
SQLSelect.FieldGet Method (Typed)
SQLSelect.FieldGetFormatted Method (Typed)
SQLSelect.FieldHyperLabel Method (Typed)
SQLSelect.FieldInfo Method (Typed)
SQLSelect.FieldName Method (Typed)
SQLSelect.FieldPos Method (Typed)
SQLSelect.FieldPut Method (Typed)
SQLSelect.FieldSpec Method (Typed)
SQLSelect.FieldStatus Method (Typed)
SQLSelect.FieldSym Method (Typed)
SQLSelect.FieldValidate Method (Typed)
SQLSelect.FindTableName Method (Typed)
SQLSelect.FLock Method (Typed)
SQLSelect.FreeStmt Method (Typed)
SQLSelect.GetData Method (Typed)
SQLSelect.GetdateVal Method (Typed)
SQLSelect.GetLookupTable Method (Typed)
SQLSelect.GetStatementOption Method (Typed)
SQLSelect.GetTimeStamp Method (Typed)
SQLSelect.GetTimeString Method (Typed)
SQLSelect.GoBottom Method (Typed)
SQLSelect.GoTo Method (Typed)
SQLSelect.GoTop Method (Typed)
SQLSelect.NoIVarGet Method (Typed)
SQLSelect.NoIVarPut Method (Typed)
SQLSelect.Notify Method (Typed)
SQLSelect.NumResultCols Method (Typed)
SQLSelect.PreExecute Method (Typed)
SQLSelect.Prepare Method (Typed)
SQLSelect.Refresh Method (Typed)
SQLSelect.RejectChanges Method (Typed)
SQLSelect.Requery Method (Typed)
SQLSelect.ReReadRow Method (Typed)
SQLSelect.ResetCursor Method (Typed)
SQLSelect.ResetNotification Method (Typed)
SQLSelect.RLock Method (Typed)
SQLSelect.RLockVerify Method (Typed)
SQLSelect.Rollback Method (Typed)
SQLSelect.SetColumnAttributes Method (Typed)
SQLSelect.SetDataField Method (Typed)
SQLSelect.SetPos Method (Typed)
SQLSelect.SetPrimaryKey Method (Typed)
SQLSelect.SetStatementOption Method (Typed)
SQLSelect.SetTimeStamp Method (Typed)
SQLSelect.ShowSQLError Method (Typed)
SQLSelect.Skip Method (Typed)
SQLSelect.SuspendNotification Method (Typed)
SQLSelect.UnLock Method (Typed)
SQLSelect.Update Method
SQLSelect.UpdateCursor Method (Typed)
SQLSelect.UpdateKey Method (Typed)
SQLSelect.UpdateVal Method (Typed)
Click or drag to resize

SQLSelect.Append Method (Typed)

X#
Create a blank row in the buffer; this blank row becomes the current position and is ready for assignment of data values. The SQLSelect:RecNo of this buffer is SQLSelect:RecCount+1.

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.19
Syntax
Copy
 VIRTUAL METHOD Append(
	lReleaseLocks AS LOGIC
) AS LOGIC
Request Example View Source

Parameters

lReleaseLocks
Type: Logic

Return Value

Type: Logic
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.
Use FieldPut() to assign values into the blank buffer. When you attempt to move position off this record, an insert will be automatically performed (using SQLSelect:AppendRow()) into the table, using the values in the buffer. You can also deliberately force the update to occur by calling SQLSelect:AppendRow() or SQLSelect:Update(TRUE). 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.
Examples
The following example demonstrates the use of the SQLSelect:Append() method:
X#
Copy
 1FUNCTION NewRecord()
 2LOCAL oSel AS SQLSelect
 3LOCAL oConn AS SQLConnection
 4oConn := SQLConnection{"sample","dba","sql"}
 5oSel := SQLSelect{"SELECT * FROM customer", oConn}
 6oSel:Append()
 7oSel:CustNo := 515
 8oSel:CustName := "Michelle"
 9oSel:GoTop()        // Record inserted at this point
10oSel:FreeStmt(SQL_DROP)
11oConn:Disconnect()
See Also