3.5b11 SQL exception

[Ruslan Zasukhin]

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

>>>  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.,
>> 
> 
> Not only do I have to revert to an early build of Valentina because
> of this unilateral decision, I find that after running my app with
> 3.5b11 it modified my databases, and not trying to open them with
> 3.5b8 won't work. Right now I'm stuck at this error after opening a
> db with 3.5b8:

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]