Cannot locate all the data items from a common start data

[Roland]

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

[Yeray]

Hello,

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

Code: Select all

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.