Caché Class Definition Reference
SqlCategory
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Specifies the type to use for calculations in SQL. Applies only to data type classes.
Usage
To specify the type to use for calculations in SQL, use the following syntax:
Class MyApp.MyString [ ClassType = DataType, SQLCategory = STRING ] 
{
//class members
}
Where sqlcategory is one of the following:
Details
This keyword specifies the type to use for this class in SQL calculations.
Every data type class must specify an SQL category.
When creating a new data type class, use the SQL category value that most closely matches the data type you are creating, or, better still, subclass an existing data type class and inherit its SQL category.
Effect on Subclasses
This keyword is inherited from the primary superclass. The subclass can override the value of the keyword.
Default
The default SQL category is STRING.
See Also