Steema Central

Posted: **Tue Mar 20, 2018 10:36 pm**

I use a query and get the error in the subject.
What can I do?

Posted: **Fri Mar 23, 2018 12:27 pm**

Hello,

It seems to work fine for me adding a button to the TeeBI_Grid_Demo example with this code:

uses BI.DataSource;

procedure TGridDemoForm.Button1Click(Sender: TObject);
var Query1 : TDataSelect;
    Customers: TDataItem;
begin
  Customers:=TStore.Load('BISamples','SQLite_Demo')['Customers'];

  Query1 := TDataSelect.Create(Self);

  // "select CompanyName, City from Customers order by City"
  Query1.Add(Customers['CompanyName']);
  Query1.Add(Customers['City']);
  Query1.SortBy.Add(Customers['City']);

  BIGrid1.Data:=Query1.Calculate;
end;

If you still find problems with it, could you please arrange a simple example project we can run as-is to reproduce the problem here?

Thanks in advance.

Steema Central

Cannot locate all the data items from a common start data

Cannot locate all the data items from a common start data

Re: Cannot locate all the data items from a common start data