iBase.ru Forum

Код: Выделить всё

DataSource.Open();
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
    Debug.Write("Read...");
}
reader.Close();
DataSource.Close();

Код: Выделить всё

SELECT
  INVOICES.DEPNO,
  INVOICES.INVN,
  INVOICES.INVDATE,
  COUNT(ORDSPEC.ARTNO)
FROM INVOICES
INNER JOIN ORDSPEC ON
  (ORDSPEC.INVNO = INVOICES.INVNO) AND
  (ORDSPEC.DEPNO = INVOICES.DEPNO)
WHERE
  (INVOICES.INVDATE > CURRENT_DATE - 14) AND
  (ORDSPEC.ARTNO <= 0)
GROUP BY
  INVOICES.DEPNO,
  INVOICES.INVN,
  INVOICES.INVDATE