Hi,

May I suggest adding a setup table with 3 fields.

Role, VariableName, VariableData

- Role containing the rolename/reference the setup should match,
- VariableName containing any name of an 'environmental' variable, eg.
DATEFORMAT, TIMEFORMAT, LANGUAGE, etc.
- VariableData containing the value for the environmental variable.

It might be interesting to somehow have this per user too, not only per
role. Havnt thought it through though.

best regards
Kim Madsen
kbm@...

>Sooner or later, you're going to need some environmental information
>about a connection to handle issues like the language in which messages
>are presented, the format of dates, the representation of the decimal
>separator, and the doohickey that separates clumps of three digits (i.e.
>100,000.00 vs 100.000,00). Not to mention the names of days of the week,
>months, etc. The fiscal year start dates fit in there.
>
>
>Regards,
>
>Ann

<www.ibphoenix.com

>We have answers.
>
>