В командном окне ввожу строку с запросом все отрабатывает нормально
в моем методе вылетает с ошибкой отсутствует :или неправильно объявлен group by.
Вот фрагмент метода ошибка возникает на последней строке:
d1 = CTOD(ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate1.Day))+"."+ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate1.Month))+"."+ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate1.Year)))
d2 = CTOD(ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate2.Day))+"."+ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate2.Month))+"."+ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate2.Year)))

Select product_id As pid, sum(nalichie) As ss FROM SKLAD Group BY product_id INTO CURSOR crSklad
Select product_id As pid, sum(amount) As ss FROM ZAKUPKI WHERE date >= d1 AND date <= d2 Group BY product_id INTO CURSOR crZak
Select product_id As pid, sum(amount) As ss FROM SALE WHERE date >= d1 AND date <= d2 Group BY product_id INTO CURSOR crSale
Select product_id As pid, sum(amount) As ss FROM VOZVRAT WHERE date >= d1 AND date <= d2 Group BY product_id INTO CURSOR crVozvrat
Select product_id As pid, sum(amount) As ss FROM SPISANIE WHERE date >= d1 AND date <=d2 Group BY product_id INTO CURSOR crSpisanie

Блин! не помогает! в group by и в select написал все по аглицки та же самая ошибка

Ой! Проблема такая. С вышеуказаными запросами разобрался, но почему-то
следующий сразу за ним запрос вылетает с той же ошибкой исполбзую vfp8.
Вот полный текст:
d1 = CTOD(ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate1.Day))+"."+ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate1.Month))+"."+ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate1.Year)))
d2 = CTOD(ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate2.Day))+"."+ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate2.Month))+"."+ALLTRIM(STR(ThisForm.Pageframe1.Page4.OLEDate2.Year)))
Select product_id As pid, sum(nalichie) As ss FROM SKLAD Group BY product_id INTO CURSOR crSklad
Select product_id As pid, sum(amount) As ss FROM ZAKUPKI WHERE date >= d1 AND date <= d2 GROUP BY product_id INTO CURSOR crZak
Select product_id As pid, sum(amount) As ss FROM SALE WHERE date >= d1 AND date <= d2 GROUP BY product_id INTO CURSOR crSale
Select product_id As pid, sum(amount) As ss FROM VOZVRAT WHERE date >= d1 AND date <= d2 Group BY product_id INTO CURSOR crVozvrat
Select product_id As pid, sum(amount) As ss FROM SPISANIE WHERE date >= d1 AND date <=d2 GROUP BY product_id INTO CURSOR crSpisanie
SELECT p.id,;
p.name,;
S.ss As Остаток1,;
p.price As Сумма,;
Sum(Z.ss) As Закуплено,;
Sum(V.ss) As Возврат,;
0 As Приход,;
Sum(SALE.ss) As Продано в сети,;
Sum(SP.ss) As Списано,;
0 As Расход,;
S.ss As Остаток2,;
0 As Сумма;
From PRODUCTS p;
LEFT JOIN crSklad S ON S.pid = p.id;
LEFT JOIN crZak Z ON Z.pid = p.id;
LEFT JOIN crSale SALE ON SALE.pid = p.id;
LEFT JOIN crVozvrat V ON V.pid = p.id;
LEFT JOIN crSpisanie SP ON SP.pid = p.id ;
GROUP BY p.id, p.name, p.price INTO CURSOR crResult