Where is the error ?

[Ruslan Zasukhin]

On 9/9/04 9:40 AM, "Thierry Nauze" <huancaya at wanadoo.fr> wrote:

> Hi
> 
> I have this table :
> 
> idA        idB        Nom          autoID
> 1        9        NON 1
> 4        4        OUI 1        ˆ
> 11        19        NON 2
> 291        291        OUI 2        ˆ
> 5        23        NON 3
> 
> where autoID is this method :    Boolean METHOD(idA=idB)
> 
> 
> With Valentina Studio, the SQL-request "select ** from table" give the
> good cursor.
> 
> But "SELECT ** FROM table WHERE autoID = true" (or 1 or yes or on or
> false, etc.) return un empty cursor. Why ?
> 
> 
> 
> On the other hand, if autoID is the method :  Long METHOD(idA-idB), the
> différent SQL-requests give then right cursor :  SELECT ... WHERE
> autoID = 0   (or <>0)
> 
> Why the method with BOOLEAN don't work ?

Sorry, this is not documented trap.

Just there is no any win if to use Boolean Method comparing to BYTE field
method. 

So please use BYTE type instead.



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------