Martin Knapp wrote:
>
>(snip)
> supposed to make IMAGE/SQL TPI-sensitive. In other words, I should be
> able to submit an SQL Select statement, and IMAGE/SQL would work out
> whether or not to use TPI, and if so how.
>
> All the ways that Bradmark have explained of putting in conditions in
> IMAGE (eg ITEM = "<5") sound a bit iffy to me, if you had to use standard
> SQL to get the same result. Would anyone like to comment on this? What
> will be the limitations of using TPI with SQL access?
I haven't had a chance to verify this yet in the IMAGE/SQL code, however,
I believe the original concept was that an "ITEM < 5" select in IMAGE/SQL
will convert the DBFIND to ITEM = "<5".
The primary limitation to TPI/SQL will be keywording/relational access.
Only DBFIND mode 1 lookups will be provided on "Generic" index types.
--------------------------------------------------
Larry Boyd <[log in to unmask]>