ADO and copying tables


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: ADO and copying tables

  1. #1
    aj Guest

    ADO and copying tables


    hi, i was wondering if there was a command i could use in ADO or perhaps some
    other technology that would let to copy tables in MS ACCESS or Oracle --
    i want ASP to copy a table when a user registers. It seems like ADO command
    object only supports insert, delete and update.
    thx in advance

  2. #2
    Veign Guest

    Re: ADO and copying tables

    The general syntax of the "copy table" SQL is:


    SELECT * INTO <Target> FROM <Source>If you need to first create a table,
    then use the CREATE TABLE command.Also, check out my SQL Quick Reference
    Guide on the Veign website....
    -- Veignwww.veign.com<<NEW Link200 v2.0.2 Released>> - Bigger, Better,
    Cleaner!http://www.veign.com/download_applic...ml#Link200Code Samples & Sample
    Projectshttp://www.veign.com/information/application/info_app.htmlNEW! -
    Quick Reference Guideshttp://www.veign.com/company_store.html------"aj"
    <discodude9000@yahoo.com> wrote in message
    news:3de2d1e9$1@tnews.web.devx.com...
    >
    > hi, i was wondering if there was a command i could use in ADO or perhaps

    some
    > other technology that would let to copy tables in MS ACCESS or Oracle --
    > i want ASP to copy a table when a user registers. It seems like ADO

    command
    > object only supports insert, delete and update.
    > thx in advance




  3. #3
    aj Guest

    Re: ADO and copying tables


    thx for responding--i should be more specific -- question is can i attach
    this sql to an ADO object.command object since the book mentions that it
    will work for update, insert and delete operations and doesnt say anything
    about copy and create commands. could there be another ADO object that may
    do the trick if not..also can this be done using access, if not will it
    work in oracle?

    "Veign" <NOSPAMinveign@veign.com> wrote:
    >The general syntax of the "copy table" SQL is:
    >
    >
    >SELECT * INTO <Target> FROM <Source>If you need to first create a table,
    >then use the CREATE TABLE command.Also, check out my SQL Quick Reference
    >Guide on the Veign website....
    >-- Veignwww.veign.com<<NEW Link200 v2.0.2 Released>> - Bigger, Better,
    >Cleaner!http://www.veign.com/download_applic...ml#Link200Code Samples & Sample
    >Projectshttp://www.veign.com/information/application/info_app.htmlNEW! -
    >Quick Reference Guideshttp://www.veign.com/company_store.html------"aj"
    ><discodude9000@yahoo.com> wrote in message
    >news:3de2d1e9$1@tnews.web.devx.com...
    >>
    >> hi, i was wondering if there was a command i could use in ADO or perhaps

    >some
    >> other technology that would let to copy tables in MS ACCESS or Oracle

    --
    >> i want ASP to copy a table when a user registers. It seems like ADO

    >command
    >> object only supports insert, delete and update.
    >> thx in advance

    >
    >



  4. #4
    Veign Guest

    Re: ADO and copying tables

    If you executing SQL commands against ADO then excute thenm using the
    Execute method of the Connection object...There is no need to use the
    command object..

    --
    Veign
    www.veign.com
    <<NEW Link200 v2.0.2 Released>> - Bigger, Better, Cleaner!
    www.veign.com/download_application.html#Link200
    Code Samples & Sample Projects
    http://www.veign.com/information/app.../info_app.html
    NEW! - Quick Reference Guides
    http://www.veign.com/company_store.html
    ------
    "aj" <discodude9000@yahoo.com> wrote in message
    news:3de456d5$1@tnews.web.devx.com...
    >
    > thx for responding--i should be more specific -- question is can i attach
    > this sql to an ADO object.command object since the book mentions that it
    > will work for update, insert and delete operations and doesnt say anything
    > about copy and create commands. could there be another ADO object that

    may
    > do the trick if not..also can this be done using access, if not will it
    > work in oracle?
    >
    > "Veign" <NOSPAMinveign@veign.com> wrote:
    > >The general syntax of the "copy table" SQL is:
    > >
    > >
    > >SELECT * INTO <Target> FROM <Source>If you need to first create a table,
    > >then use the CREATE TABLE command.Also, check out my SQL Quick Reference
    > >Guide on the Veign website....
    > >-- Veignwww.veign.com<<NEW Link200 v2.0.2 Released>> - Bigger, Better,
    > >Cleaner!http://www.veign.com/download_applic...ml#Link200Code Samples &

    Sample
    > >Projectshttp://www.veign.com/information/application/info_app.htmlNEW! -
    > >Quick Reference Guideshttp://www.veign.com/company_store.html------"aj"
    > ><discodude9000@yahoo.com> wrote in message
    > >news:3de2d1e9$1@tnews.web.devx.com...
    > >>
    > >> hi, i was wondering if there was a command i could use in ADO or

    perhaps
    > >some
    > >> other technology that would let to copy tables in MS ACCESS or Oracle

    > --
    > >> i want ASP to copy a table when a user registers. It seems like ADO

    > >command
    > >> object only supports insert, delete and update.
    > >> thx in advance

    > >
    > >

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center