Crash on AddRecord

[Francois Van Lerberghe]

The function LOCATE() seems to be the culprit here. Replacing it with a
bunch of IF() solve my problem : no more crash.
I hope that workaround will not decrease too much the speed...

Ruslan, is there another workaround more efficient ?

Additional info that could be relevant :
1) Constructor of Category field is :
    cat = new VString(  "Categorie",1)

2) In field Category, some records have empty value (= ''). But these
records don't seem to be concerned by the query. Could it be the problem ?
All other records have value in "ASEDPTO".

François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
Belgique


le 20/04/12 23:25, Francois Van Lerberghe <fvanlerberghe at freegates.be> a
écrit :

> Indeed, the table in witch I want to insert the record have one method field
> that use LOCATE() function :
>   LOCATE(Category,'ASEDPTO')
> 
> This field is created like this (class way) :
>   sortedCat = new VByte("Category order",
>                         EVFLag.fNone,
>                         "LOCATE(Category,'ASEDPTO')" )
> 
> The field ³Category² is included in the cursor, but not the method field
> "Category order" that use it.
> I haven¹t any method field in the cursor.