Have the code "Restrict Posting to Itself" any Dual Alias'. If the database matches unique User as being the same, do not allow the alias to post to another alais owned by that unique user ID. I am assuming that there is a unique user identifier that is not part of Key of the Alias table.
There are many ways to do this, but let me suggest one thing, write the code, to check without any new db changes, if possible.
'-)
If the check causes any lag time in the post to be posted its likely worth it, number 1, and if so, adding a couple of fields to the table as "Dual Alias" Y/N, and Alternate Alias, would speed it up.
pysdo-code:
Check if flag is yes,
if no, post
if yes match on secondary alias
if false then post
if true send error message.
SI Bob has anyone mentioned the problem of having( " ) [the quote symbol] and ( ' ) be turned into question marks when copied out of Word to the text box.
wolff
Wolff's first rule of Production DB moves:
"In a Production Database, what should have never been connected and dependant on the new code, always is, and your test plan did not anticipate it" |
