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