Wasp Barcode Inventory Control - Manual (Page 291)

InventoryControl Printable Help
For example, if your Long Date format, as shown in Regional Options is dddd,
MMMM dd, yyyy (Friday, June 27, 2003), you can use any of the mdy alphabetic
formats shown above, but you can not use any of the dmy or ymd formats.
Valid Numeric datetime Formats for Microsoft® SQL Server™ 2000 (characters
enclosed in brackets are optional):
number separator number separator number [time] [time]
[0]4/15/[19]96 -- (mdy)
[0]4-15-[19]96 -- (mdy)
[0]4.15.[19]96 -- (mdy)
[04]/[19]96/15 -- (myd)
15/[0]4/[19]96 -- (dmy)
15/[19]96/[0]4 -- (dym)
[19]96/15/[0]4 -- (ydm)
[19]96/[04]/15 -- (ymd)
Slash marks (/), hyphens (-), or periods (.) may be used as separators.
Any of the numeric datetime formats shown above may be used -as long as- the
format you select conforms to the year, month and date sequence exhibited by the
Short Date format in effect on your PC. This can be found at:
Start > Settings > Control Panel > Regional Options > Date tab > Short Date
format
For example, if your Short Date format, as shown in Regional Options is M/d/yyyy
(6/27/2003), you can use any of the mdy numeric formats shown above, but you can
not use any of the dmy, ydm, ymd, myd, or dym formats.
decimal Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1.
Precision specifies the maximum total number of decimal digits that can be stored, both to
the left and to the right of the decimal point.
Scale specifies the maximum number of decimal digits that can be stored to the right of the
decimal point.
Size is the number of storage bytes consumed internally - this value should be ignored
when determining whether or not a decimal value will be truncated - use Precision and
276