[VSDK] DELETE FROM crash

[Arthur Clemens]

On Dec 6, 2003, at 00:42, Arthur Clemens wrote:

>>
>> I found out I have an additional space at the end of the DELETE query 
>> string:
>>
>> NSString *query = [NSString stringWithFormat:@
>>         "DELETE FROM %@ "
>>         "WHERE parent = %i ", [self fieldId], parentId];
>>
>> Apparently Valentina crashes on this.
>
> This is still not the only solution, as the current beta framework of 
> 1 Dec still crashes with DELETE.
>
> But this seems to be a problem on my side: somehow the references 
> between parent and child table where lost using one way of adding 
> records.
> So I tried to do:
> DELETE FROM slovene_word WHERE parent = 1
>
> while the parent record did not exist.

I am being thrown from left to right.
Tested the syntax in ViSQL and gives no problems with this.

And the public Framework does not hang, it *is* the beta that gives the 
problem.

Arthur