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.
Data type is not supported with Description field
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.
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.
- jjdynamite
- Posts: 41
- Last visit: Tue May 06, 2014 1:45 pm
- Alexander Riedel
- Posts: 8479
- Last visit: Thu Mar 28, 2024 9:29 am
- Been upvoted: 37 times
Data type is not supported with Description field
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.
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.
SAPIEN Technologies, Inc.
- jjdynamite
- Posts: 41
- Last visit: Tue May 06, 2014 1:45 pm
Data type is not supported with Description field
This time it is with a field named DESCRIPTION not TIMESTAMP.
Data type is not supported with Description field
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)
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.
SAPIEN Technologies, Inc.