wholesale jewelry pricelist template What are the data types in VFP?

wholesale fashion and jewelry 1. Character type:
This includes all letters, numbers (as text) and punctuation symbols, or Chinese characters. This data type is the highest utilization rate, such as name, address, phone number, device number, device name, etc. can be defined as character types. A character field can accommodate up to 254 letters, numbers, spaces or other symbols. Because Chinese characters occupy 2 bytes, the maximum capacity of Chinese characters is 127.
2, currency type:
This type is mainly used to store data -related data. Such as purchase price, salary, and so on. In VFP, currency types can be used to replace the digital types used in currency value. In the table, this type is stored in 8 bytes, from -.5808 to .5807.
The currency type in the expression should add the "$" symbol before value, such as "$ 50.33". The value of the currency type in VFP is only accurate to the last four of the decimal point. It can also calculate various values ​​like numerical data.
3, numerical type:
This data type is used to store various fields represented by numbers. This data type allows users to perform various mathematical operations, such as the number of goods, the number of orders, and so on. In the table, it is stored with 1 to 20 bytes, and the range is from-. 19 to . 20.
The maximum number of field fields is 20 bits, including decimal points and symbol bits. Therefore, the length of 99999, 9.999 and -9.99 are all 5. For numerical data, the maximum value of its "decimal digits" is smaller than the "digits" set by setting, because the integer 0 of less than 1 can be displayed without displaying it without displaying it.
4, floating point type:
The data types set up by VFP for compatible purposes, it is actually the same as the Numeric type.
5, date type:
This data type is used to store the input date, including the year, month, and day. Actual storage A date field occupies 8 characters length. When input or display, the format user can be set to the United States (month/day/year), European method (day/month/year), ANSI method (year/month/day).
6, date time type:
This data is used to accurately represent specific moments, which includes six dates and time and time of "year, month, day, time, minute, second". This type can be used when the time of work is: employee work time, experiment start and end time.
7, dual accuracy type:
This data type is used to store numbers like a numerical type, but this type of data is a dual -precision, so it is used for that kind of required numerical accuracy with high value accuracy. Scenes, such as high -precision experimental data. Double -precision data is stored in 8 bytes in the table. It is different from the NUMERIC type, and the user decides the position of the decimal point when the input value is input.
8, integer:
The type of data type is the value -free value, that is, integer. This data type can be used for occasions that do not require decimal positions such as page numbers and single line numbers. It is stored in the table with 4 bytes. In the table, use an integer than using other numerical types, and its computing speed is higher than other numerical types of data.
9, logic type:
This type of data is used to deal with the answer to only two choices.
10, remarks:
This type of data can be used to store text data that is uncertain in length, which is different from other data types that need to tell the length of the VFP field in advance. Annotation can also accommodate a long summary.
The content of the remote field is not stored in the table file, but in a separate file that is stored in another extension name ".fpt". The file also establishes a remote file called Device.fpt.
11, general type (general):
This data type is actually a special remote field. It is used to store Windows OLE (object connection and embedded) objects, such as images, sounds, etc. These OLE objects are generally created by another application.
12, CHARACTER BINARY:
The type of type is the same as the character type, but when the code page changes, the value cannot be translated. It can be used for user passwords that are stored in different countries in the table.
13, Memo Binary:
This is the same as the blood type, but when the code page changes, the value cannot be translated. It can be used for login scripts used in different countries and so on. rn扩展资料rn常量类型rn1、数值型常量rn用整数、小数、科学计数法表示的灵气称为数值型常量（常数），例如：1234、555.33、 4.5E, etc.
2, character constant
Character constant is a string of characters included in a semi -quotation number, dual quotes or square brackets. The character type is also called the string, which can be composed of text or symbols, including English letters, numbers, spaces, and Chinese characters. The number of characters contained in a string is called the length of the string. The maximum length of the string is 254 bytes. For example: "I love you in China", ‘12345’, [liziwx], etc.
3, date constant
Date -type constant must be included in parentheses, and the international (MM/DD/YY) and China (yy/mm/dd) conversion can be transformed in the command window input (Set Stri to 1 converts international standards into Chinese standards), and STRI TO 0 converts Chinese standards into international standards). The blank date can be expressed as {} or {/}.
4, logic constant
The logical type constant is only two values ​​of logic and logic. (.F.) Or .n. (. N.).
5, currency type constant
The currency type constant heart $ or ￥ or ￥ starts, and automatically performs 4 digits after the four houses and five to the small Lou point. If there is "?" Remove $ or ￥. For example: currency type constant ￥ 123.23445, the calculation result is ￥ 123.2345.
6, symbol constant

The pseudo -compilation instructions #Define define the symbol constant, such as #Define Pi3.1415926. After compiling, VFP will use the specific value of the symbol constant to replace the symbol constant Position in the source code.

wholesale charms for jewelry making uk In VFP, the data types are:
-character C, currency type Y, numerical type N, floating type F, date type D, date time type T, dual -precision type B, integer I, logic type L, remarks remarks Type M, GM G. (Field variables also have binary reminders M, binary characters C)

wholesale jewelry programs Character, numerical type, logic, date type, remarks, general -purpose