🚀 go-pugleaf

Hi all, I'm having a problem with SQL and the use of a 'sales' database
(defined using BDE), can anyone shed some light on this please?

The first code sample below works OK but when the 'group
by' clause is added (sample 2), the table is not saved to the specified
'sales'
database (the 'sales' database exists on a network drive and is defined
in the BDE
Administrator) but to the directory that the 'tables' tab is set to in
the
Navigator at the time the program is run.

Sample 1
-----------
open database sales
set database to sales

select year_date, customer, tonnes;
 from :sales:budget;
 save to :sales:summary.dbf

sample 2
----------
open database sales
set database to sales

 select year_date, customer, sum(tonnes) tonnes;
   from :sales:budget;
   group by year_date, customer;
   save to :sales:summary.dbf


I have also tried this with other tables with the same result.

TIA....Robert.