1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
<H2>2.4. Differences between Kexi and other applications</H2>
<H3>2.4.1. Terminology used in Kexi and in other database applications</H3>
<p>
English terms are bracketed.
</p>
<p>
<table border="1" cellspacing="0" cellpadding="5">
<tr align="left">
<th>Kexi</th> <th>MS Access</th> <th>dBase i FoxPro</th> <th>Paradox</th>
</tr>
<tr>
<td>Database (<i>Database</i>)</td> <td>Database</td> <td>Catalog (<i>Catalog</i>)</td> <td>Directory of Related files (<i>Directory of Related files</i>)</td>
</tr>
<tr>
<td>Table (<i>Table</i>)</td> <td>Table</td> <td>Database file<br>(<i>Database file</i>)</td> <td>Table</td>
</tr>
<tr>
<td>Datasheet (<i>Datasheet</i>)</td> <td>Datasheet</td> <td><i>BROWSE</i> Command</td> <td><i>View</i> Command</td>
</tr>
<tr>
<td>Table design (<i>Table design</i>)</td> <td>Table design</td> <td><i>MODIFY STRUCTURE</i> Command</td> <td><i>Modify Restructure</i> Command</td>
</tr>
<tr>
<td>Primary key<br>(<i>Primary key</i>)</td> <td>Primary key</td> <td>Unique Index</td> <td>Key field</td>
</tr>
<tr>
<td>Index (<i>Index</i>)</td> <td>Index</td> <td><i>Index</i></td> <td><i>Tools QuerySpeed</i></td>
</tr>
<tr>
<td>Validation rule</td> <td>Validation rule</td> <td><i>PICTURE/VALID</i> Clause</td> <td><i>ValChecks</i></td>
</tr>
<tr>
<td>Query (<i>Query</i>)</td> <td>Query</td> <td><i>Query, TQBE, View</i></td> <td><i>Query</i></td>
</tr>
<tr>
<td>Form (<i>Form</i>)</td> <td>Form</td> <td>Screen</td> <td><i>Forms</i></td>
</tr>
<tr>
<td>Subform (<i>Subform</i>)</td> <td>Subform</td> <td><i>Multiple File Screen</i></td> <td><i>Multiple-record selection</i></td>
</tr>
<tr>
<td>"Open a form" Command<br>(<i>Open a form</i></td> <td><i>Open a form</i> Command</td> <td><i>SET FORMAT TO, EDIT</i> Command</td> <td><i>Image PickForm</i></td>
</tr>
<tr>
<td>Find command<br>(<i>Find command</i>)</td> <td>Find command</td> <td><i>LOCATE AND SEEK</i> Command</td> <td><i>Zoom</i></td>
</tr>
<tr>
<td>List box, combo box</td> <td>List box, combo box</td> <td>Pick list</td> <td>Lookup</td>
</tr>
<tr>
<td>Macro (<I>Macro</I>)</td> <td>Macro</td> <td>-</td> <td>-</td>
</tr>
<tr>
<td>Script (<I>Script</I>)</td> <td>Script</td> <td>Program file</td> <td>Script</td>
</tr>
</table>
</p>
<p>
As you can see from the table above the terminology used in Kexi is close to the one used in MS Access application.
</p>
<H3>2.4.2. Basic data types used in Kexi and in other database applications</H3>
<p>
<table border="1" cellspacing="0" cellpadding="5">
<tr align="left">
<th>Kexi</th> <th>MS Access</th> <th>dBase i FoxPro</th> <th>Paradox</th>
</tr>
<tr>
<td>Text (<I>Text</I>)</td> <td>Text</td> <td>Character</td> <td><I>Alphanumeric</I></td>
</tr>
<tr>
<td>Long text (<I>Long text</I>)</td> <td>Memo</td> <td><I>Memo</I></td> <td><I>Memo</I></td>
</tr>
<tr>
<td>Date, Time (<i>Date</i>, <i>Time</i>)</td> <td>Date, Time</td> <td><I>Date</I></td> <td><I>DateTime</I></td>
</tr>
<tr>
<td>Object (<I>Object</I>)</td> <td>OLE Object (<I>OLE Object</I>)</td> <td><I>General</I></td> <td><I>OLE, Graphical, Binary</I></td>
</tr>
<tr>
<td>Yes/No (<I>Yes/No</I>)</td> <td>Yes/No</td> <td>Logical</td> <td><I>Logical</I></td>
</tr>
<tr>
<td>Integer number (<I>Integer number</I>)</td> <td>Number (<I>Integer</I>)</td> <td><I>Numeric</I></td> <td><I>Integer</I></td>
</tr>
<tr>
<tr>
<td>Big Integer number (<I>Big integer number</I>)</td> <td>Liczba ca³kowita d³uga (<I>Long integer</I>)</td> <td><I>Numeric</I></td> <td><I>Long Integer</I></td>
</tr>
<td>Floating-point number:<br>Single/Double precision<br>(<I>Floating-point number</I>)</td> <td>Single/Double precision number<br>(<I>Single/Double precision number</I>)</td> <td><I>Float</I></td> <td><I>Number</I></td>
</tr>
</table>
</p>
<!--
Szczegó³owy wykaz typów danych obs³ugiwanych przez Kexi, wraz z zakresami, znajduje siê w dodatku ###.
--terminologia (tabelka roznic Kexi/MSA/dBase,FoxPro/Paradox) [str.18]
--ró¿nice w sposobie u¿ywania
¶rodowisko pracy z Kexi (GUI, CLI)
-->
|
