John,

I found code from Doug H. on Wiki last night about copying views out to a DBC by USEing the DBC and then do a create Table from the query into another DBC and then setting the 28th byte to a CHR(7) to make VFP see it as a DBC but it didn't fly. I then worked until about 12am last night trying to see what was up. No solution so I emailed Doug to see if he knew and I'm waiting for a response as to why VFP says it's not a DBC.

I thought I would just write code to loop through all of the objects and then copy them into another DBC looking for Views like Doug had in his code. I can get all the records just VFP chokes.

Another "cool feature" I learned is how to totally break views by writing code to Alter Tables and change a couple of fields that were being used in a View.