>I've got a view that's breaking the VFP view designer, so I'll have to maintain it in code. Where do I put this code so Mere Mortals will use it in a business object?
Hi Chris,
The view designer is just one way to insert a view record into the dbc. There are other ways. One is to create your view by code: look at the syntax of CREATE SQL VIEW, it will build your view. After that you'll have to set its properties with CURSORSETPROP(). Not complicated, but tedious.
Before doing all this, explore your dbc in code (myDB.prg in the example hereunder) with the gendbc utility provided by VFP. You'll find somewhere all the views that you created with the view designer
OPEN DATABASE myDB
DO (HOME(1)+"TOOLS\GENDBC\gendbc") WITH "myDB.PRG"
José