[ANN] Valentina 3.0 b1 uploaded.

[Serge]

Hello Kim,


> also, I have a query which runs fine on VStudio 2.5.9 but fails on  
> VStudio v3.
>
> SELECT stories.recID, stories.storyname,  authors.a_full_name,   
> publications.p_name, sections.s_name, stories.depth,  
> stories.heading, stories.heading_tagged, stories.sub_heading,  
> stories.sub_heading_tagged, stories.body, stories.body_tagged,  
> authors.recID, stories.created, stories.page_num,  stories.comment,  
> stories.status, stories.week_number, stories.byline_boolean,  
> stories.modified, stories.export_name, stories.web_published,  
> stories.graphics, stories.sub_heading_tagged,  
> stories.heading_tagged, stories.body_tagged, stories.caption1,  
> stories.caption2, stories.caption3, stories.caption1_tagged,  
> stories.caption2_tagged, stories.caption3_tagged, stories.archived,  
> publications.p_name, sections.s_name, editions.e_name,  
> authors.a_full_name FROM stories
> Left JOIN publications ON stories.publication_ptr = publications.RecID
> Left JOIN sections ON stories.section_ptr = sections.RecID
> Left JOIN editions ON stories.edition_ptr = editions.RecID
> Left JOIN authors ON stories.author_ptr = authors.RecID
> where stories.archived = 'false'  and a_full_name = 'Mandy Wyer'  
> order by stories.storyname
>
> returns 1 row in Vstudio 2 (correct) whilst VStudio v3 returns:
>
> 17:18:18: Error: line 1:302: unexpected token: comment
> 17:18:18: Error: Kernel error: 0x71000
> 17:18:18: Error: line 1:302: unexpected token: comment

"comment" is a keyword in v3.
http://www.valentina-db.com/dokuwiki/doku.php? 
id=paradigma:public:en:documentation:vsql:reference:sqlkeywords#c

you need rename this field
or use " " or [ ] for this name

select stories."comment" from stories


Serge.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://edison.macserve.net/pipermail/valentina-beta/attachments/20070425/514ff86a/attachment.html