Skip to main content

SqlCategory

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:

  • DATE

  • DOUBLE

  • FMDATE

  • FMTIMESTAMP

  • INTEGER

  • MVDATE

  • NAME

  • NUMERIC

  • STRING (default)

  • TIME

  • TIMESTAMP

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

FeedbackOpens in a new tab