/** * Deletes an associated AuditScan * @param AuditScan $objAuditScan * @return void */ public function DeleteAssociatedAuditScan(AuditScan $objAuditScan) { if (is_null($this->intLocationId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateAuditScan on this unsaved Location.'); } if (is_null($objAuditScan->AuditScanId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateAuditScan on this Location with an unsaved AuditScan.'); } // Get the Database Object for this Class $objDatabase = Location::GetDatabase(); // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `audit_scan` WHERE `audit_scan_id` = ' . $objDatabase->SqlVariable($objAuditScan->AuditScanId) . ' AND `location_id` = ' . $objDatabase->SqlVariable($this->intLocationId) . ' '); // Journaling if ($objDatabase->JournalingDatabase) { $objAuditScan->Journal('DELETE'); } }