SQL quirkiness

[Ruslan Zasukhin]

On 9/3/08 6:43 PM, "Steve Albin" <steve at steve-albin.com> wrote:

>>> I only crash when trying to select records where the field begins
>>> with "s".
>>> 
>>> I've reindexed the DB with no success.  This same SQL has worked in
>>> the past - this is a part of my app that I have not changed when
>>> upgrading to V4RB 3.52.
>>> 
>>> Diagnose tells me everything is ok with the DB.
>>> 
>>> Any ideas on what I can look at?
>> 
>> 
>> depending on the amount of data try to export and check if there are
>> some "funny" invisible chars inside of a field. Sometimes when my
>> users copy content from html-pages, they tend to paste more than what
>> is good for the app. Before applying some filters in my app I
>> experienced these issues from time to time (and of course in much
>> older versions then the current one).
>> 
>> Try to nail down the issue, so iterate over all the
>> 
>>   like 'sa%'
>>   like 'sb%'
>> 
>> ....
>> 
>> until you find the record that causes the issue.
> 
> Thanks for the suggestion.  I did try this with no luck.  Then, I realized
> that I should first try the same database in my current prod app using V4RB
> 3.01.  No problems there, so I don't think it is a case of bad data.

Hi Steve,

Then please do next

1) you can test latest beta (may be Vstudio only)

    http://www.valentina-db.com/download/beta/


2) report into Mantis with way to reproduce it.


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