Sybase InfoMaker 11.5, CD, Win, ENG Specifiche Scaricare il pdf (Pagina 709)

100

101

CHAPTER 24 DataWindow Expression and InfoMaker Functions

Users Guide 687

This expression for a computed field returns “Not a valid age” if age does not

contain a number. The expression checks whether the Integer function returns

0, which means it failed to convert the value:

If (Integer(age) <> 0, age, "Not a valid age")

This expression returns 0:

Integer("3ABC") // 3ABC is not a number

This validation rule checks that the value in the column the user entered is less

than 100:

Integer(GetText()) < 100

This validation rule for the column named age insures that age contains a

string:

Integer(age) <> 0

See also

IsNumber

IsDate

Description Tests whether a string value is a valid date.

Syntax IsDate ( datevalue )

Return value

Boolean. Returns true if datevalue is a valid date and false if it is not.

Examples This expression returns true:

IsDate("Jan 1, 99")

This expression returns false:

IsDate("Jan 32, 2005")

This expression for a computed field returns a day number or 0. If the

date_received column contains a valid date, the expression returns the number

of the day in date_received in the computed field, and otherwise returns 0:

If(IsDate(String(date_received)),

DayNumber(date_received), 0)

Argument Description

datevalue A string whose value you want to test to determine whether it is a

valid date

1 2 ... 704 705 706 707 708 709 710 711 712 713 714 ... 827 828

Commenti su questo manuale

Nessun commento

Sybase InfoMaker 11.5, CD, Win, ENG Specifiche Pagina 709

Commenti su questo manuale