DBGRID显示列名出错的问题
目前我有一个疑问，是有关DBGRID的显示问题，如果我运行如下的SQL语句：
select recipe_Id as 编号, cast(symptom as varchar) as 备注,Date as 日期, A1_Name as 产品1名称,A1_Num as 产品1数量,A1_unit as 产品1规格,a2_name as 产品2名称,A2_Num as 产品2数量,A2_unit as 产品2规格,a3_name as 产品3名称,A3_Num as 产品3数量,A3_unit as 产品3规格 from West where Dat= '2007-01-01 '
显示正常后。
在我修改了语句后(只在显示下一个产品的名称时带上产品1/产品2/产品3，而显示数量、规格则前面不带 '产品1/产品2/产品3 '这种产品序号)：
select recipe_Id as 编号, cast(symptom as varchar) as 备注,Date as 日期, A1_Name as 产品1名称,A1_Num as 数量,A1_unit as 规格,a2_name as 产品2名称,A2_Num as 数量,A2_unit as 规格,a3_name as 产品3名称,A3_Num as 数量,A3_unit as 规格 from West where Dat= '2007-01-01 '
这个时候问题出来了，DBGRID在显示 "A2_Num as 数量,A2_unit as 规格 " 这里时，显示的不是 "数量 规格 "，而是 "数量_1 规格_1 "，而在显示 "A3_Num as 数量,A3_unit as 规格 "时显示的是 "数量_2 规格_2 "。也就是后面多了一个比当前数字小1的数字。
[解决办法]
A1_Num as 数量
A2_Num as 数量
A3_Num as 数量
你一个查询里面有三个字段都是数量，肯定显示数量_1 数量_2 数量_3咯，
规格的也同样道理
[解决办法]
字段重名，可以用DBGridEh进行多标题显示
[解决办法]
呵呵，SQL中尽量不要使用相同的字段名，有的话改一下区分开来，不然会影响后续的操作
