> 1. I've the following view :
>
> select PERSONS.*, ZIPCODES.CITY
> from PERSONS, ZIPCODES
> where PERSONS.POSTCODE_ID=ZIPCODES.POSTCODE_ID

Try

SELECT *
, ZIPCODES,CITY
FROM PERSONS
JOIN ZIPCODES
ON PERSONS.POSTCODE_ID=ZIPCODES.POSTCODE_ID

i tHINK THATS HOW ibo PERFERS IT <G>

> How can I use this view to edit, delete, update rows? Do I've to use a
> TIBOQuery component and add some sql language to update, edit, delete
> records (how are the syntaxes?) ? Or do I've to use an TIBOUpdateSQL?

Just set 'RequestLive' true and IBO will do the rest.

> 2. I need to import data from an Access database.
>
> At the moment I make a connection to the access database, iterate over each
> record of this access table. For each record I do the following: a locate in
> the interbase table. If the record exists, I update the data, if it doesn't
> exists I add the data.
>
> Is there another, better/quicker way to do such things?

Are you having to 'access' the Access database in the final
program? If so, then probably No.

I have been moving applications from Access because it was
useless, and so just dumped the original data to an
Interbase database ( Using Borland Datapump ), then worked
from that. Quite honestly I can't see much point in trying
to keep the Access bit, and those customers of mine are now
much more efficient and a lot happier with an IBO front end
to their data.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services