if (StructKeyExists(URL,"TypeDesignationId") And URL.TypeDesignationId neq 0) isExistingTypeDesignation = true; else isExistingTypeDesignation = false; if (StructKeyExists(URL,"newRefFk")) session.RefFk = URL.newRefFk; else session.RefFk = ""; jsOnLoad = "initrefs();"; // save everything to session variables to repopulate form after the user adds a reference session.TypePhrase = form.TypePhrase; session.TypeStatusFk = form.TypeStatusFk; session.RefFk = form.RefId; session.ReferenceDetail = form.ReferenceDetail; session.Notes = form.Notes; if (StructKeyExists(Form,"RejectedFlag")) session.RejectedFlag = 1; else session.RejectedFlag = 0; if (form.TypePhrase eq "") session.TypePhrase = "NULL"; else session.TypePhrase = "N'" & Replace(form.TypePhrase,"'", "''", "All") & "'"; if (form.TypeStatusFk eq "") session.TypeStatusFk = "NULL"; else session.TypeStatus = form.TypeStatusFk; if (form.RefId eq "") session.RefFk = "NULL"; else session.RefFk = form.RefId; if (form.ReferenceDetail eq "") session.ReferenceDetail = "NULL"; else session.ReferenceDetail = "'" & Replace(form.ReferenceDetail,"'", "''", "All") & "'"; if (StructKeyExists(Form,"RejectedFlag")) session.RejectedFlag = 1; else session.RejectedFlag = 0; if (form.Notes eq "") session.Notes = "NULL"; else session.Notes = "N'" & Replace(form.Notes,"'", "''", "All") & "'"; UPDATE TypeDesignation SET TypePhrase = #PreserveSingleQuotes(session.TypePhrase)#, TypeStatusFk = #session.TypeStatusFk#, RefFk = #session.RefFk#, RefDetail = #PreserveSingleQuotes(session.ReferenceDetail)#, RejectedFlag = #session.RejectedFlag#, Updated_Who = '#Session.UserName#', Updated_When = GETDATE(), Notes = #PreserveSingleQuotes(session.Notes)# WHERE TypeDesignationId = #URL.TypeDesignationId# SELECT ISNULL(MAX(TypeDesignationId) + 1, 1) AS Id FROM TypeDesignation INSERT INTO TypeDesignation (TypeDesignationId, NameFk, TypePhrase, TypeStatusFk, RefFk, RefDetail, RejectedFlag, Created_Who, Created_When, Notes) VALUES (#NewTypeDesignationId.Id#, #URL.Name#, #PreserveSingleQuotes(session.TypePhrase)#, #session.TypeStatusFk#, #session.RefFk#, #PreserveSingleQuotes(session.ReferenceDetail)#, #session.RejectedFlag#, '#Session.UserName#', GETDATE(), #PreserveSingleQuotes(session.Notes)#) SELECT TypeStatusId, Status, StatusAbbrev, Description FROM TypeStatus ORDER BY TypeStatusId SELECT TypePhrase, TypeStatusFk, RefFk, RefDetail, RejectedFlag, Notes FROM TypeDesignation WHERE TypeDesignationId = #URL.TypeDesignationId# if (session.RefFk eq "") session.RefFk = TypeDesignation.RefFk; session.TypePhrase = TypeDesignation.TypePhrase; session.TypeStatusFk = TypeDesignation.TypeStatusFk; session.ReferenceDetail = TypeDesignation.RefDetail; session.RejectedFlag = TypeDesignation.RejectedFlag; session.Notes = TypeDesignation.Notes; session.TypePhrase = ""; session.TypeStatusFk = ""; session.ReferenceDetail = ""; session.RejectedFlag = 0; session.Notes = "";

Edit type designation for
Create new type designation for
 #OnePT.FullNameCache#

Type Status
Type Phrase
Reference Select new reference
  Remove
Reference Detail
Rejected checked>
Notes