Data type is not supported with Description field

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
Locked
User avatar
jjdynamite
Posts: 41
Joined: Tue May 19, 2009 12:31 am

Data type is not supported with Description field

Post by jjdynamite »

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.

User avatar
Alexander Riedel
Posts: 7410
Joined: Tue May 29, 2007 4:43 pm

Data type is not supported with Description field

Post by Alexander Riedel »

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.
Alexander Riedel
SAPIEN Technologies, Inc.

User avatar
jjdynamite
Posts: 41
Joined: Tue May 19, 2009 12:31 am

Data type is not supported with Description field

Post by jjdynamite »

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

User avatar
davidc
Posts: 5913
Joined: Thu Aug 18, 2011 4:56 am

Data type is not supported with Description field

Post by davidc »

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)
David
SAPIEN Technologies, Inc.

Locked