PDA

View Full Version : Validation Rules for Attached MSSQL Tables


ABC123

markmoss
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.

markmoss
07-22-2010, 11:56 PM
Steve


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
:mad:

bea2701
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]