Write Method (DBAccess)

Update the last read row in the database with the new value passed in the dataArea argument.

Syntax

public DBResponse Write( 
   out string dataArea
)

Parameters

dataArea: The passed/returned data area.

Return Value

Returns a value indicating the status of the call.

Remarks

The row/record must have previously been read uisng the Read(String,Int32,String), ReadFirst, ReadLast, ReadNext, ReadPrev methods to "lock" the row in the database.

Example

string itemRecord;
Int32 chan;
Symphony.dB.DBAccess itemAccess = new DBAccess("ITEM", "DATABASE:DatabaseManager");
if (itemAccess.OpenUpdate(out chan) == DBResponse.DBOK)
{
    //Store the record data to the database table
    if (itemAccess.Read("SOL001", 0, out itemRecord) == DBResponse.DBOK)
    {
        //Make and changes and upadte the table
        itemAccess.Write(out itemRecord);
    }
}

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DBAccess Class
DBAccess Members