Database Commands SECTION 6 Functions and Methods
113
Remarks
Typical Example
DBAddNew("Northwind.Order Details.OrderID")
DBAddNew("Northwind.Order Details.ProductID")
DBAddNew("Northwind.Order Details.Quantity")
DBAddNew("Northwind.Order Details.UnitPrice")
DBUpdate("Northwind.Order Details")
Each required field is added to the new record using multiple calls to
DBAddNew(). When the record is complete, it is added to the Recordset by
calling the DBUpdate() function.
6-17-14 DBWrite
Description
Writes a set of records into a Recordset from the associated point(s). This
function operates on both Recordset and Field levels. At the Recordset level
all the associated points values from the Points will be written into the
Recordset starting at the current record (1 page of values will be written for
each Point). At the Field level the associated values from the point are written
into the Recordsets starting at the current position. The number of elements
written = number of elements in the Point. This function will fail, if the
Recordset is opened with a Lock of 'Read Only'.
Syntax
return = DBWrite(level, reset)
Remarks
Typical Examples
DBWrite("Northwind.Customers")
Write all point values to the associated Customers fields.
DBWrite("Northwind.Customers.Address", FALSE)
Write the point values to the Address column, and leave the cursor at the next
set of records.
Argument Type Description
return bool 1 if the specified level is in the requested state,
otherwise 0
level text A text point or constant specifying the
connection level. This may be a Connection or
Recordset level.
Argument Type Description
return bool 1 if the specified level is in the requested state,
otherwise 0
level text A text point or constant specifying the
connection level. This may be a Connection or
Recordset level.
reset bool This argument is optional and may be omitted.
If omitted or TRUE, when the write is complete
the record cursor is reset to the position prior to
writing.
To Next Page
Loading...
Need help?
General