Query1.Databasename=''; Query1.Close; Query1.SQL.text:='Select * From ":A库:A表" a Inner Join ":B库:B表" b On a.code=B.Code'; Query1.Open;
修改为: Query1.Close; Query1.Databasename=''; Query1.SQL.text:='Select * From ":A库:A表" a Inner Join ":B库:B表" b On a.code=B.Code'; Query1.Open;
各位大虾,多维库中的SQL查询表达式是类例下面这样的呀,不是连接多个库 with member [State].[qq] as 'sum(Except({[State].[country].members},{[State].[1]}))' Select {[Sales Units]} on columns, {[State].[Country].members,[State].[qq]} on Rows From Sales 在DELPHI中有一个DecisionCube控件就是用来连多维库的,但是找不到例子,郁闷啊
Query1.Close;
Query1.SQL.text:='Select * From ":A库:A表" a Inner Join ":B库:B表" b On a.code=B.Code';
Query1.Open;
Query1.Close;
Query1.Databasename='';
Query1.SQL.text:='Select * From ":A库:A表" a Inner Join ":B库:B表" b On a.code=B.Code';
Query1.Open;
with member [State].[qq] as
'sum(Except({[State].[country].members},{[State].[1]}))'
Select
{[Sales Units]} on columns,
{[State].[Country].members,[State].[qq]} on Rows
From Sales
在DELPHI中有一个DecisionCube控件就是用来连多维库的,但是找不到例子,郁闷啊