Deleting tables from a FoxPro DB using ODBC

[Doug]

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

[Carl Karsten]

"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