#12358: Unable to bind rule on table column in sql server 2012

saima.alvi(*) reported 2014-07-01T07:25:26Z · last modified 2018-03-08T22:35:09Z

Dev	SachinPrakash
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - MS SQL Server
Version	Future

Product: Aqua Data Studio

Version: 15.0.0-dev-356

Build #: 38873

Build Date: 2014-Jun-30 04:55:44 PM

Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / IN / Oracle Corporation 1.7.0_60-b19

Memory: Max=704,643,072; Total=282,066,944; Free=168,267,984; CPUs=8

Issues:Unable to bind rule on table column in sql server 2012

Steps to reproduce:

1)In ADS connect to sql server 2012 and in any database run the given create rule script.

//create rule script

CREATE RULE "db_accessadmin"."test_bind"

@c1>1 and @c1<1000

2)In same database Right click on tables folder and select option "create table"

In create table GUI

Enter valid table name

Enter column name uncheck allow null option.

4)Go to column section to set property of column.

From drop down list of Rule name option, select rule "test_bind"

5)Switch to preview sql tab.

--->you will observe that script to bind rule on the column is not generated.

All Comments (0) Change History