Can anybody tell me how to compare the values for the Enumerated values like tisfc001.osta = 8 in SQL. if we directly give the variables like
sql = "where tisfc001.osta = "& tisfc001.osta
it shows error illegal type string = enumerated

Thanks in advance,
Thamarai

Hi,
You can use the standard Baan function etol().

Here it goes:

Syntax

long etol( domain domain_value )

Description

This returns the numeric code corresponding to a specified value in an enumerated domain.

Hi ks,
Thanks for your immediate reply. but when i use this it returns long datatype, which again cannot used it in the
sql = "where tisfc001.osta = "& etol(tisfc001.osta) statement.
It shows illegal type string & long

Where are you doing this? In a baan program? Have you tried "where tisfc001.osta = " & str$(tisfc001.osta).

Thanks its works fine.

Regards,
Thamarai

Please do not delete threads that other people have made replies to.