Quicklabel NiceData User Manual download pdf (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

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:

1 2 3 4 5 6 7 8 9 10 11 12

No comments

Quicklabel NiceData User Manual Page 7