>I need a dual database in my application: SQL and Foxpro Tables (FOX2X not DBC).
>
>I need to create the tables for both programmatically.
>
>Working with Microsoft SQL and SQLCommand() it’s very easy to create a new database and the tables. This is working.
>
>I need the equivalent with OleDbCommand(), or am I just creating tables with SELECT statements (i.e. WHERE False – create table without records) and that’s all there is to it? How do I create indexes (CDXs) on these tables that will allow subsequent SQL commands to use Rushmore?
>
>The documentation for Microsoft’s Transact-SQL is very good, is there similar documentation for Foxpro table usage through OleDbCommand()?
>
>Thanks in advance.
Derek,
See
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1862512&SiteID=1 and also search there for ALTER OleDb samples.
If it's not broken, fix it until it is.
My Blog