, 21 2015 . 09:35
+
, ?
---------------------------
Project1
---------------------------
.
---------------------------
---------------------------
? access
SELECT .[_], ., ., ., *
FROM INNER JOIN ( INNER JOIN ON . = .[ ]) ON . = .[_]
WHERE ((([].[_])=[ ]));
:
AnsiString sql;
DataModule5->StudQuery->SQL->Clear();
DataModule5->StudQuery->Active=false;
for(int i=0; iItems->Count;i++)
{
if (ListView2->Items->Item[i]->Checked) {
if (sql!="")
{
sql+=" or " ;
}
sql+= "[].[_]=" + ListView2->Items->Item[i]->SubItems->Strings[0];
}
}
DataModule5->StudQuery->SQL->Text ="SELECT .[_], "
"., ., ., *"
"FROM INNER JOIN ( INNER JOIN ON . = .[ ]) "
"ON . = .[_] "
"where (" + sql +")";
DataModule5->StudQuery->Active=true;
http://www.sql.ru/forum/1157711/nesootvetstvie-tipov-dannyh
