I have a side question on this one. In my app, I need to read the table structure from a MSSQL2K database and then do my "Create Table" structure. Do you know how I might easily do that with ADO (using the Connection object reference to my MSSQL2K box)?

So I would be able to code:

arStructure = oConnMSSQL.Execute("GiveMeStructureOf ThisTable").GetRows

Then I could have an array that I could parse/feed to my VFP database, giving me a mirrored structure.

What do you think?


>I think for this it's easier to use the connection's execute method to send regular VFP SQL commands:
>

oConn.Execute "CREATE TABLE myTable (iID i PRIMARY KEY, desc c(30))"

>This creates the table with a couple of fields with iID being the primary key.
>HTH