TableAdapter MySQL parse error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
griff
Posts: 2
Joined: Thu 28 Feb 2008 18:05

TableAdapter MySQL parse error

Post by griff » Wed 05 Mar 2008 22:22

I have a MySQL query that successfully executes in the MySQL Query Browser, but when I include this query in the Query Builder of Table Adapter, I get the error:

“Error in GROUP BY clause. Unable to parse query text.”

Here is the query. Any ideas what the problem is?

Thanks,
Griff

SELECT id, MAX(trade_date) AS MaxTradeDate
FROM (SELECT overnight_position_option.trade_date, `option`.security_id, `security`.id, `security`.name
FROM (`security` INNER JOIN
(`option` INNER JOIN overnight_position_option
ON `option`.security_id = overnight_position_option.security_id)
ON `option`.underlier_id = `security`.id)) AS LastTrade
GROUP BY id;

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Thu 06 Mar 2008 06:35

Could you please post or send me (alexeyman*crlab*com) the tables definition script?

Post Reply