If you are simply loading a table use a TIB_DSQL component with an INSERT
statement with input parameters. Then, loop through your records and ExecSQL
each one after plugging in the values to the input parameters.

See the BlobInserts sample application for a model to follow when doing
this.

Your operation should take about 4 seconds or less when you get this right.

Hmm, 4 seconds or less. Would be perfect. But I'm not just loading a table. I need to see if the record exists already in the interbase table. If it exists, then I need to update it, otherwise I need to update it. If I understand your sentence above correctly, with the TIB_DSQL proposal I can only Insert records, not update them if they already exist.
Is there another way to mass update a interbase table from another database eg Access? (Instead of using Locate each time to check if the record already exists or not)

In fact you could look at what I'm trying to do this way:

A table from access is offered to the program. Then we need to push that data in an interbase table. Already existing records need to be updated and new records need to be added. So you can see the interbase table as the table which contains all the records and contains the latest information, while the Access table only contains new or updated data.


I couldn't wait checking the new version. But unfortunately there is no speed change.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com




Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]