/** * Deletes an associated RoleTransactionTypeAuthorization * @param RoleTransactionTypeAuthorization $objRoleTransactionTypeAuthorization * @return void */ public function DeleteAssociatedRoleTransactionTypeAuthorization(RoleTransactionTypeAuthorization $objRoleTransactionTypeAuthorization) { if (is_null($this->intRoleId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateRoleTransactionTypeAuthorization on this unsaved Role.'); } if (is_null($objRoleTransactionTypeAuthorization->RoleTransactionTypeAuthorizationId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateRoleTransactionTypeAuthorization on this Role with an unsaved RoleTransactionTypeAuthorization.'); } // Get the Database Object for this Class $objDatabase = Role::GetDatabase(); // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `role_transaction_type_authorization` WHERE `role_transaction_type_authorization_id` = ' . $objDatabase->SqlVariable($objRoleTransactionTypeAuthorization->RoleTransactionTypeAuthorizationId) . ' AND `role_id` = ' . $objDatabase->SqlVariable($this->intRoleId) . ' '); // Journaling if ($objDatabase->JournalingDatabase) { $objRoleTransactionTypeAuthorization->Journal('DELETE'); } }