首页 新闻 会员 周边 捐助

请教高手:NBearLite_v1.0.2.5 使用GROUPBY的疑问???

0
[已关闭问题]

NBearLite_v1.0.2.5 使用GROUPBY的疑问:

我想要的查询是:
SELECT [Work_holiday_order].[Center_name]
FROM [Work_holiday_order]
WHERE holiday_begin_time>='2008/11/01'
GROUP BY [Work_holiday_order].[Center_name]



程序上是这样写查询的:
                db.Select(FSJSJ.Work_holiday_order, FSJSJ.Work_holiday_order.Center_name)
                 .Where(FSJSJ.Work_holiday_order.holiday_begin_time >= YearANDmonth_begin)
                 .GroupBy(FSJSJ.Work_holiday_order.Center_name)
                 .ToDataSet();

可是NBearLite_v1.0.2.5生成的SQL语句是这样的:

SELECT [Work_holiday_order].[Center_name]
FROM [Work_holiday_order]
GROUP BY [Work_holiday_order].[Center_name]
HAVING  holiday_begin_time>='2008/11/01'



是我语句写错了,还是Bug????

小龙3的主页 小龙3 | 初学一级 | 园豆:4
提问于:2008-11-07 15:06
< >
分享
其他回答(1)
0

db.Select(FSJSJ.Work_holiday_order, FSJSJ.Work_holiday_order.Center_name)
                 .Where(FSJSJ.Work_holiday_order.holiday_begin_time >= YearANDmonth_begin)
                 .GroupBy(FSJSJ.Work_holiday_order.Center_name)
                 .ToDataSet()

Group By中有空格,是排序的意思。你有空格吗?

NBearLite不会用。。。要熟人解答。。。。

XBW | 园豆:404 (菜鸟二级) | 2008-11-07 21:37
0

这是程序的bug

DOT高手 | 园豆:202 (菜鸟二级) | 2012-08-16 18:23
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册