|
我在Sql 查询分析器中可用的SQL语句, 把它赋值给Query组件的CommandText 属性为何还会出错:
sql 语句:
select gz_Items.ItemName as 工资项目,ItemKind as 项目类型,InitialValue as 初始值,Expressions as 计算表达式
from gz_Set,gz_SetItems, gz_Items
where gz_SetItems.SetID=gz_Set.SetID and gz_SetItems.ItemID=gz_Items.ItemID
X3中的代码:
with gzxmQuery do
begin
close;
commandText:='select gz_Items.ItemID as 项目编号,gz_Items.ItemName as 工资项目,ItemKind as 项目类型,InitialValue as 初始值,Expressions as 计算表达式 from gz_Set,gz_SetItems, gz_Items where gz_SetItems.SetID=gz_Set.SetID and gz_SetItems.ItemID=gz_Items.ItemID';
open;
end;
报错信息为如下, 请问这是怎么回事呢?
|
|