Cannot locate all the data items from a common start data
Posted: Tue Mar 20, 2018 10:36 pm
I use a query and get the error in the subject.
What can I do?
What can I do?
Steema Software - Customer Support Forums
https://407832.verdetrade-hk.tech/support/
https://407832.verdetrade-hk.tech/support/viewtopic.php?f=23&t=16862
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;