Hi I have some views that are UNIONS of two identical (asside from name) tables. I have noticed that some of these views have stopped functioning. Running a select on them returns no results (TIBOQuery) if I browse the data (from IB_UtilitiyBar) selecting the view displays a string or numeric overflow error.
Running a select on the view in FlameRobin correctly returns results. Running the views source query in IBOQuery works fine to. I suspect it is something to do with the logic used to determine the resulting field sizes from a view not correctly handling UTF8. It is data sensitive and I guess it only fails where stored data nears the field limit. The views work on some of my datasets :) I'm off home for the weekend soon so won't be able to reply for a while. Cheers Rob
