Re: batch move in ado



yuda wrote:

Hello,
Is it posiable to move records from one table to another as batch in
ado. something like :
insert into X select * from Y where Y.f1 < 10

That is standard SQL so most databases should support it. SQL
capabilities are determined by the database, not by ADO.

--
Bill Todd (TeamB)
.



Relevant Pages

  • Re: Why not use DAO?
    ... You have been refering to DAO vs. ADO when these two things (in the context ... you must have ALREADY used a provider to get to. ... interface for working with JET databases. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Why not use DAO?
    ... Happy Christmas an fine holidays for you too. ... interface for working with JET databases. ... discussion about that (DAO was also faster as classic ADO) ... universal provider so ofcourse DAO wil outperform ADO in most ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Why not use DAO?
    ... Don't listen to those who say something about your English. ... interface for working with JET databases. ... discussion about that (DAO was also faster as classic ADO) ... universal provider so ofcourse DAO wil outperform ADO in most ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Why not use DAO?
    ... interface for working with JET databases. ... no discussion about that (DAO was also faster as classic ADO) ... more universal provider so ofcourse DAO wil outperform ADO in most ... i just wanted to make clear that you should compare these ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Why not use DAO?
    ... To me your opinion sure does mather, cause as i am not a native English ... interface for working with JET databases. ... discussion about that (DAO was also faster as classic ADO) ... universal provider so ofcourse DAO wil outperform ADO in most ...
    (microsoft.public.dotnet.languages.vb)