Hi Macer,

>ALTER TABLE myTable
> ALTER COLUMN myColumn SET CHECK Field_Valid(myColumn)
Thanks,
I'm now checking out dbc_AfterModifyTable() to do just what you suggested.


>Personally, I don't favour this approach as I like to separate business logic out of the database. This makes it easier to port your application onto other databases etc.

I don't understand this. How can you separate business logic away from the database? By definition the database is a business entity. It seems to me that by keeping the business logic with the database and excluded from any app, you can use several different apps with the same database.