Hello,

I have a general question. Is there a benefit to using views on tables
with no joins?

For example, if I have a query that calls for active employees, then
need to query from those active, would it be better to ...

1) create a view that first grabs all the active employee, then to run
my query on the view; or

2) simply run the query on the table with multiple clauses in my Where
statement?

Which is faster? And, any other comments would be appreciated.

Jerry

-----Original Message-----
From: Marv Cook [mailto:mjcook@...]
Sent: Tuesday, July 02, 2002 10:35 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Moving data from Firebird to Access

Hi all,

I have a system programmed using Firebird, Delphi 5 Pro and IBO. The
client
is very happy with it and now wants to put the data on a web site. To
do
that, the IT department wants the web data in an Access or MSSQL DB.

Any suggestions on a tool to use to generate an Access or SQL database
and
populate it from Firebird using Delphi?

Thanks
Marv



________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/