>I'm working on a project using xCase to model the data, Mere Mortals as my framework and SDT to manage the database.
>
>I've done the quick start with Mere Mortals to establish a project. Then I've gone and used xCase's tool to update the database. And I've used SDT Explorer setup extensions.
>
>SDT checks the validity of the database and I recognize that I had to add the Mere Mortals' tables back into the database.
>
>All the validation works fine, except two cases; lv_ControlSecurityGroups and lv_ControlSecurityUsers. It appears that I've over looked a table to add. Looking at the SQL statement it uses mmsecure and groups both are included in the database.
>
>Thanks for your help.
>Jon

Jon,

Did you run the createviews program? Also, did you update the xCase model from the database, or did you try to update the database from the xCase model. If the latter, xCase does not handle views very well (If at all, but I'm not sure because I used an older version.)

Once, you create your new project, and you run createviews and compile the database, you should be able to install the SDT metadata without problems. Then I would run xCase to update the database with any new tables you've added.

On a personal note, I would use xCase to update a SQL server database from a model made from VFP before I'd use it to update a VFP database. SDT can handle most database maintenance functions.

Let me know how things turn out.

Jim Weil