SQL quirkiness

[Ernesto Giannotta]

Hi list,

sorry for the huge delay but I've experienced a similar situation just  
yesterday

I was looking for some field data beginning with "strange" (yep! the  
appropriate word :-) and the app kept crashing and no diagnose or  
reindex or clone did help (the crash log reported something wrong on  
dispose string or some like that, sorry I trashed it)

After I added a record to the searched table the problem went away...

Sorry, I can't be more helpful than this


Cool Runnings,
Erne.

On 04-set-08, at 04:49, Steve Albin wrote:

>
> On Wednesday, September 3, 2008 sunshine at public.kherson.ua (Ruslan  
> Zasukhin) wrote:
>
>> 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/
>
> The problem still exists with version 3.6.
>>
>>
>> 2) report into Mantis with way to reproduce it.
>
> I've already sent my database to Ivan.  I will report to Mantis  
> tomorrow when I have time.  But, I expect I will drop back to V4RB  
> 3.01 since that version worked for me and I do not need any new  
> features after that.
>
> Steve
>
> -- 
> Steve Albin - Montclair, NJ
> http://www.jazzdiscography.com/
> http://www.steve-albin.com/
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina