Hi John!

Converting from BDE/Paradox to IBO/Firebird (Firebird is the
open-sourced daughter of InterBase, many of us think it is superior to
it's mother) is a big task. It is converting from BDE/Firebird to
IBO/Firebird that is what www.ibobjects.com mentions a a switch that can
be done in seconds.

> The SQL for the query is SELECT * FROM XXXXXXXX WHERE
> PERSONSNAME = RANKLEY ORDER ON OWNERNAME (Ownwername is a defined
> index).

This query doesn't benefit much from an index on Ownername, what you
want is an index on Personsname. Since I assume that field to be far
from unique, I think you should consider creating an index on
(PersonsName, PrimaryKeyField) - this makes updating and deleting faster.

Welcome to the world of client/server database programming!
Set