View Full Version : Validation Rules for Attached MSSQL Tables


07-22-2010, 08:11 PM
Ladies / Gentlemen

I just watched the 6th Video ( Data Validation - Web Applications Videos ) on the http://news.alphasoftware.com/v10preview/videos.htm web site.

Are these rules enforced if the Table is an Attached MSSQL Table???

Mark Moss

Steve Workings
07-22-2010, 11:51 PM
Rules defined in the grid apply to SQL tables. Field rules as he demonstrates in the customer.dbf are, of course, not enforced against SQL tables.

07-22-2010, 11:56 PM

I guess that means that for every field that has a rule I will have to define that rule on every grid/form that I use that uses that field?

Say it ain't so.

Mark Moss

07-23-2010, 08:19 AM
There is limited support on field rules in a dbf file attached to a backend DB.
For each table you need a Active Link.

In your Grid "Honor DBF rules " must be set to true [checked]