To store non-decimal numeric values when performance and table storage limitations are especially important, use the Integer field type. To generate values, such ID numbers, use Integer (Autoinc) that automatically increments the value.
In tables, the Integer field type is stored as a 4-byte binary value. As a result, it requires less memory than other Numeric data types. As a binary value, it requires no ASCII
For specifications about the Integer and Integer (Autoinc) field types, see Visual FoxPro Data and Field Types.
See Also
Tasks
How to: Choose Data TypesHow to: Set Autoincrementing Field Values
Reference
CREATE TABLE - SQL CommandNumeric Operators
ALTER TABLE - SQL Command
CREATE TABLE - SQL Command
CREATE CURSOR - SQL Command
Concepts
Creating Numeric ExpressionsAutoincrementing Field Values in Tables
Microsoft Visual FoxPro 9 SP2 Help file, VFPX Edition v1.08