HYTOS

        public static DataTable SelectTieInSymbolAttribute()

        {

            DataTable dt = null;

            ID2Info id2Info = ID2Info.GetInstance();

            using (IAbstractDatabase connection = id2Info.CreateConnection())

            {

                try

                {

                    // var query = "SELECT DISTINCT Attribute, DisplayAttribute FROM SymbolAttribute;";

                    var query = string.Empty;

                    if (id2Info.ID2DBType == ID2DB_Type.MSSQL)

                        query = "SELECT DISTINCT Attribute FROM SymbolAttribute WHERE SymbolType_UID IN(SELECT SymbolType_UID FROM Symbol WHERE CONVERT(varchar(Max), isnull([Name], '')) = 'TIEINPOINT');";

                    else

                        query = "SELECT DISTINCT Attribute FROM SymbolAttribute WHERE SymbolType_UID IN(SELECT SymbolType_UID FROM Symbol WHERE ifnull([Name], '') = 'TIEINPOINT');";

                    using (var ds = connection.ExecuteDataSet(connection.GetSqlStringCommand(query)))

                    {

                        dt = ds.Tables[0].Copy();

                    }

                }

                catch (Exception ex)

                {

                    Log.Write(ex.Message + "\r\n" + ex.StackTrace);

                }

            }

            return dt;

        }