MetaData

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
777Yves
Posts: 37
Joined: Mon 09 Aug 2010 19:55
Location: Québec

MetaData

Post by 777Yves » 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

AndreyZ

Post by AndreyZ » 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'];

777Yves
Posts: 37
Joined: Mon 09 Aug 2010 19:55
Location: Québec

MetaData

Post by 777Yves » Thu 21 Jul 2011 19:40

Thanks, works well.

Post Reply