The DataFunctions Object

The DataFunctions object supports a group of methods that perform locale-based data type handling and value range checking on values that you submit to the database or that you pass in an OrderForm object to the order processing pipeline (OPP).

The DataFunctions object supports the following property.

Property Description
Locale Number that specifies the default locale value to be used to format date, time, money, and number values.

The DataFunctions object supports the following methods.

Method Description
CleanString Processes a string. This processing can include stripping out white spaces, modifying the case of the string, and validating that the length of the string falls within a specified range.
ConvertDateString Converts a string representation of the date to a Date Variant, based on the specified locale.
ConvertDateTimeString Converts a string representation of the date and time to a Date Variant, based on the specified locale.
ConvertFloatString Converts a string representation of a floating-point number to a Double Variant, based on the specified locale.
ConvertMoneyStringToNumber Converts a string representation of a monetary value to a Long Variant, based on the specified locale.
ConvertNumberString Converts a string representation of a number to an Integer Variant, based on the specified locale.
ConvertTimeString Converts a string expression of a time value to a Date Variant, based on the specified locale.
Date Returns a string representation of the specified Date Variant, based on the specified locale.
DateTime Returns a string representation of the specified Date Variant, based on the specified locale.
Float Returns a string representation of a floating-point number, based on the specified locale.
Money Returns a formatted currency string, based on the specified locale.
Number Returns a string representation of a number based on the specified locale.
Time Returns a string representation of the specified Date Variant, based on the specified locale.
ValidateDateTime Checks whether a string contains a valid date and/or time, and optionally checks against a specified range.
ValidateFloat Checks whether a string contains a valid floating-point number, and optionally checks the value of the number against a specified range.
ValidateNumber Checks whether a string contains a valid number, and optionally checks the value of the number against a specified range.

Related Topics


© 1997-1998 Microsoft Corporation. All rights reserved.