// Function to test SQL queries: public static String TestSQL(String sql, List <String> columns) { String response = ""; if (PriEngine.InitializeCompany(Settings.Default.Company.Trim(), Settings.Default.User.Trim(), Settings.Default.Password.Trim()) == true) { StdBELista list = PriEngine.Engine.Consulta(sql); response += "Numero de linhas: " + list.NumLinhas() + "\n"; response += "Numero de colunas: " + list.NumColunas() + "\n"; while (!list.NoFim()) { foreach (String column in columns) { response += column + ": " + list.Valor(column) + ";"; } response += "\n"; list.Seguinte(); } } return(response); }
// Function to initialize the default company: private static bool InitializeCompany() { return(PriEngine.InitializeCompany(Settings.Default.Company.Trim(), Settings.Default.User.Trim(), Settings.Default.Password.Trim())); }