>Hi!
>
>If the underlying table only got one record the view can't find it, otherwise the view works perfectly.If I run the view from the IDE it works fine.
>
>What could be wrong?
>
>TIA

I would guess it may be some settings difference between IDE and exe which causes different set of records returned. Do you explicitly specify SET ANSI and SET DELETED in your application?