Available data types for fields, Defining indexes – QuickLabel NiceData User Manual
Page 7

- 7 -
Paste from clipboard.
Create a table report.
Change the view to Table/Record.
Open help file.
Restructure the table.
Available Data Types for Fields
The following data types are available for fields:
l
A or C - alphanumeric field
l
N - number in signature with a floating comma
l
S - integers in range -32768 to 32767
l
I - long integers. Paradox long integer fields are 32-bit signed integers that contain
whole numbers (non-fractional) with complete accuracy in the range -2147483648 to
2147483647 (plus or minus 2 to the 31
st
power). Long integer fields require more space
to store than short fields.
l
L - logical value TRUE, FALSE
l
D - date
l
T - time
l
@ - timestamp
Defining Indexes
To define an index in the database table, do the following:
Note:
Indexes are not available for text database (.TXT, .CSV), but only for real databases (MS Access,
Paradox, dBase).
1. Open your database table.
2. Select the command Restructure in the Options menu.
Note:
You can also click on the
icon in the toolbox.
3. Go to the Indexes tab.
4. Click on the Add button.
5. Click on the field in the Fields in table box for which you want to define the index.
6. Click on the
button to move the field to the Indexed fields box.
7. Click on the Save button.
8. Select the name for the index. You can leave the default setting.
9. Click on the OK button.
10. Click on the OK button to close the Indexes tab.
Notes for Paradox tables: