Deleting tables from a FoxPro DB using ODBC


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Deleting tables from a FoxPro DB using ODBC

  1. #1
    Doug Guest

    Deleting tables from a FoxPro DB using ODBC


    I am connecting to a FoxPro database using the ODBC. Using VB I want to remove
    a table from the database. I have tried different things that work within
    FoxPro like "remove table <tablename>" and stored procedures but can't make
    them work from within VB. I'm assuming I need to treat it as a pass-through
    query since these aren't standard SQL statements. Any ideas?

    Doug

  2. #2
    Carl Karsten Guest

    Re: Deleting tables from a FoxPro DB using ODBC

    "drop table <tablename>."

    This worked:
    ? SQLSTRINGCONNECT("DSN=Visual FoxPro
    Database;UID=;PWD=;SourceDB=d:\temp\bat.DBC;SourceType=DBC" )
    ? SQLTABLES(1)
    BROWSE
    ? SQLEXEC( 1, "drop table tblb" )

    Carl Karsten


    "Doug" <thelawrences@msn.com> wrote in message
    news:3b03e4ec$1@news.devx.com...
    >
    > I am connecting to a FoxPro database using the ODBC. Using VB I want to

    remove
    > a table from the database. I have tried different things that work within
    > FoxPro like "remove table <tablename>" and stored procedures but can't

    make
    > them work from within VB. I'm assuming I need to treat it as a

    pass-through
    > query since these aren't standard SQL statements. Any ideas?
    >
    > Doug




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