// 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()));
}