[Xojo] 5.4b8 SQL_Problem

[Karl Grob]

Hi Ruslan

In fact, i had in 2 cases written 'field.name =' instead of 'field.value =' (classes-way) and by this changed the name of the field. This is the explanation, why the SQL-routine worked as long as there is no new instantiation.

So, coming back after instantiating the DB and reopening the file, there is a name conflict (the constructor instantiates with the old field-name). As usual it is quite easy to understand, but only after the show.

I used the SQL command and the program immediately quits. (There is no error, the routine  would catch the exception - and the program itself would anyway go out with a exception).

Best regards
Karl




Am 15.08.2013 um 07:56 schrieb Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>:

> On 8/14/13 4:36 PM, "Karl Grob" <kgrob at mus.ch> wrote:
> 
> Hi Karl,
> 
> * changed during execution of your app ??
> 
> * you can enable V4RB log    to see each command
> 
> * 
> 
> 
> 
>> I found the reason. Somewhere (I have to find it yet!) the name of 2 fields in
>> TBL_Inhalt are changed. Never had anything like that.
>> 
>> Am 14.08.2013 um 15:20 schrieb Karl Grob <kgrob at mus.ch>:
>> 
>>> Clarification: It crashes only in my program, not in Studio.
>>> 
>>> Am 14.08.2013 um 15:17 schrieb Karl Grob <karl.grob at hispeed.ch>:
>>> 
>>>> In Studio the links (hierarchical) work fine, but if I reopen the DB, it
>>>> crashes. Other SQL-Statements do work.
> 
> Even if field is not found, code should check nil to not crash
> 
> 
> 
> 
> -- 
> 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]
> 
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>