SAPIEN Forums

I am having a serious issue as PrimalSQL will not allow for the field name, description, to be used in a query. I am using the SQL Document mode and keep getting the error. This worked in previous versions of PrimalSQL as a work around when dealing with fields with a field named timestamp but with version 1.1.2 this can no longer be done. Is there another way around this? Can this be corrected again in the next version?
Oracle Database Version: 10g
Client O/S: Windows 7 Enterprise 64-bit
Oracle Client: 11g (32 & 64 bit)

Any help is greatly appreciated as this is extremely urgent.

It is my understanding that "timestamp" is a reserved word and cannot be used as a column name in Oracle databases.
I will verify with the development team, but as far as I know we are just reporting back an error from the Oracle database itself.

This time it is with a field named DESCRIPTION not TIMESTAMP.

Do you recall what previous version in which this query worked? In addition, can you please provide a sample of the query?

Thank you,

David

Attached files /FileUpload/27/b770953fb3d01015c0a2a279d4391e.txt (3 KB) /FileUpload/18/7b505bd5b30b5ae236f7181740e284.txt (33.8 KB) /FileUpload/92/3d934abbae402e49b5c6bf92497221.zip (756.3 KB)