Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
There are several words and characters that should be avoided in Phocas, e.g., when naming measures etc. This is because in software development, these words or characters typically have a specific meaning that may affect results.
Reserved words in measures
Word | Reason |
|---|---|
Count | Count is a reserved word as when used as a scalar it depicts the count of rows in the transactions. |
Trans | Trans is reserved for internal usage. |
Unsupported characters
Character | Name | Reason |
|---|---|---|
\ | Backslash | Backslash is a common programming character. |
; | Semicolon | The semi-colon is reserved as when used in searches it defines multiples. For example, in a equal to search, it splits codes. |
* | Asterisk | The asterisk is reserved for wildcard searches, and shouldn't be used in raw data. |
Reserved characters and words
and charactersin Designer
Unsupported characters
(theseThese should not be used in names of measures, streams, properties or dimensions
)Character:
\
@
!
?
~
|
*
Reserved words
Word
Code
Date
Trial Balance
For streams only(for streams only)
Cash Flow
For(for streams only)
Reserved characters in Sync
Character | Name | Reason |
|---|---|---|
. | Period or full stop/full point |
Use of "." (period character) in a file name can cause an application (i.e. like Sync) to unexpectedly recognize a file with an unsupported file type suffix. |
|
But a file named "example.filename.txt" could result in an unsupported file type error |
, if the application (such as Sync) does not support a file type of ".filename" |
. | ||
_ | Underscore | Reserved for source names but not for data items. |