protected override string PlatformCreateTableRelationSQL(RelationDefInfo relInfo) { string strCNames = relInfo.FieldNameColumnLnList(); string strFNames = relInfo.ForeignFieldNameColumnLnList(); string strSQL = (""); strSQL += ("FOREIGN KEY("); strSQL += strFNames; strSQL += (") REFERENCES "); strSQL += relInfo.m_strTable; strSQL += ("("); strSQL += strCNames; strSQL += (")"); return(strSQL); }
protected string CreateRelationSQL(RelationDefInfo relInfo, string addBegin, string addClose) { string strCNames = relInfo.FieldNameColumnLnList(); string strFNames = relInfo.ForeignFieldNameColumnLnList(); string strSQL = ("ALTER TABLE "); strSQL += relInfo.m_strForeignTable; strSQL += (" ADD "); strSQL += addBegin; strSQL += ("CONSTRAINT "); strSQL += relInfo.m_strName; strSQL += (" FOREIGN KEY ("); strSQL += strFNames; strSQL += (") REFERENCES "); strSQL += relInfo.m_strTable; strSQL += (" ("); strSQL += strCNames; strSQL += (")"); strSQL += addClose; return(strSQL); }