public string setUnswerType(int unswrId, UnswerType type)
{
return("INSERT INTO Objects_references VALUES(" + unswrId + ", " +
getSubQueryForGettingUnswersTypeId(type) + ", " +
getSubQueryForGettingAttrId(DbAttrs.unswersType.getName()) + ");");
}
private string getSubQueryForGettingUnswersTypeId(UnswerType type)
{
return("(SELECT id FROM Objects WHERE Type" +
"=" + getSubQueryForGettingTypeId(DbTypes.unswerT.getName()) +
" AND name='" + type.getType() + "')");
}
