Page 1 of 1
Unable to use the word TYPE in statement
Posted: Tue May 19, 2009 12:31 am
by jjdynamite
I noticed that when you use the work TYPE in a SELECT statment or any other. PrimalSQL returns an error stating unexpected token TYPE at line XX, pos XX. This is an actual field in the database and cannot be changed. The query works in all products except for PrimalSQL. Is there a way around this? Is this already set to be fixed in a later release? BTW, I am connecting to an Oracle database.
Unable to use the word TYPE in statement
Posted: Tue May 19, 2009 1:37 am
by davidc
We are looking into this issue.
In the mean time you should be able to open a "SQL Document" and run the query from there. It will bypass the query builder's validation.
David
Unable to use the word TYPE in statement
Posted: Fri May 22, 2009 1:42 am
by davidc
I looked into this issue and since this is a Oracle keyword you will need to place it in quotes and qualify the tablename.
For example:
tablename."TYPE"
Daviddavidc2009-05-22 08:44:17