Devart Forums

Posted: **Wed 20 Jul 2011 12:45**

Hi, how could I access via code those restrictions ?
and how could I access Metadata.Table_Schema.Value ?

example Like in: (I know it is no good code that's why I ask.)

Code: Select all

  // >> I want to set the current Table_Schema value
  MyMetaData.Restrictions.Table_Schema := 'cumul';

  // >> I want to get the current Table_Schema value like we usualy do
  vSchema := MyMetaDataTable_Schema.AsString;

Thanks

Posted: **Wed 20 Jul 2011 15:03**

Hello,

To set the TABLE_SCHEMA restriction, you should use the following code:

Code: Select all

MyMetaData.Restrictions.Values['TABLE_SCHEMA'] := 'cumul';

, and to get it this code:

Code: Select all

vSchema := MyMetaData.Restrictions.Values['TABLE_SCHEMA'];

Posted: **Thu 21 Jul 2011 19:40**

Thanks, works well.