example db

[Ruslan Zasukhin]

On 11/2/08 9:21 AM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com> wrote:

> Hello Jon,
> 
> Saturday, November 1, 2008, 11:29:59 PM, you wrote:
> 
>> Hi Ruslan, here's the db that didn't work with b7. Even simple
> 
>> left(allfield, #)=x
> 
>> searches had problems.
> 
>> FYI, when I returned to the 4.0.2 beta, I had to rebuild my database
>> to get it to work (something was screwed up -- the index? -- by b7).
> 
>> Jon
> 
> Firstly - your query
> 
> SELECT
>         
> hit,uniqueID,type,varCharField,rating,dateModified,authors,authorsStyle,title,
> titleStyle,editors,
>         
> editorsStyle,journal,journalStyle,volume,volumeStyle,pages,pagesStyle,thedate,
> thedateStyle,publisher,
>         
> publisherStyle,location,locationStyle,url,urlStyle,title2,title2Style,user1,us
> er1Style,user2,user2Style,
>         
> abstract,abstractStyle,keywords,keywordsStyle,notes,notesStyle,user3,user3Styl
> e,user4,user4Style,user5,
>         
> user6,user7,user8,user9,user10,user11,user12,user13,user14,user15,user16,user1
> 7,user18
> FROM thereferences
> ORDER BY id
> 
> PAGES seems become keyword.
> Anyway the best solution is using "decoration" always.
> 
> SELECT [PAGES] FROM [thereferences] ORDER BY [id]
> 
> 
> Secondly  left(allfield, #)=x
> 
> allfields is a method which vStudio shows as not properly "compiled".
> The reason is the same - PAGES

Aha, this is the reason -- new KEYWORDS, because we have add more SQL
commands into Valentina

So ways to fix are:

* use  ""  or  []  around problematic field

* rename field


-- 
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]