Data type is not supported with Description field

Support for all customers who have purchased a PrimalSQL product license. This forum does not offer a response time guarantee.
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE 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.
User avatar
jjdynamite
Posts: 41
Joined: Tue May 19, 2009 12:31 am

Data type is not supported with Description field

Post by jjdynamite » Wed Aug 25, 2010 10:33 pm

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: 6685
Joined: Tue May 29, 2007 4:43 pm

Data type is not supported with Description field

Post by Alexander Riedel » Thu Aug 26, 2010 1:33 am

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 » Thu Aug 26, 2010 3:09 am

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

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

Data type is not supported with Description field

Post by davidc » Thu Aug 26, 2010 4:03 am

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.