
- 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
Thefollowingdatatypesareavailableforfields:
l AorC-alphanumericfield
l N-numberinsignaturewithafloatingcomma
l S-integersinrange-32768to32767
l I-longintegers.Paradoxlongintegerfieldsare32-bitsignedintegersthatcontain
wholenumbers(non-fractional)withcompleteaccuracyintherange-2147483648to
2147483647(plusorminus2tothe31
st
power).Longintegerfieldsrequiremorespace
tostorethanshortfields.
l L-logicalvalueTRUE,FALSE
l D-date
l T-time
l @-timestamp
Defining Indexes
Todefineanindexinthedatabasetable,dothefollowing:
Note:
Indexesarenotavailablefortextdatabase(.TXT,.CSV),butonlyforrealdatabases(MSAccess,
Paradox,dBase).
1. Openyourdatabasetable.
2. SelectthecommandRestructureintheOptionsmenu.
Note:
Youcanalsoclickonthe iconinthetoolbox.
3. GototheIndexestab.
4. ClickontheAddbutton.
5. ClickonthefieldintheFields in tableboxforwhichyouwanttodefinetheindex.
6.
Clickonthe buttontomovethefieldtotheIndexed fieldsbox.
7. ClickontheSavebutton.
8. Selectthenamefortheindex.Youcanleavethedefaultsetting.
9. ClickontheOKbutton.
10. ClickontheOKbuttontoclosetheIndexestab.
Notes for Paradox tables:
Comentários a estes Manuais