>Hi Bill,
>
>Where you able to create a program that reproduce this problem?
Hi Sergey,
I can reproduce this problem with a very complex view, 117 fields, 6 tables and 6+ filters. It's a view that I can't modify in the view designer (although it was created in the view designer).
I really don't want to try and explain all the relationshipes, filters, and fields in this thing. I can't imagine anyone could wade through it looking for what may be causing it. Even I can't figure out parts of it, and I built it.
I did sinplify it by taking out all the fields and putting them back in a few at a time. It worked until I had 65 (I think) fields, then when I added the 66th field (didn't make any difference which field I added), sys(3054) would crash my computer. I then changed it to t1.* instead of listing all the fields individually and it worked, but then it started crashing when I started adding joins. Since I can't get it into the view designer, but it was created there, I think there may be something wrong with the dbc file.
I'm going to rebuild it from scratch. It was a view that was created 1 1/2 years ago, and I just kept adding onto it as the client wanted more and more done. It's due for an overhaul anyway.
Bill Morris