TableAdapter MySQL parse error

TableAdapter MySQL parse error

Postby 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;
griff
 
Posts: 2
Joined: Thu 28 Feb 2008 18:05

Postby Alexey.mdr » Thu 06 Mar 2008 06:35

Could you please post or send me (alexeyman*crlab*com) the tables definition script?
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for MySQL