Where is the error ?

Thierry Nauze huancaya at wanadoo.fr
Thu Sep 9 10:40:28 CDT 2004


Hi

I have this table :

idA		idB		Nom  		autoID
1		9		NON 1
4		4		OUI 1		=C3
11		19		NON 2
291		291		OUI 2		=C3
5		23		NON 3

where autoID is this method :    Boolean METHOD(idA=3DidB)


With Valentina Studio, the SQL-request "select ** from table=00" give =
the=20
good cursor.

But "SELECT ** FROM table WHERE autoID =3D true" (or 1 or yes or on or=20=

false, etc.) return un empty cursor. Why ?



On the other hand, if autoID is the method :  Long METHOD(idA-idB), the=20=

diff=8Erent SQL-requests give then right cursor :  SELECT ... WHERE =20
autoID =3D 0   (or <>0)

Why the method with BOOLEAN don't work ?

ViSQL give the same cursors.

Regards,

--
Thierry Nauze			Saint-Denis de la R=8Eunion



More information about the Valentina mailing list