SELECT OfficeName TOfficeName FROM Office WHERE OfficeID=;OUTPUT NIL

  Office: - Edit

SELECT SecLink FROM Security WHERE SecLink=58 AND UserLink=;OUTPUT NIL UPDATE Office SET Category=,OfficeName=,Honorific=,HonorificAbbr=,Description=,IsHTML=,Priority=,EquivalentTo= WHERE OfficeID=;OUTPUT NIL - Saved Changes INSERT INTO Office (Category,OfficeName,Honorific,HonorificAbbr,Description,IsHTML,Priority,EquivalentTo) VALUES (,,, ,,,,);OUTPUT NIL - Saved New Information Link UPDATE OfficeHonorific SET Honorific=,SQL>,HonorificAbbr=,SQL> WHERE OfficeHonorificID=;OUTPUT NIL SELECT OfficeHonorificID FROM OfficeHonorific WHERE OfficeLink=;OUTPUT INSERT INTO OfficeHonorific (OfficeLink,Honorific,HonorificAbbr) values (,,SQL>,,SQL>);OUTPUT NIL SELECT * FROM Office WHERE OfficeID=;OUTPUT NIL SELECT * FROM OfficeHonorific WHERE OfficeLink= ORDER BY Honorific;OUTPUT ADD EDIT OFFICE Category selected="selected"> SELECT DISTINCT Category TCat FROM Office ORDER BY Category;OUTPUT *Other - Enter Below Office Name Default Honorific Default Honorific Abbreviation Description <VAR Description,Safe> Is HTML? eq 'Y'> CHECKED> - Check if the Description box contains HTML. Equivalent To --Base Value-- selected="selected"> SELECT OfficeID EQID,OfficeName EQName FROM Office WHERE EquivalentTo=0 ORDER BY OfficeName;OUTPUT Priority ADD EDIT ALTERNATIVE HONORIFICS Honorific Honorific Abbreviation