How to define a SQL query?

[Huskey]

Hi

I have been trying for few weeks to display the table
imported onto the Grid. The database is imported into the decisiontable using the code:
BOOL CODBCTableImporter::APPLYSTRUCTURE()
{..
...
ODBCTableImporter *importer =
dynamic_cast<ODBCTableImporter*>(ObjectManager::GetIdentifiedAlgorithm(ID));
DecisionTable *table = Creator:ecisionTable();
// Set importer parameters.
importer->SetDatabase(&database);
importer->SetTable(tablestring);
importer->SetSelected(columnselected);
importer->SetNames(columnnames);
importer->SetTypes(columntypes);
importer->SetScales(columnscales);

// Load table.
bool ok = (importer->Apply(*table) != NULL);
....
}

Now, how to specify the SQL Query so that I could attach
the query to the Grid in order to load the &quot;Table&quot; which has been imported. The table imported is no longer a CDatabase. It has been converted to DecisionTable. I deeply appreciate if any experts could provide me some hints and advices.

Thanks very much for your help.