I wish to thank Helen and Elita for their help.

Elita helped me indirectly to find the source of my error.

I tried to follow her advice and for convenience I created my view NOT
including all the fields of the underlying table. Initially it worked
but when I added a certain field if failed again. Looking better at
the domain that field was based I noticed that the 'collate' field was
empty.

Inserting a value there fixed the problem!!

thanks again!

elita lawalata wrote:

>maybe u can try this,
>
>CREATE VIEW VW_CUSTOMERS (-----UR RETURNS FIELDS
>NAMES---)
>AS
>---UR QUERY----;
>
>Thats what i always use.
>Hope it helped...
>
>eLita
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Mail Address AutoComplete - You start. We finish.
>http://promotions.yahoo.com/new_mail
>
>
>