>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.


Rich,

You are sure doing alot of work to get what Gendbc gives you for free. Gendbc is in FoxProRootDirectory\tools\gendbc

Just open your DBC, run gendbc, edit the prg generated and extract the code to create the view you want.