-
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
-
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
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|