Cannot locate all the data items from a common start data

TeeBI for Embarcadero RAD Studio, Delphi and C++ Builder.
Post Reply
Roland
Newbie
Newbie
Posts: 7
Joined: Thu Jan 11, 2018 12:00 am

Cannot locate all the data items from a common start data

Post by Roland » Tue Mar 20, 2018 10:36 pm

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

Yeray
Site Admin
Site Admin
Posts: 9509
Joined: Tue Dec 05, 2006 12:00 am
Location: Girona, Catalonia
Contact:

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

Post by Yeray » 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:

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.
Best Regards,
ImageYeray Alonso
Development & Support
Steema Software
Av. Montilivi 33, 17003 Girona, Catalonia (SP)
Image Image Image Image Image Image Please read our Bug Fixing Policy

Post Reply