goesflavio
30th June 2005, 02:23
I need to know how many values there are in the domain to know how many rows I'll have into the table.
Tks.

lbencic
30th June 2005, 03:41
I think you can use rdi.domain.enum - check out the help as a regular function.


Syntax
long rdi.domain.enum( string domain_name(14), ref long no_enum_items )

Description
This returns information about a domain of type DB.ENUM.

Arguments
domain_name
The name of the domain.

no_enum_items
The number of enum items in the specified domain.


Return values
0 success
-1 error

Context
Bshell function.

Rita Kotecha
4th July 2005, 15:46
Hi

If you need to know the Number of Values in the domain you can use ttadv401 with the 1st index to see the last but one record for each key. the field cnst gives you the No of Value for the domain.

The second part of the question was not very clear to me.

Hitesh Shah
4th July 2005, 20:46
Hi

If you need to know the Number of Values in the domain you can use ttadv401 with the 1st index to see the last but one record for each key. the field cnst gives you the No of Value for the domain.

The second part of the question was not very clear to me.

This is not always true . It's quite possible , developers may have deleted an option in between meaning the number enum options are less than the last number of constant . Further user has to know the VRC intricacies too . Rdi function suggested by Lisa would be a better option .

goesflavio
7th July 2005, 16:02
Hi people,
your answers help me a lot. I already rosolve my problem with your replay.
Tks a lot.