Packageat.db
Classpublic class UpdateAsset

Class for updating a single record from the table tbl_Asset in the application database.



Public Properties
 PropertyDefined by
  activeEdit : String = "Y"
Holds the active value to be inserted into the active column of the table tbl_Asset in the application database.
UpdateAsset
  assetID : int
Holds the assetID value passed into the class used to reference the existing asset record for updating in the application database.
UpdateAsset
  bookmarkidEdit : int
Holds the bookmarkid value to be inserted into the bookmarkid column of the table tbl_Asset in the application database.
UpdateAsset
  brandidEdit : int
Holds the brandid value to be inserted into the brandid column of the table tbl_Asset in the application database.
UpdateAsset
  commentsEdit : String
Holds the comments value to be inserted into the comments column of the table tbl_Asset in the application database.
UpdateAsset
  datemodified : String
Holds the datemodified value to be inserted into the datemodified column of the table tbl_Asset in the application database.
UpdateAsset
  descriptionEdit : String
Holds the description value to be inserted into the description column of the table tbl_Asset in the application database.
UpdateAsset
  filenameEdit : String
Holds the filename value to be inserted into the filename column of the table tbl_Asset in the application database.
UpdateAsset
  id2Edit : int = 0
Holds the id2 value to be inserted into the id2 column of the table tbl_Asset in the application database.
UpdateAsset
  indicationidEdit : int
Holds the indicationid value to be inserted into the indicationid column of the table tbl_Asset in the application database.
UpdateAsset
  locationEdit : String
Holds the location value to be inserted into the location column of the table tbl_Asset in the application database.
UpdateAsset
  nameEdit : String
Holds the name value to be inserted into the name column of the table tbl_Asset in the application database.
UpdateAsset
  repbagidEdit : int
Holds the repbagid value to be inserted into the repbagid column of the table tbl_Asset in the application database.
UpdateAsset
  sectionidEdit : int
Holds the sectionid value to be inserted into the sectionid column of the table tbl_Asset in the application database.
UpdateAsset
  sizeEdit : int
Holds the size value to be inserted into the size column of the table tbl_Asset in the application database.
UpdateAsset
  slideidEdit : int
Holds the slideid value to be inserted into the slideid column of the table tbl_Asset in the application database.
UpdateAsset
  typeidEdit : int
Holds the typenid value to be inserted into the typeid column of the table tbl_Asset in the application database.
UpdateAsset
  versionEdit : int = 0
Holds the version value to be inserted into the version column of the table tbl_Asset in the application database.
UpdateAsset
  whomodified : int
Holds the whomodified value to be inserted into the whomodified column of the table tbl_Asset in the application database.
UpdateAsset
Public Methods
 MethodDefined by
  
UpdateAsset(assetID:int, id2Input:int, brandidInput:int, indicationidInput:int, sectionidInput:int, slideidInput:int, bookmarkidInput:int, repbagidInput:int, typeidInput:int, filenameInput:String, sizeInput:int, locationInput:String, nameInput:String, descriptionInput:String, commentsInput:String, versionInput:int, activeInput:String)
Constructor.
UpdateAsset
Protected Methods
 MethodDefined by
  
init():void
Init.
UpdateAsset
  
onDBStatementEditResult(event:SQLEvent):void
Listener handler method for database SQL statement result.
UpdateAsset
  
onEveDBError(event:SQLEvent):void
Error handler method for database connection errors.
UpdateAsset
  
onEveDBOpened(event:SQLEvent):void
Updates an existing asset record in the table tbl_Asset in the application database.
UpdateAsset
Property detail
activeEditproperty
public var activeEdit:String = "Y"

Holds the active value to be inserted into the active column of the table tbl_Asset in the application database.

The default value is Y.

assetIDproperty 
public var assetID:int

Holds the assetID value passed into the class used to reference the existing asset record for updating in the application database.

bookmarkidEditproperty 
public var bookmarkidEdit:int

