3.5b11 SQL exception

[Barry G. Sumpter]

How long has this been a feature?

I've just spent the last two months renaming reserved words like:
User, Level, Logon, etc




-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Thursday, 29 November 2007 8:07 AM
To: valentina at lists.macserve.net
Subject: Re: 3.5b11 SQL exception

On 28/11/07 9:37 PM, "jda" <jda at his.com> wrote:

>>>  I'm getting an SQL exception thrown on this query:
>>> 
>>>  select
>>>  id,hit,uniqueID,varCharField,authors,thedate,title,editors,keywords
>>>  from thereferences where id=1
>>> 
>>>  complaining that
>>> 
>>>  unexpected token: keywords
>>> 
>>>  Why? Is "keywords" reserved now?
>> 
>> Yes.
>> 
>> We have add new SQL commands:
>> 
>>     SHOW KEYWORDS
>>     SHOW IDENTS
>> 
>> Btw, you can all use now SHOW KEYWORDS to see easy list of keywords from
>> Parser.,
>> 
> 
> Argh. I've used this field name forever. Can you change this? To
> something that won't conflict with anyone? Like vkeywords?


Moment.

Issue with keywords can be easy resolved.
Just wrap it by DOUBLE QUOTES in your query

select
 id,hit,uniqueID,varCharField,authors,thedate,title,editors,"keywords"
from thereferences where id=1


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina