Wasp Barcode Inventory Control - Manual (Page 290)

InventoryControl Printable Help
16.4.7 Data Type Definitions:
 The maximum sizes permitted by the data types defined below are greater than the field lengths
used in the database. Refer to the sizes given in the tables above to avoid truncation when using
Import.
 Any field defined in the tables above that has a length of only one character expects one of the
following values (case insensitive):
o For False: "0", "F", "False", "No", "N"
o For True: "1", "T", "True", "Yes", "Y"
char Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
datetime Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of
three-hundredths of a second, or 3.33 milliseconds.
Valid Alphabetic datetime Formats for Microsoft® SQL Server™ 2000 date data
(characters enclosed in brackets are optional):
Apr[il] [15][,] 1996 -- (mdy)
Apr[il] 15[,] [19]96 -- (mdy)
Apr[il] 1996 [15] -- (mdy)
[15] Apr[il][,] 1996 -- (dmy)
15 Apr[il][,][19]96 -- (dmy)
15 [19]96 apr[il] -- (dmy)
[15] 1996 apr[il] -- (dmy)
1996 APR[IL] [15] -- (ymd)
1996 [15] APR[IL] -- (ymd)
Suggestion: To avoid ambiguity, use four-digit years.
If the day is missing, the first day of the month is supplied.
Any of the alphabetic 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 Long Date format in effect on your PC. This can be found at:
Start > Settings > Control Panel > Regional Options > Date tab > Long Date
format
275