Holds the bookmarkid value to be inserted into the bookmarkid column of the table tbl_Asset in the application database.

brandidEditproperty 
public var brandidEdit:int

Holds the brandid value to be inserted into the brandid column of the table tbl_Asset in the application database.

commentsEditproperty 
public var commentsEdit:String

Holds the comments value to be inserted into the comments column of the table tbl_Asset in the application database.

datemodifiedproperty 
public var datemodified:String

Holds the datemodified value to be inserted into the datemodified column of the table tbl_Asset in the application database.

descriptionEditproperty 
public var descriptionEdit:String

Holds the description value to be inserted into the description column of the table tbl_Asset in the application database.

filenameEditproperty 
public var filenameEdit:String

Holds the filename value to be inserted into the filename column of the table tbl_Asset in the application database.

id2Editproperty 
public var id2Edit:int = 0

Holds the id2 value to be inserted into the id2 column of the table tbl_Asset in the application database. Primarily used for synchronization with a remote database.

The default value is 0.

indicationidEditproperty 
public var indicationidEdit:int

Holds the indicationid value to be inserted into the indicationid column of the table tbl_Asset in the application database.

locationEditproperty 
public var locationEdit:String

Holds the location value to be inserted into the location column of the table tbl_Asset in the application database.

nameEditproperty 
public var nameEdit:String

Holds the name value to be inserted into the name column of the table tbl_Asset in the application database.

repbagidEditproperty 
public var repbagidEdit:int

Holds the repbagid value to be inserted into the repbagid column of the table tbl_Asset in the application database.

sectionidEditproperty 
public var sectionidEdit:int

Holds the sectionid value to be inserted into the sectionid column of the table tbl_Asset in the application database.

sizeEditproperty 
public var sizeEdit:int

Holds the size value to be inserted into the size column of the table tbl_Asset in the application database.

slideidEditproperty 
public var slideidEdit:int

Holds the slideid value to be inserted into the slideid column of the table tbl_Asset in the application database.

typeidEditproperty 
public var typeidEdit:int

Holds the typenid value to be inserted into the typeid column of the table tbl_Asset in the application database.

versionEditproperty 
public var versionEdit:int = 0

Holds the version value to be inserted into the version column of the table tbl_Asset in the application database. Primarily used for synchronization with a remote database.

The default value is 0.

whomodifiedproperty 
public var whomodified:int

Holds the whomodified value to be inserted into the whomodified column of the table tbl_Asset in the application database.

Constructor detail
UpdateAsset()constructor
public function UpdateAsset(assetID:int, id2Input:int, brandidInput:int, indicationidInput:int, sectionidInput:int, slideidInput:int, bookmarkidInput:int, repbagidInput:int, typeidInput:int, filenameInput:String, sizeInput:int, locationInput:String, nameInput:String, descriptionInput:String, commentsInput:String, versionInput:int, activeInput:String)

Constructor.

Parameters
assetID:int
 
id2Input:int
 
brandidInput:int
 
indicationidInput:int
 
sectionidInput:int
 
slideidInput:int
 
bookmarkidInput:int
 
repbagidInput:int
 
typeidInput:int
 
filenameInput:String
 
sizeInput:int
 
locationInput:String
 
nameInput:String
 
descriptionInput:String
 
commentsInput:String
 
versionInput:int
 
activeInput:String
Method detail
init()method
protected function init():void

Init. Establishes connection to the application database.

onDBStatementEditResult()method 
protected function onDBStatementEditResult(event:SQLEvent):void

Listener handler method for database SQL statement result.

Parameters
event:SQLEventSQLEvent
onEveDBError()method 
protected function onEveDBError(event:SQLEvent):void

Error handler method for database connection errors.

Parameters
event:SQLEventSQLEvent
onEveDBOpened()method 
protected function onEveDBOpened(event:SQLEvent):void

Updates an existing asset record in the table tbl_Asset in the application database.

Parameters
event:SQLEventSQLEvent