Re: Batch Updates

I assume that this would need to be two seperate sql statements as I am not
aware of any way to include these two statements into one sql statement?

Thanks for your help I will give this a try!

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:6d94125sla4gdqn02o4h3d8oisq93kl4ki@xxxxxxxxxx

Trying to perform some type of batch update using ADO to an Access
database.
Is there a way similiar to the BDE batch move object that can be used in
ADO?
No

I am currently loading a delimited file into a query and then parsing the
query row by row and using either an insert or edit depending on whether
the
key field already exists to update my ADO table but this process is very
slow. It takes 4 minutes to do this process using ADO and only 10 seconds
to
use the BDE batch move and load it into a paradox table. (apx 65000
records)

Any help here would be much appreicated!
I suggest using an Update query followed by an Insert query

with an update looking like this

update table2 t
inner Join table2a t2
on t.id = t2.id
set t.name = t2.name

and an insert like this

insert into table2
(id, name)
Select id, name from Table2A Where Id not in (select ID from table2)


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages

  • Re: Batch Updates
    ... Excel ADO driver. ... I am currently loading a delimited file into a query and then parsing ... insert into table2 ...
    (borland.public.delphi.database.ado)
  • outer joins and edits
    ... Thanks to ADO, this query is editable - great so far. ... corresponding record in Table2 was found. ... I could of course split the query into a master detail relation, ...
    (borland.public.delphi.database.ado)
  • Re: Batch Updates
    ... my sql statement: ... I am currently loading a delimited file into a query and then parsing the ... key field already exists to update my ADO table but this process is very ... insert into table2 ...
    (borland.public.delphi.database.ado)
  • Re: Batch Updates
    ... I am currently loading a delimited file into a query and then parsing the ... key field already exists to update my ADO table but this process is very ... use the BDE batch move and load it into a paradox table. ... insert into table2 ...
    (borland.public.delphi.database.ado)
  • Re: outer joins and edits
    ... >Thanks to ADO, this query is editable - great so far. ... >The problem occurs, though, when I edit the field T2.Text where no ... >corresponding record in Table2 was found. ...
    (borland.public.delphi.database.ado)