The SQL Schema API tries very hard not to allow unhandled exceptions to be thrown back to your applications, opting instead to use our Common Exceptions Interface. You ((as a developer) should find it difficult (without TRYING) to see an unhandled exception. If you DO see an unhandled exception (without TRYING) thrown back to your application(s) please contact us and let us know.

 

However, as with everything, there are some instances where we purposely throw a system exception back to your application(s). They are:

 

Your SQLSchemaAPIKey object IsRunnable property MUST be TRUE for almost all schema related activities. If it is not most "factory" calls to the object for new objects will return NULL (Nothing for VB programmers). While this in itself isn't an unhandled exception, the unexpected return value might cause you problems.

Trying to call any IMPORT or TRAINING operation where you try to pass AUTOFIX as TRUE when the AllowAPIToAlterSchema property of your key object is FALSE.

 

© 2015 HermeTech International
(a Division of TransWorld Scribes)