Are filters in edb different from dbisam?

RI is the standard. dbisam does not have ri. Is this bad, if
ri is enforced by code?

Sanford,

<< Are filters in edb different from dbisam? >>

They're pretty much identical except for the collation comparison portion:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=0&topic=16

You can force a specific type of collation on a column reference like this:

MyColumn COLLATE ANSI_CI = 'Test'

The above example will force the optimizer to use the case-insensitive ANSI
collation to perform the comparison.  In DBISAM, the equivalent would be:

UPPER(MyColumn) = UPPER('Test')

<< RI is the standard. dbisam does not have ri. Is this bad, if ri is
enforced by code? >>

It really depends upon how "public" the database is.  If the database can
only be accessed via your application, then the answer is no, it isn't bad.

--
Tim Young
Elevate Software
www.elevatesoft.com