At 08:57 PM 24-10-00 -0400, you wrote:

>Hi:
>
> Looked into Create View and don't see where you can pass
>paramters to a view to limit the number of records. If that is the
>case I would have to apply those parameters to the returned
>dataset with a filter and end up just as Crystal was doing.
>
> Is there a way to pass parameters in a call to Select View?

Yes: do it just the same as passing parameters to a table, i.e.
Select * from MyView
where Field1='SomeValue' and Field2='AnotherValue'
order by Field1, Field3

H.

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
___________________________________________________