Toad World® Forums

dispatch datatype in Scripting


#1

I apologize if this is a silly question, but I’m writing a script to walk through NotNull Attributes and then setting a DefaultConstraintName and DefaultValue based on the datatype. According to the documentation, however, DataType is a dispatch datatype. How would I handle this?


#2

Hi,

yes, DataType is dispatch. See PERDataType class in the Reference for details about the object. If you wish to simply check data type name, use Attribute.DataType.Name. Of course, you can also use IDs. All data type ID numbers are also in the Reference, see topic Data Types | Data Types (last topic in the Reference).

Regards,

Vaclav


#3

Perfect! Thank you.