Microsoft KB Archive/66670

{| = Q+E Err Msg: Command Has Been Aborted =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q66670

SUMMARY
If you attempt to add or modify data in a field in a SQL Server table that has had rules applied to it, the &quot;Command Has Been Aborted&quot; error message may be generated if the data entered does not meet the requirements of the rules.

MORE INFORMATION
SQL Server allows rules to be defined for fields in a table. A rule sets up criteria that the data entered in that field must satisfy.

Q+E does not support creating rules and preexisting rules cannot be viewed from Q+E. However, Q+E will verify that the data you enter matches preexisting rules.

The following is an example of a rule that applies from a SQL Server front end that supports adding rules:

CREATE rule pub_idrule

as @pub_id like &quot;99[0-9][0-9]&quot; This example places the restriction on the field pub_id that values entered must start with &quot;99&quot; and contain four digits. &quot;9954&quot;, &quot;9900&quot;, and &quot;9999&quot; (without the quotation marks) would be valid entries. Entering &quot;8056&quot; in the field pub_id from Q+E would cause the &quot;Command Has Been Aborted&quot; error.
 * }