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