private void fetchAdditionalDetails(Option o)
{
string whereset = "", startup = "", fullval="";
if (o.Group == "GRAPH")
{
txtHowset.Text = "<not applicable for Graph options>";
txtStartup.Text = "<not applicable for Graph options>";
}
else
{
getOptionInfo(o.Name, ref whereset, ref startup, ref fullval);
txtHowset.Text = whereset;
txtStartup.Text = startup;
txtCurrentValue.Text = fullval;
}
}
private void RetrieveOptionValues()
{
SasServer s = cmbServers.SelectedItem as SasServer;
dServerVer = 9.2;
string ver = s.GetSasMacroValue("SYSVER");
try
{
dServerVer = Convert.ToDouble(ver);
}
catch { }
using (System.Data.OleDb.OleDbConnection dbConnection = s.GetOleDbConnection())
{
//----- make provider connection
dbConnection.Open();
//----- Read values from query command
string sql = @"select * from sashelp.vallopt order by optname";
OleDbCommand cmdDB = new OleDbCommand(sql, dbConnection);
OleDbDataReader dataReader = cmdDB.ExecuteReader(CommandBehavior.CloseConnection);
try
{
Options = new List<Option>();
while (dataReader.Read())
{
Option opt = new Option()
{
Name = dataReader["optname"].ToString(),
Setting = dataReader["setting"].ToString(),
Type = dataReader["opttype"].ToString(),
Description = dataReader["optdesc"].ToString(),
Level = dataReader["level"].ToString(),
Start = dServerVer > 9.2 ? dataReader["optstart"].ToString() : "",
Group = dataReader["group"].ToString()
};
if (opt.Level.ToUpper() == "GRAPH")
{
opt.Group = "GRAPH";
opt.Level = "Portable";
opt.Start = "OPTIONS or GOPTIONS statement";
}
switch (opt.Start.ToLower())
{
case "anytime": opt.Start = "OPTIONS statement or startup";
break;
case "startup": opt.Start = "Startup only";
break;
case "": opt.Start = opt.Start = "(requires SAS 9.3 or later to determine)";
break;
default: break;
};
Options.Add(opt);
}
}
finally
{
dataReader.Close();
dbConnection.Close();
}
}
}