This section describes limitations specific to Unifinity Studio.
unavailable characters
The following control codes are not available within Unifinity Studio.
abbreviation |
Name/Meaning |
Unicode code point |
---|---|---|
SOH |
header start |
U+2401 |
STX |
STX |
U+2402 |
ETX |
end of text |
U+2403 |
EOT |
EOT |
U+2404 |
ENQ |
inquiry |
U+2405 |
ACK |
ACK |
U+2406 |
BEL |
Sounds a warning tone |
U+2407 |
BS |
(a) letter backward |
U+2408 |
VT |
vertical tabulation |
U+240B |
FF |
form feed |
U+240C |
SO |
Shift out / call G1 to ISO2022:GL |
U+240E |
International System of Units |
Shift in / call G0 to ISO2022:GL |
U+240F |
DLE |
Data link extension (start of binary communication) |
U+2410 |
DC1 |
Device control 1 (XON) |
U+2411 |
DC2 |
Device Control 2 |
U+2412 |
DC3 |
Device control 3 (XOFF) |
U+2413 |
DC4 |
Device Control 4 |
U+2414 |
NAK |
NAK |
U+2415 |
SYN |
same period |
U+2416 |
ETB |
end of transmission block |
U+2417 |
CAN |
cancel |
U+2418 |
EM |
end of storage medium |
U+2419 |
sub |
Character replacement/end-of-file |
U+241A |
ESC |
Escape sequence start |
U+241B |
FS |
file delimiter |
U+241C |
GS |
group delimitation |
U+241D |
RS |
record break |
U+241E |
US |
unit separation |
U+241F |
Screen Design Limitations
Handwritten view may cause layout corruption when rotating the screen. Therefore, screen rotation is not supported.
Limitations of DB design
SQLite reserved words numbered 1-124 below cannot be used in physical data names and physical item names. If a reserved word must be used as an item name, enclose it in backquotes (`).
number |
reserved word |
number |
reserved word |
number |
reserved word |
||
---|---|---|---|---|---|---|---|
1 |
ABORT |
43 |
ESCAPE |
85 |
ORDER |
||
2 |
ACTION |
44 |
EXCEPT |
86 |
OUTER |
||
3 |
ADD |
45 |
EXCLUSIVE |
87 |
PLAN |
||
4 |
AFTER |
46 |
EXISTS |
88 |
PRAGMA |
||
5 |
all |
47 |
EXPLAIN |
89 |
PRIMARY |
||
6 |
ALTER |
48 |
FAIL |
90 |
QUERY |
||
7 |
ANALYZE |
49 |
FOR |
91 |
RAISE |
||
8 |
AND |
50 |
FOREIGN |
92 |
RECURSIVE |
||
9 |
AS |
51 |
FROM |
93 |
REFERENCES. |
||
10 |
ASC |
52 |
FULL |
94 |
REGEXP |
||
11 |
ATTACH |
53 |
GLOB |
95 |
REINDEX |
||
12 |
AUTOINCREMENT |
54 |
GROUP |
96 |
RELEASE |
||
13 |
BEFORE |
55 |
HAVING |
97 |
RENAME |
||
14 |
BEGIN |
56 |
IF |
98 |
REPLACE |
||
15 |
BETWEEN |
57 |
IGNORE |
99 |
RESTRICT |
||
16 |
BY |
58 |
IMMEDIATE |
100 |
RIGHT |
||
17 |
CASCADE |
59 |
IN |
101 |
ROLLBACK |
||
18 |
CASE |
60 |
INDEX |
102 |
ROW |
||
19 |
CAST |
61 |
INDEXED |
103 |
SAVEPOINT |
||
20 |
CHECK |
62 |
INITIALLY |
104 |
SELECT |
||
21 |
COLLATE |
63 |
INNER |
105 |
SET |
||
22 |
COLUMN |
64 |
INSERT |
106 |
table |
||
23 |
COMMIT |
65 |
INSTEAD |
107 |
TEMP |
||
24 |
CONFLICT |
66 |
INTERSECT |
108 |
TEMPORARY |
||
25 |
CONSTRAINT |
67 |
INTO |
109 |
THEN |
||
26 |
CREATE |
68 |
IS |
110 |
TO |
||
27 |
CROSS |
69 |
ISNULL |
111 |
TRANSACTION |
||
28 |
CURRENT_DATE |
70 |
JOIN |
112 |
TRIGGER |
||
29 |
CURRENT_TIME |
71 |
key |
113 |
union |
||
30 |
CURRENT_TIMESTAMP |
72 |
LEFT |
114 |
UNIQUE |
||
31 |
DATABASE |
73 |
LIKE |
115 |
UPDATE. |
||
32 |
DEFAULT |
74 |
LIMIT |
116 |
USING |
||
33 |
DEFERRABLE |
75 |
MATCH |
117 |
VACUUM |
||
34 |
DEFERRED. |
76 |
NATURAL |
118 |
VALUES |
||
35 |
DELETE |
77 |
NO |
119 |
VIEW |
||
36 |
DESC |
78 |
NOT |
120 |
VIRTUAL |
||
37 |
DETACH |
79 |
NOTNULL |
121 |
WHEN |
||
38 |
DISTINCT |
80 |
NULL |
122 |
WHERE |
||
39 |
DROP |
81 |
OF |
123 |
WITH |
||
40 |
EACH |
82 |
OFFSET |
124 |
WITHOUT |
||
41 |
ELSE. |
83 |
ON |
|
|
||
42 |
END |
84 |
OR |
|
|