At 19:34 -0400 5/23/03, Urb LeJeune wrote:
> I'm trying to extract the enumeration from a field defined as
>
>Action enum('M', 'S', 'H', 'D' ) in a table named FieldInfo.
>
> As I interpret the manual the command
>SELECT * FROM FieldInfo WHERE Action=0
>
> I'm getting an empty set. Can anyone point me in the
>right direction?
Sequential enumeration values are assigned values beginning with 1.
0 represents '', which is used for illegal values. If all
values in the column are one of the four values you show, an
empty set would be the expected result.
What are you trying to accomplish?
>
>Urb
--
Paul DuBois
http://www.kitebird.com/
sql, query
