I have a program that I want to distribute to different companies.  They
will enter their own data into the same database.  I want them each to see
only their data.

In a few tables I have a companyid field that is an integer.  One company
will only see their data so the filter would be something like "companyid =
3".

Is there any problem setting a filter on the actual table at runtime and
then using sql to chop up the data even more for reports and user filtering?

Or is there a better way to do this?  Looking for the least complicated way
and also the best way to minimize bandwidth.

David,

<< Is there any problem setting a filter on the actual table at runtime and
then using sql to chop up the data even more for reports and user filtering?
>>

No, filtering and the SQL execution all take place in the engine, so this
isn't an issue with C/S.  Just make sure that the filter is optimized.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:F62EE64D-DE65-4CF7-8018-8BAB2B9BA171@news.elevatesoft.com...
> David,
>
> << Is there any problem setting a filter on the actual table at runtime
> and then using sql to chop up the data even more for reports and user
> filtering?
> >>
>
> No, filtering and the SQL execution all take place in the engine, so this
> isn't an issue with C/S.  Just make sure that the filter is optimized.
>

How do you set a filter at the database (not the specific component tTable
or tQuery) level?

Robert

Robert,

<< How do you set a filter at the database (not the specific component
tTable or tQuery) level? >>

You can't, and that's not how I read what he was requesting.  I read it as
asking whether you can use both filters on tables and SQL with the proper
WHERE restrictions in the same application.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:45A81289-0C85-4719-AF36-23F7205BDC21@news.elevatesoft.com...
> Robert,
>
> << How do you set a filter at the database (not the specific component
> tTable or tQuery) level? >>
>
> You can't, and that's not how I read what he was requesting.  I read it as
> asking whether you can use both filters on tables and SQL with the proper
> WHERE restrictions in the same application.
>

IC. OP had written

"In a few tables I have a companyid field that is an integer.  One company
will only see their data so the filter would be something like "companyid =
3".

Is there any problem setting a filter on the actual table at runtime and
then using sql to chop up the data even more for reports and user
filtering?"

so I understood that he wanted to filter the table at the application
level - ie, that all queries would only see the unfiltered portion of the
table. Otherwise why would there be any problem with having the same filter
in every component?

Robert

Robert,

<< so I understood that he wanted to filter the table at the application
level - ie, that all queries would only see the unfiltered portion of the
table. Otherwise why would there be any problem with having the same filter
in every component? >>

How would I know that ?  I didn't ask the question, so I can only assume
what the poster does or does not know about what limitations there are in
DBISAM vs. other database engines.   You cannot assume that someone
automatically knows what DBISAM can or cannot do, and other database engines
can have very odd restrictions with certain features.

--
Tim Young
Elevate Software
www.elevatesoft.com