Hi,

Some questions, I hope sombody can help me.

1. I've the following view :

select PERSONS.*, ZIPCODES.CITY
from PERSONS, ZIPCODES
where PERSONS.POSTCODE_ID=ZIPCODES.POSTCODE_ID

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?

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?

Thanks in advance,
Tom.