Packageat.db
Classpublic class UpdateRep

Class for updating a single record from the table tbl_Rep 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_Rep in the application database.
UpdateRep
  commentsEdit : String
Holds the comments value to be inserted into the comments column of the table tbl_Rep in the application database.
UpdateRep
  datemodified : String
Holds the datemodified value to be inserted into the datemodified column of the table tbl_Rep in the application database.
UpdateRep
  descriptionEdit : String
Holds the description value to be inserted into the description column of the table tbl_Rep in the application database.
UpdateRep
  emailaddressEdit : String
Holds the emailaddress value to be inserted into the emailaddress column of the table tbl_Rep in the application database.
UpdateRep
  extrepidEdit : String
Holds the extrepid value to be inserted into the extrepid column of the table tbl_Rep in the application database.
UpdateRep
  firstnameEdit : String
Holds the firstname value to be inserted into the firstname column of the table tbl_Rep in the application database.
UpdateRep
  id2Edit : int = 0
Holds the id2 value to be inserted into the id2 column of the table tbl_Rep in the application database.
UpdateRep
  lastnameEdit : String
Holds the lastname value to be inserted into the lastname column of the table tbl_Rep in the application database.
UpdateRep
  nameEdit : String
Holds the name value to be inserted into the name column of the table tbl_Rep in the application database.
UpdateRep
  passwordEdit : String
Holds the password value to be inserted into the password column of the table tbl_Rep in the application database.
UpdateRep
  repID : int
Holds the repID value passed into the class used to reference the existing rep record for updating in the application database.
UpdateRep
  usernameEdit : String
Holds the username value to be inserted into the username column of the table tbl_Rep in the application database.
UpdateRep
  versionEdit : int = 0
Holds the version value to be inserted into the version column of the table tbl_Rep in the application database.
UpdateRep
  whomodified : int
Holds the whomodified value to be inserted into the whomodified column of the table tbl_Rep in the application database.
UpdateRep
Public Methods
 MethodDefined by
  
UpdateRep(repID:int, id2Input:int, extrepidInput:String, firstnameInput:String, lastnameInput:String, emailaddressInput:String, usernameInput:String, passwordInput:String, nameInput:String, descriptionInput:String, commentsInput:String, versionInput:int, activeInput:String)
Constructor.
UpdateRep
Protected Methods
 MethodDefined by
  
init():void
Init.
UpdateRep
  
onDBStatementEditResult(event:SQLEvent):void
Listener handler method for database SQL statement result.
UpdateRep
  
onEveDBError(event:SQLEvent):void
Error handler method for database connection errors.
UpdateRep
  
onEveDBOpened(event:SQLEvent):void
Updates an existing rep record in the table tbl_Rep in the application database.
UpdateRep
Property detail
activeEditproperty
public var activeEdit:String = "Y"

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

The default value is Y.

commentsEditproperty 
public var commentsEdit:String

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

datemodifiedproperty 
public var datemodified:String

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

descriptionEditproperty 
public var descriptionEdit:String

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

emailaddressEditproperty 
public var emailaddressEdit:String

Holds the emailaddress value to be inserted into the emailaddress column of the table tbl_Rep in the application database.

extrepidEditproperty 
public var extrepidEdit:String

Holds the extrepid value to be inserted into the extrepid column of the table tbl_Rep in the application database.

firstnameEditproperty 
public var firstnameEdit:String

Holds the firstname value to be inserted into the firstname column of the table tbl_Rep 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_Rep in the application database. Primarily used for synchronization with a remote database.

The default value is 0.

lastnameEditproperty 
public var lastnameEdit:String

Holds the lastname value to be inserted into the lastname column of the table tbl_Rep in the application database.

nameEditproperty 
public var nameEdit:String

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

passwordEditproperty 
public var passwordEdit:String

Holds the password value to be inserted into the password column of the table tbl_Rep in the application database.

repIDproperty 
public var repID:int

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

usernameEditproperty 
public var usernameEdit:String

Holds the username value to be inserted into the username column of the table tbl_Rep 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_Rep 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_Rep in the application database.

Constructor detail
UpdateRep()constructor
public function UpdateRep(repID:int, id2Input:int, extrepidInput:String, firstnameInput:String, lastnameInput:String, emailaddressInput:String, usernameInput:String, passwordInput:String, nameInput:String, descriptionInput:String, commentsInput:String, versionInput:int, activeInput:String)

Constructor.

Parameters
repID:int
 
id2Input:int
 
extrepidInput:String
 
firstnameInput:String
 
lastnameInput:String
 
emailaddressInput:String
 
usernameInput:String
 
passwordInput: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 rep record in the table tbl_Rep in the application database.

Parameters
event:SQLEventSQLEvent