Alan McDonald wrote:

>show us the view code..
>

Please read my answer to Svein Erling Tysvaer.

>I assume by select body you mean select the select code of the view?
>

Exactly

> -----Original Message-----
> From: Andrew Guts [mailto:andr@...]
> Sent: Monday, 16 September 2002 21:48
> To: IB support
> Subject: [ib-support] Please help. View is empty, but the same SELECT
>works!
>
>
> Hello all,
>
> I am so confused and really need help.
> Is there any reason why "SELECT * FROM View1" does not return any row
> (empty), but "SELECT" body of that view returns data as expected?
> Thanks ahead. I look forward hearing from you.
>
> Andrew
>
>
>