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