1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| for ( int i=0; i<DataModule1->DSNListe->Count; i++)
{ TQuery* QueryTable;
QueryTable = new TQuery(NULL);
QueryTable->DatabaseName=DataModule1->DSNListe->Strings[i];
QueryTable->Close();
QueryTable->SQL->Clear();
AnsiString QueryTable_Str;
QueryTable_Str ="SELECT table1.id, a, b, c ";
QueryTable_Str+= " FROM table1";
QueryTable_Str+= " LEFT OUTER JOIN table2 ON table1.id=table2.id";
QueryTable_Str+= " WHERE table1.id=";
QueryTable_Str+= id;
QueryTable_Str+= " ORDER BY date DESC";
QueryTable_Str+= " LIMIT 0,300";
QueryTable->SQL->Add(QueryTable_Str);
QueryTable->Open(); |
