3.5b11 SQL exception

[Ruslan Zasukhin]

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]