Daniel Albuschat ha scritto:

> There's an important thing to know
> here: I'm fetching
> only the primary keys from a result set to know how many rows there
> are and which
> primary key the row at the temporary "index" in my table has.

This is very interesting, since I thought that it would have been a
difficult task.
If your rows come from a join a single primary key is not enough: to
identify a row you need the primary key of all the table used in the join.
So it looks like your software needs to parse the SQL statement and to
automatically identify all the needed primary keys. At a second time,
when you need to retrieve the full row, you need to recreate if from the
primary keys.

I am not a Firebird expert, and I have written my own data access layer
on top of IBPP to satisfy my needs. It works well enough, but when I
create an editable rowset from a single table I pass the name of the
primary key as a parameter because I had no idea of hot to determine it
automatically.
It is not a big problem, but it would be nice to have the software
determine the primary key. Do know hot it can be done?

Thank you.

Fulvio Senore