private string GetDialogueID(Character character) { string qry = "SELECT CharacterDialogues.DialogueIDs FROM CharacterDialogues " + "INNER JOIN ActivatedDialogues ON CharacterDialogues.DialogueIDs = ActivatedDialogues.DialogueIDs " + "WHERE CharacterDialogues.CharacterNames = " + DbCommands.GetParameterNameFromValue(character.CharacterName) + " AND ActivatedDialogues.Completed = 0" + " AND ActivatedDialogues.SaveIDs = 0"; string dialogueID = DbCommands.GetFieldValueFromQry(qry, "DialogueIDs", character.CharacterName); Debugging.PrintDbQryResults(qry, character.CharacterName); //Debugging.PrintDbTable("ActivatedDialogues"); return(dialogueID); }