|Subject||Re: [IBO] edit/add/update records in view|
> 1. I've the following view :Try
> select PERSONS.*, ZIPCODES.CITY
> from PERSONS, ZIPCODES
> where 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 aJust set 'RequestLive' true and IBO will do the rest.
> 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.Are you having to 'access' the Access database in the final
> 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?
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.
L.S.Caine Electronic Services