AddForUpdate

Object and Type

Object  : FCGeneric

Type     : Method

Prototype

Public Sub AddForUpdate(TheObjid As Long)

Description

This method is used when you know the objid of a database record, and wish to update it, but do not wish to take the time to query it from the database. Calling this method will add a new record (for updating) to the recordset, and will set the objid field to the specified parameter.

You can then change any fields, or set any relations, just like any other record. Unlike the AddNew method, this method will not attempt to insert a record into the database.

Note: This method does not validate the objid you provide. If it is illegal, you will receive a runtime error when you attempt to update the record.

Parameters

Parameter Name	Required?	Description
theObjid	Yes	This is the objid of the record to update

Error Codes

Value	Meaning
12031	This operation is not valid for a generic that is marked distinct

Examples

The following example creates a new record in the recordset for the case table for update. It then updates the alt_city field.

JavaScript:

  // Allocate the case
  var boCase = FCSession.CreateGeneric();
  boCase.SimpleQuery("case");

  // Add a row for update, modify it, and commit
  boCase.AddForUpdate("268435457");
  boCase ("alt_city") = "My town";
  boCase.Update();

Visual Basic:

  Dim boCase As FCGeneric
  Set boCase = fc_session.CreateGeneric

  boCase.SimpleQuery "case"
  boCase.AddForUpdate 268435457
  boCase("alt_city") = "Your city"
  boCase.Update