Created On: 09 October 2010
Problem:
I am unable to access an AcuXDBC table named with the reserved word, and there is no way to change the name of the VISION file because it is part of the main application.
It always returns “ERROR: (pos: 15 '.... syntax error”.
It always returns “ERROR: (pos: 15 '.... syntax error”.
Resolution:
It is possible to work with files named with reserved words defining file aliases using the following syntax:
For example let’s say that the VISION file is called GROUP, which is an AcuXDBC reserved word.
addfile xfdfilename[#[tablename][#filename]], where:
xfdfile is GROUP
tablename must be something different, like GROUP1
and filename is also GROUP.
User will use GROUP1 table name in the queries:
SELECT * FROM GROUP1;
For example let’s say that the VISION file is called GROUP, which is an AcuXDBC reserved word.
addfile xfdfilename[#[tablename][#filename]], where:
xfdfile is GROUP
tablename must be something different, like GROUP1
and filename is also GROUP.
User will use GROUP1 table name in the queries:
SELECT * FROM GROUP1;
Support
Documentation
Learning Services
Partner Programs
